Development
SQL Formatter
Separate common query clauses for review while preserving quoted text and comments. Use the result as an editable draft for your database.
About this tool
When to use it
Separate common query clauses for review while preserving quoted text and comments. Use the result as an editable draft for your database.
How to use it
Paste one small query, select Format SQL, then inspect literals, comments, joins, and parentheses before copying or downloading it. Run database validation separately. Compare with the original if a dialect uses quoting that this formatter does not recognize.
Guide updated . Examples checked against this implementation.
Worked examples
Separate a simple SELECT
Input
select id,name from users where active=true;Expected output
SELECT id, name
FROM users
WHERE active=true;Keywords become uppercase and clauses move to separate lines. Formatting does not establish that users, id, or active exist.
Errors and unsupported input
A dialect-specific dollar-quoted function bodyUse the database's own formatter or inspect the unchanged original. This tokenizer does not implement every SQL dialect or procedural language.
Continue this workflow
- Text Diff: Review textual changes before using a reformatted query.
Questions
Frequently asked questions
Will formatting make the query faster?
No. It changes presentation. Query plans, indexes, joins, and data distribution determine execution behavior.