SQL Formatter
What does this SQL formatter do?
It reformats a SQL query by placing major clauses (SELECT, FROM, WHERE, JOIN, ORDER BY, and others) on their own lines, indenting selected columns and conditions, and uppercasing keywords — turning a dense, single-line query into a readable, consistently structured one.
When would I use this?
- Cleaning up a minified or auto-generated query before reviewing or debugging it.
- Formatting a query pasted from a database tool or ORM log into a readable form.
- Making a query easier to review in a pull request or documentation.
How it works
Formatting is keyword- and pattern-based, implemented in JavaScript, and runs entirely in your browser. It reformats structure without validating the query's syntax or attempting to execute it.
Frequently asked questions
The formatter works on standard ANSI SQL syntax common to MySQL, PostgreSQL, and SQLite — formatting based on common keywords and clause structure rather than validating dialect-specific syntax.
No, this is a formatter, not a SQL parser or validator — it reformats spacing, line breaks, and keyword casing without checking whether the query is semantically valid or would execute successfully.
Yes, common SQL keywords (SELECT, FROM, WHERE, JOIN, and others) are automatically uppercased for readability, following common SQL style conventions.
No, formatting happens entirely in your browser using JavaScript — safe to use even with queries containing sensitive table or column names.
Related tools
Cron Builder
Build cron expressions visually or decode existing ones into plain English.
Timestamp Converter
Convert Unix timestamps to human-readable dates and back.
Number Base Converter
Convert numbers between binary, octal, decimal, and hexadecimal.
JSON Formatter
Format, validate, and beautify JSON instantly in your browser.