SQL Formatter / Beautifier

Paste unformatted or minified SQL and get a clean, consistently indented query back — runs entirely in your browser.

Dialect

Input

Formatted

SELECT
  u.id,
  u.name,
  count(o.id) AS order_count
FROM
  users u
  LEFT JOIN orders o ON o.user_id = u.id
WHERE
  u.active = TRUE
GROUP BY
  u.id,
  u.name
HAVING
  count(o.id) > 0
ORDER BY
  order_count DESC
LIMIT
  20;