Does it support every SQL dialect?

It formats based on standard SELECT/INSERT/UPDATE/DELETE clause keywords, and works reasonably well with most SQL dialects (MySQL, PostgreSQL, etc.).

Are keywords automatically uppercased?

Yes. Major clause keywords like SELECT, FROM, and WHERE are normalized to uppercase for readability.

Is the query I enter sent to a server?

No. It's processed entirely in your browser.

Are subqueries formatted too?

Yes — subqueries in parentheses are also split by clause for readability.

Do MySQL/PostgreSQL dialects work?

It formats around standard SELECT structure, so most dialects tidy up well.

🗃️ SQL Statement Formatter

Line-breaks a SQL query by clause — SELECT, FROM, WHERE, etc. — for readability.

Input

Result

How to use

Enter your SQL query.
Click "Format".
You'll see the result line-broken by clause — SELECT, FROM, WHERE, etc.

🎯 Use Cases

Turn a complex single-line query into a readable form
Standardize query formatting before a code review
Understand structure when analyzing query logs

Example

Input

select id, name from users where active=1 and age>20 order by id

Output

SELECT id,
  name
FROM users
WHERE active=1
  AND age>20
ORDER BY id

A single-line SELECT query is broken onto separate lines by its main clauses — SELECT, FROM, WHERE, ORDER BY — with keywords normalized to uppercase. Column lists and AND conditions are indented so the structure is easy to scan.

SQL structure clause by clause

Splitting a query at SELECT, FROM, WHERE and other clauses makes even long queries readable at a glance.

Clause	Role
`SELECT`	Columns and expressions to return
`FROM / JOIN`	Source tables and join conditions
`WHERE`	Row filter conditions
`GROUP BY / HAVING`	Aggregation keys and post-aggregation filters
`ORDER BY`	Result ordering
`LIMIT / OFFSET`	Row count and start position

FAQ

Does it support every SQL dialect?: It formats based on standard SELECT/INSERT/UPDATE/DELETE clause keywords, and works reasonably well with most SQL dialects (MySQL, PostgreSQL, etc.).
Are keywords automatically uppercased?: Yes. Major clause keywords like SELECT, FROM, and WHERE are normalized to uppercase for readability.
Is the query I enter sent to a server?: No. It's processed entirely in your browser.
Are subqueries formatted too?: Yes — subqueries in parentheses are also split by clause for readability.
Do MySQL/PostgreSQL dialects work?: It formats around standard SELECT structure, so most dialects tidy up well.