SQL Formatter

How to use the SQL Formatter

1. Paste your SQL, or open a .sql file.
2. Choose the dialect so its special syntax is understood.
3. Pick uppercase or lowercase keywords and your indentation.
4. Copy the formatted query or save it as a .sql file.

Examples

select c.id,c.name,count(o.id) as orders,sum(o.total) as revenue from customers c left join orders o on o.customer_id=c.id and o.status='paid' where c.created_at>='2026-01-01' group by c.id,c.name having count(o.id)>2 order by revenue desc limit 20;

with recent as (select user_id, max(seen_at) last_seen from visits where seen_at > now() - interval '30 days' group by user_id) select u.email, r.last_seen from users u join recent r using (user_id) where u.plan in ('pro','team') or u.trial_ends::date >= current_date;

-- monthly totals
SELECT
  date_trunc('month', paid_at) AS month, /* bucket */
  SUM(amount) AS total
FROM payments
WHERE note <> '-- not a comment'
GROUP BY 1;

About this tool

SQL copied from logs, ORMs and old scripts often arrives as a single endless line, which makes joins, conditions and subqueries hard to follow. This formatter puts each clause on its own line, indents nested queries and lists of columns, and lines up joins and conditions so the structure of the query is obvious at a glance.

Dialects matter. PostgreSQL has casts like ::date and dollar-quoted strings, SQL Server uses square brackets around names, MySQL uses backticks, and BigQuery and Snowflake add their own functions. Choosing the right dialect lets the formatter recognise those correctly instead of mangling them. The formatting itself is handled by the open-source sql-formatter library.

Minify mode does the opposite: it removes comments and squeezes the query onto one line while leaving everything inside quotes alone, so a string such as "-- not a comment" is kept intact. That is handy for embedding a query in code, a config file or a URL.