Home › Tools

SQL formatter and beautifier

Paste a query to indent it clause by clause, with JOINs, subqueries, CASE expressions and WITH (CTE) blocks laid out readably. Works for MySQL, PostgreSQL, SQLite and SQL Server syntax.

🔒 Runs entirely in your browser. Nothing you paste is uploaded or sent to a server.

How the formatter lays out a query

Each main clause (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, SET, VALUES, RETURNING) starts a new line, and the items inside it are indented below it, one per line. JOINs are indented under FROM, and top-level AND/OR conditions get their own lines so you can comment them out one at a time. Subqueries and CTE bodies are indented one level deeper. Parentheses that are not subqueries (function calls, IN (1, 2, 3), window clauses like OVER (PARTITION BY …)) stay on one line.

String literals, quoted identifiers ("col", `col`, [col]), PostgreSQL dollar-quoted bodies ($$…$$) and comments are never changed. Only unquoted keywords and built-in function names are re-cased, which is safe because SQL keywords are case-insensitive.

Use it to find syntax errors

A formatter is a quick way to spot the cause of MySQL error 1064 and similar parse errors:

In PostgreSQL, a mixed-case identifier that is not quoted is folded to lowercase, which is the usual reason for column does not exist and relation does not exist.

Minify

Minify removes comments and line breaks, which is handy for log lines, one-line psql -c "…" commands or embedding a query in JSON. Watch out: a -- comment inside a minified query would comment out the rest of the line, which is why minify strips comments.

Last updated 2026-11-20.