About the SQL Formatter

Format SQL for your database dialect.

How to use the SQL Formatter

1. Paste your code into the input box, or click Sample to load an example.
2. Choose the Dialect (Standard SQL, MySQL, PostgreSQL, T-SQL or PL/SQL), the Indentation and whether to Uppercase Keywords.
3. Press Beautify & Format SQL.
4. Use Copy (or Download where shown) to keep the result. Clear empties the box.

Worked example

When to use the SQL Formatter

• Making a long single-line query from a log, an ORM or a colleague readable before you debug it.
• Keeping the SQL in a code review or a shared document in one consistent style.
• Spotting a missing join condition, a misplaced parenthesis or a stray comma by looking at the layout.
• Preparing queries for documentation, tutorials and interview answers.

Common mistakes to avoid

• Choosing the wrong dialect. T-SQL, PL/SQL, MySQL and PostgreSQL each have their own quoting rules and functions, and the formatter needs the right one to lay them out properly.
• Assuming a neat layout means the query is correct. Formatting changes only whitespace, not the logic, so a wrong JOIN still returns wrong rows.
• Pasting queries that contain real customer data or credentials. Replace them with dummy values first.

Tips

• Choosing the right dialect keeps dialect-specific syntax intact.
• Write keywords in uppercase and identifiers in lowercase. It makes queries far easier to scan.
• Put each column of a long SELECT list, and each JOIN and condition, on its own line.