SQL Formatter & Minifier

What is SQL Formatter & Minifier?

A free online SQL formatter and minifier that runs entirely in your browser. Paste a messy or one-line query and Beautify mode re-indents it with 2-space, 4-space, or tab indentation and uppercases (or lowercases) the keywords for a readable layout; Minify mode strips comments and collapses the whitespace into a single compact line while leaving quoted strings untouched. Choose the dialect — Standard SQL, PostgreSQL, MySQL, SQLite, MariaDB, or BigQuery — so dialect-specific clauses and functions are parsed correctly. Backend developers, data analysts, and DBAs use it to tidy up hand-written queries, make ORM-generated SQL readable, and shrink statements before embedding them in code.

How to use SQL Formatter & Minifier

1. Paste or type your SQL into the Input box.
2. Open Settings and pick the dialect that matches your database: Standard SQL, PostgreSQL, MySQL, SQLite, MariaDB, or BigQuery.
3. Leave the mode on Beautify to re-indent the query, or switch to Minify to collapse it onto one line.
4. In Settings, choose 2-space, 4-space, or tab indentation and whether keywords are uppercased, lowercased, or left as written (Beautify mode).
5. Read the formatted result and use the Copy button to grab it, or click Clear to empty the input and start over.

Examples

select id, name from users where active = 1 order by name

SELECT
  id,
  name
FROM
  users
WHERE
  active = 1
ORDER BY
  name

SELECT id, name
FROM users
-- only active rows
WHERE active = 1

SELECT id, name FROM users WHERE active = 1

Frequently asked questions

Is my SQL uploaded to a server?

No. Beautifying, minifying, and dialect parsing all happen locally in your browser using the sql-formatter library. Your queries never leave your device, and the tool keeps working offline.

Which SQL dialects are supported?

You can choose Standard SQL, PostgreSQL, MySQL, SQLite, MariaDB, or BigQuery. The dialect tells the formatter how to parse dialect-specific keywords, quoting, and functions so the layout stays correct.

What's the difference between Beautify and Minify?

Beautify re-indents the query and applies your chosen keyword case for readability, using the selected dialect's grammar. Minify removes comments and squeezes the statement onto a single line, leaving quoted strings and identifiers untouched.

Can I control indentation and keyword case?

Yes. In Settings you can pick 2-space, 4-space, or tab indentation, and set keywords to uppercase, lowercase, or preserve. These options apply in Beautify mode; Minify always collapses to one line.

Why does it report a parse error?

Beautify mode parses the query with the chosen dialect, so a genuine syntax problem or a statement written for a different dialect can fail to parse. Try switching to the matching dialect, or use Minify, which only tidies whitespace without parsing.