SQL Formatter

Paste a query to get it neatly formatted — one clause per line, indented joins and subqueries, consistent keyword case — or minify it to a single line. Choose your dialect so its syntax (::casts, backticks, [brackets], $1 parameters) is understood.

How to format SQL

1. Paste one or more SQL statements, or open a .sql file.
2. Choose the dialect, keyword case (UPPER is the most common convention) and indentation.
3. Copy the result or download it. Switch to Minify to strip comments and line breaks for embedding a query in code or a URL.

Before and after

select u.id, 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

SELECT
  u.id,
  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

Which dialect should I choose?

If a query fails to format, the message shows where the parser stopped — the usual cause is a dialect-specific feature with Standard SQL selected.

Formatting doesn't change what the query does

Only whitespace and keyword case change; identifiers, string literals and comments are kept. Minify mode removes comments but keeps optimizer hints like /*+ INDEX(t idx) */.

Related tools

• JSON formatter & beautifier
• HTML Formatter & Beautifier
• JSON to CSV Converter
• Mock API — host fake JSON endpoints