Format a MySQL Query Online

Formatting rewrites the query in place in the editor. Each major clause (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT and the rest) starts on its own line, every join gets a line of its own, and ON, AND, OR and the CASE keywords are indented one level under whatever they belong to. Parentheses drive the indent, so a subquery steps in and then back out.

Backtick-quoted identifiers are recognized and left exactly as written, which is what makes this practical on MySQL specifically: a column called order, key or status survives a pass that would otherwise treat it as a keyword. Single-quoted strings and comments are protected the same way.

Three controls shape the result: keyword case set to uppercase, lowercase or preserved; comma placement, which decides whether a column list reads with the comma at the end of each line or at the start of the next; and a two or four space indent. Minify does the reverse and collapses the statement back onto one line.