SQL Formatter

This SQL formatter turns a query copied from a log, an ORM or a colleague's message into readable, consistently indented SQL. Each clause starts on its own line, columns and conditions are listed one per line, and joins and subqueries are indented, so you can see the structure of a query at a glance and spot a missing condition. It understands the syntax of 16 databases, including MySQL, PostgreSQL, SQL Server, Oracle, SQLite, BigQuery and Snowflake.

Before and After

select u.id, u.name, count(o.id) orders from users u left join orders o on o.user_id = u.id where u.active = 1 group by u.id, u.name order by orders desc;

SELECT
  u.id,
  u.name,
  COUNT(o.id) orders
FROM
  users u
  LEFT JOIN orders o ON o.user_id = u.id
WHERE
  u.active = 1
GROUP BY
  u.id,
  u.name
ORDER BY
  orders DESC;

Dialect Differences the Formatter Knows

SQL Style Tips

• One clause per line (SELECT, FROM, WHERE, GROUP BY, ORDER BY) makes long queries easy to scan and gives cleaner diffs in code review.
• Name your joins clearly. Short aliases such as o for orders are fine; aliases like t1 and t2 make the formatted query harder to follow.
• Put AND and OR at the start of the line, as this formatter does, so each condition can be read, commented out or removed on its own.
• Format before you compare. To see what changed between two versions of a query, format both the same way and compare them in the diff checker.

Related Tools

Format the JSON a query returns with the JSON formatter, turn query results saved as CSV into JSON with CSV to JSON, or test a pattern for a REGEXP condition in the regex tester.

Frequently Asked Questions