SQL Formatter

Queries copied from application logs, ORMs, and monitoring tools usually arrive as one very long line. The formatter breaks them into clauses, indents subqueries and CASE expressions, and lists columns and conditions one per line, so you can see what the query actually does.

select id, email from users where active = 1 and created_at > ? order by id

SELECT
  id,
  email
FROM
  users
WHERE
  active = 1
  AND created_at > ?
ORDER BY
  id

• Readable layout

  Each clause (SELECT, FROM, WHERE, GROUP BY…) starts a new line, columns and conditions are listed one per line, and subqueries, CASE expressions, and long column lists are indented.

• Syntax highlighting

  Keywords, functions, strings, numbers, placeholders, and comments are colored so you can scan the query at a glance.

• Many dialects

  PostgreSQL ($1, ::casts, JSON operators, $$ bodies), MySQL (backticks, ON DUPLICATE KEY UPDATE), SQL Server ([brackets], @params), and SQLite.

• Keyword casing

  Uppercase, lowercase, or keep keywords as written. Identifiers, strings, and comments are never changed.

• Catches syntax errors

  Unclosed strings, quoted identifiers, comments, and unbalanced parentheses are reported with the exact line and column.

• Private by design

  Queries are formatted in your browser and never uploaded, so table names and data in your logs stay private.

1. Paste your SQL query or upload a .sql file.
2. Choose Beautify or Minify, the indentation, and the keyword case.
3. Fix any error shown with its line and column.
4. Copy or download the formatted SQL.