SQL Formatter

SQL query

Result

Formatted querySELECT u.id, u.name, count(o.id) as orders FROM users u LEFT JOIN orders o on o.user_id = u.id WHERE u.active = 1 and u.created_at > '2026-01-01' GROUP BY u.id, u.name ORDER BY orders desc LIMIT 20
Lines12
Characters205
Keywords foundSELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, LEFT JOIN, JOIN
Tablesusers, orders

From one long line to something readable

Breaks a query at its keywords, pulls conditions and column lists onto their own lines, and lists the tables involved.

A query copied out of a log or out of code arrives as a single long line. Reading the logic out of that is impossible, and reading the logic is usually the point — where does the data come from and what is filtered.

Formatting puts every major keyword on its own line, indents AND and OR conditions and splits comma-separated lists. A separate line names the tables involved, which answers the first question about any unfamiliar query.

What this calculator shows

The formatted query with line breaks at the keywords
The tables the query touches
Which keywords appear in the query

What to keep in mind

Formatting is textual rather than a full SQL parse, so subqueries in brackets get no extra indentation.
Keywords are recognised in any case and appear in the output as they were written.

FAQs

Does it work with every SQL dialect?

For the core keywords, yes — they are identical in PostgreSQL, MySQL, SQLite and SQL Server. Dialect-specific constructs simply stay inline.

Why aren't subqueries indented?

Formatting is keyword-based rather than a parse of the query tree. Tracking bracket depth would require a proper parser.

Why list the tables?

So you can see in a second what data an unfamiliar query touches — especially worth doing before running someone else's UPDATE or DELETE.

Is my query uploaded?

No, formatting happens in the browser. Queries often carry internal table names that should not leave the machine.

Worked example

A query with a join and grouping

Input: select … from users left join orders … group by … order by … limit 20

Output: Nine lines with SELECT, FROM, JOIN, WHERE and GROUP BY separated

Note: The tables line immediately shows users and orders. On an unfamiliar query with five joins, that is the first thing worth reading.

Useful links

All tools in Dev Tools

SQL Formatter

Result

Related tools

JSON formatter and validator

Regex Tester

Diff Checker

Useful links