Developer tool

SQL Formatter

Make dense SQL readable with practical keyword breaks and indentation.

Runs in your browser

SQL Formatterworks locally

Unformatted SQL

Result

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=true
GROUP BY u.id,
  u.name
ORDER BY orders DESC

How to use this SQL formatter

Paste the source text or code, then choose the conversion or formatting mode.
Review the formatted output and any syntax message. Check syntax, escaping, and edge cases against the source before using the result in a live project.
Check the output against the source, then copy or download the finished result.

About this SQL formatter

Use the SQL Formatter to make dense SQL readable with practical keyword breaks and indentation. The result changes when you adjust the values or options above.

You can also use it to check source text for structural or syntax problems.

Example

Paste a long SELECT statement with joins and conditions to put major SQL clauses on separate lines.

Common uses

→ make dense SQL readable with practical keyword breaks and indentation
→ check source text for structural or syntax problems
→ prepare a clean version for testing or reuse