SQL Formatter

SQL queries written on a single line are hard to scan for structure — where the WHERE clause starts, which columns are being joined, what's actually being selected. This formatter collapses your query's whitespace and then reinserts line breaks before major clause keywords (SELECT, FROM, WHERE, JOIN variants, GROUP BY, ORDER BY, and similar), and puts each comma-separated item in a SELECT or VALUES list on its own indented line.

It works by pattern-matching known keywords rather than fully parsing SQL grammar, which covers the overwhelming majority of everyday single-statement queries cleanly but isn't a substitute for a real SQL parser — deeply nested subqueries, vendor-specific syntax extensions, or unusual keyword usage inside string literals can format imperfectly. It also doesn't validate that the SQL is syntactically correct or would actually run against a database; it only reformats the text you give it.

This is handy for cleaning up a query copied from a log, an ORM's generated SQL, or a colleague's one-liner before reading or reviewing it, without needing to open a full database client just to reformat text.

Formatting does not change what a query does. It only adjusts whitespace and keyword case so structure is easier to read, review and diff in version control.

This formatter uses keyword rules and not a full parser for each SQL dialect, so vendor-specific syntax such as stored procedures can be laid out imperfectly. Always run the formatted query against a test database before using it, as with any tool-generated change.