MySQL has its quirks. Backtick-quoted identifiers, REPLACE INTO statements, ENGINE=InnoDB in table definitions — a generic SQL formatter often mangles these. This MySQL-specific SQL formatter handles all of them correctly.
If you work with MySQL regularly — whether it is WordPress schema dumps, Laravel migration files, or raw queries from phpMyAdmin — using the right dialect makes the difference between output that looks professional and output that looks broken.
MySQL has several syntax elements that do not exist in standard SQL. Using a generic formatter can cause problems:
`user_id`) may be treated as stringsREPLACE INTO formatted as two separate statementsENGINE= and CHARSET= clauses breaking indentationGROUP_CONCAT() getting inconsistent spacingSelecting the MySQL dialect tells the formatter to apply MySQL-aware rules. The result looks consistent with MySQL documentation and community conventions.
CREATE TABLE users (id INT AUTO_INCREMENT,name VARCHAR(100),email VARCHAR(255),created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(id))ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;CREATE TABLE users (
id INT AUTO_INCREMENT,
name VARCHAR(100),
email VARCHAR(255),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;The column list is aligned, the ENGINE clause stays on its own line, and table options are clearly separated from column definitions.
mysqldump produces thousands of lines. Formatting table definitions and insert statements before reviewing them makes schema audits much faster.
When you run EXPLAIN on a formatted query, it is much easier to map execution plan rows back to the actual SQL. An unformatted one-liner makes this nearly impossible.
INFORMATION_SCHEMA. These contain backtick-quoted identifiers that generic formatters handle poorly.Yes. Window functions (ROW_NUMBER(), RANK()), CTEs (WITH clauses), and JSON functions are all formatted correctly with the MySQL dialect selected.
The formatter preserves all CHARACTER SET and COLLATE clauses exactly as written. It only adjusts whitespace and indentation around them.