SELECTJOINWHERE;

SQL Formatter.

Turn a one-line query into clean, readable SQL, for MySQL, PostgreSQL, SQLite, SQL Server and a dozen more dialects. Pick your style, or minify it back.

19 dialects format or minify queries stay private

Format SQL

Options

Your SQL

-- Top customers by revenue this yearselect c.id, c.name, count(o.id) as orders, sum(o.total) as revenuefrom customers c join orders o on o.customer_id = c.idwhere o.created_at >= '2026-01-01' and o.status in ('paid','shipped')group by c.id, c.name having sum(o.total) > 1000 order by revenue desc limit 20;update customers set tier = 'gold' where id in (select customer_id from orders group by customer_id having count(*) > 50);

-- Top customers by revenue this year
select c.id, c.name, count(o.id) as orders, sum(o.total) as revenue
from customers c join orders o on o.customer_id = c.id
where o.created_at >= '2026-01-01' and o.status in ('paid','shipped')
group by c.id, c.name having sum(o.total) > 1000 order by revenue desc limit 20;
update customers set tier = 'gold' where id in (select customer_id from orders group by customer_id having count(*) > 50);

Formatted

Loading the formatter…

Running MySQL on Windows?MySQL Tray Controller starts, stops and restarts the service from your system tray.

Knows your dialect

MySQL backticks, PostgreSQL :: casts, T-SQL brackets and BigQuery structs are all understood, not mangled.

Your style

Uppercase or lowercase keywords, 2 or 4 spaces or tabs, and blank lines between statements. Or squash it all onto one line.

Queries stay private

Formatting runs in your browser, so table names and data in your queries never touch a server.

// faq

Questions people ask

Which SQL dialects are supported?

Standard SQL, MySQL, MariaDB, PostgreSQL, SQLite, SQL Server (T-SQL), Oracle PL/SQL, BigQuery, Snowflake, Redshift, Spark, DuckDB, Hive, ClickHouse, Db2, N1QL, Trino and TiDB, through the open-source sql-formatter library.

Will formatting change what my query does?

No. Only whitespace and, if you choose, the case of keywords change. Identifiers, strings and comments are kept as written. Minify also removes comments.

Why does my query fail to format?

Usually the dialect doesn't match the syntax (for example backtick identifiers under PostgreSQL) or the query has an unclosed quote or bracket. Try the matching dialect first; the error shows where parsing stopped.

Is it safe to paste production queries?

Yes. Nothing is uploaded. A share link does contain the query, so only share it when you mean to.

More free tools

all tools →

JSON FormatterFormat, validate and explore JSON, with exact error locations.Regex TesterTest regular expressions with live highlights and a plain-English explanation.Diff CheckerCompare two texts and see exactly what changed.

Looking for something bigger? The products are full apps: an encrypted password vault, self-hosted CI/CD, and more.

$ loading▍

-- Top customers by revenue this yearselect c.id, c.name, count(o.id) as orders, sum(o.total) as revenuefrom customers c join orders o on o.customer_id = c.idwhere o.created_at >= '2026-01-01' and o.status in ('paid','shipped')group by c.id, c.name having sum(o.total) > 1000 order by revenue desc limit 20;update customers set tier = 'gold' where id in (select customer_id from orders group by customer_id having count(*) > 50);

Questions people ask

Which SQL dialects are supported?

Will formatting change what my query does?

No. Only whitespace and, if you choose, the case of keywords change. Identifiers, strings and comments are kept as written. Minify also removes comments.

Why does my query fail to format?

Is it safe to paste production queries?

Yes. Nothing is uploaded. A share link does contain the query, so only share it when you mean to.

SQL Formatter.

Knows your dialect

Your style

Queries stay private

Questions people ask

More free tools

Ask Pumpkin

Hi, I'm Pumpkin.

SQL Formatter.

Knows your dialect

Your style

Queries stay private

Questions people ask

More free tools