Free Online SQL Formatter

What the SQL Formatter does

The SQL Formatter rewrites a query with consistent indentation and line breaks and capitalizes keywords. Each clause starts on its own line (SELECT, FROM, JOIN, WHERE, GROUP BY, ORDER BY) and the columns or conditions under it are indented by two spaces.

It uses a SQL-aware formatter rather than plain text wrapping, so it understands joins, subqueries, CASE expressions, CTEs and string literals. Identifiers and values are left exactly as written; only spacing and keyword case change.

When to use it

• Reading a long one-line query copied from an ORM log, a monitoring tool or an error message.
• Preparing a query for code review, documentation or a pull request, so everyone reads the same layout.
• Cleaning up SQL before turning INSERT rows into data with the SQL (INSERT Statements) to JSON Converter.
• Spotting a missing join condition or a misplaced WHERE clause, which is much easier when every clause sits on its own line.

Worked example

Input

select u.id, u.name, count(o.id) as 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;

Output

SELECT
  u.id,
  u.name,
  count(o.id) AS 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;

Common questions about the SQL Formatter