SQL Formatter

SQL Formatter takes a query written as one long line and lays it out so you can see what it does. Major clauses start on their own lines, join conditions line up under their joins, lists of columns are broken sensibly, and subqueries are indented inside their parentheses.

Keyword case is normalised to whichever convention you prefer, with uppercase keywords against lowercase identifiers being the most common choice because it makes the structure of a query visible at a glance. String literals, quoted identifiers and comments are detected and passed through exactly as written.

This is a layout tool rather than a parser, which means it handles dialect differences gracefully and never refuses to format something it has not seen. It will not validate your query or tell you whether it will run; it will make a four-hundred-character line into something a person can read, which is usually the problem at hand.

• Major clauses on their own lines
• Joins and their conditions aligned
• Subqueries indented inside parentheses
• Uppercase, lowercase or unchanged keyword case
• Strings, quoted identifiers and comments preserved
• Handles several statements separated by semicolons
• Copy or download the result

The sql formatter is used by writers, developers, students, marketers and anyone else who needs the job done once without installing software. Common cases include:

• Reading a query pulled from application logs
• Reviewing a colleague's query before approving it
• Tidying a query before adding it to a repository
• Understanding a generated query from an ORM
• Teaching how a complex query is structured