What does this tool do?
The SQL Formatter turns queries that are crammed onto one line or inconsistently indented into a clean, readable layout. It places major clauses like SELECT, JOIN, WHERE and GROUP BY on their own lines, making it ideal for developers, data analysts and anyone learning SQL.
How to use it
- Enter your configuration details.
- Review the generated output.
- Copy the ready-to-use code or file.
How it works
The tool first splits your query into tokens: strings, comments, words and operators are each recognized separately, so text inside quotes is never broken. It then moves main keywords such as SELECT, FROM and WHERE to fresh lines, increases indentation inside parentheses, and adds a line break after each comma. You can set the indent to 2 or 4 spaces and toggle whether keywords are converted to uppercase.
Format and Minify
It works in both directions. The Format button expands and aligns a tangled query; the Minify button strips all extra whitespace and collapses the query onto a single line, which is handy for queries embedded in code or written to logs. Three ready-made examples (simple SELECT, subquery, GROUP BY) load with one click, so you can try the tool without supplying your own query.
Frequently asked questions
Which SQL dialects does it support?
The formatter recognizes the standard keywords common to MySQL, PostgreSQL, SQLite, SQL Server and Oracle. Database-specific functions still pass through fine; the tool only adjusts indentation and line layout without changing your syntax.
Are comments and string values preserved?
Yes. Single-line (--) and block (/* */) comments, as well as quoted strings, are treated as separate tokens, so their contents are not altered or broken during formatting.
Can I turn off uppercasing keywords?
Yes. Uncheck the 'Uppercase keywords' box and words like SELECT, from and where are left exactly as you typed them; only the line and indentation layout is applied.
Is SQL Formatter free?
Yes. SQL Formatter and all 300+ tools on MagmaNex are completely free with no signup or account required.
Is my data safe?
Yes. Everything runs locally in your browser. The data you enter is never sent to a server, stored, or shared.
Does it work on mobile?
Yes. SQL Formatter works on phones, tablets and desktops — no app download needed.
🔒 Privacy: everything runs in your browser, your data is never sent to a server.