What this formatter does
It tokenizes your SQL and rebuilds it with consistent rules: clause keywords (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, JOIN, ON, SET, VALUES…) start new indented lines; commas and operators get spacing; strings and comments are preserved untouched; parentheses increase indentation.
What it doesn't do
- It's not a linter — syntax errors are left for your database to judge.
- It doesn't know your dialect's exotic syntax (PL/pgSQL bodies may need manual tidy-up).
- It never sends your query anywhere — everything runs in your browser tab.
Formatting conventions
Clause-first style: each main clause on its own line at the same level, sub-queries indented one level, AND/OR aligned under their WHERE. This matches the style used in most open-source projects and is easy to read in diffs.
Example — input: select u.id,u.name from users u where u.active=true order by u.id becomes:
SELECT u.id,
u.name
FROM users u
WHERE u.active = true
ORDER BY u.id;