SQL Formatter & Minifier
FormattingEverything runs locally in your browser — nothing is uploaded
Expand a statement that was squeezed onto one line into a clause-per-line structure: each clause starts its own line with the body indented under it, AND / OR and JOIN / ON break onto their own lines, and a subquery inside parentheses is indented one level deeper with its closing parenthesis returned to the outer level. Keywords can be upper case, lower case or left exactly as written, while identifiers and anything quoted are never touched. String literals, comments, backtick and bracket identifiers and Postgres dollar quoting are all excluded from the structural scan, so a semicolon inside 'a;b' never cuts a statement in half.
Features
- One line per clause: SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, LIMIT, VALUES, SET, RETURNING and friends
- AND / OR / JOIN / ON each start a line, so long condition lists keep a visible boundary
- Subqueries in parentheses open a block and their closing parenthesis returns to the clause body level
- Function call parentheses stay inline, so COUNT(*) is never split apart
- Keywords can be upper case, lower case or kept as written; identifiers and strings are always preserved
- String literals, comments, backtick and bracket identifiers and Postgres dollar quoting are excluded from the structural scan
- Minify removes comments and redundant whitespace without gluing - -1 into --1, which would comment out the rest of the line
- No syntax validation: malformed SQL is indented as best it can rather than rejected
How to use
- Paste your SQL into the input box
- Choose the mode, indentation and keyword case
- Press Ctrl/⌘ + Enter or click Run
- Click Copy to take the result
FAQ
- Does it validate SQL syntax?
- No. It only rearranges whitespace and keyword case, so a statement with a typo is formatted just the same. Treat it as a way to make working queries readable, not as a replacement for your database error messages.
- Why does minify remove comments as well?
- A line comment collapsed onto a single line comments out everything after it, while the output still looks perfectly normal. Dropping comments is safer than leaving a trap in the statement. Use format mode when you need to keep them.
- Which SQL dialects are supported?
- The keyword list covers common SQL, with allowances for MySQL # comments and backticks, SQL Server bracket identifiers, and Postgres dollar quoting and :: casts. The formatting itself is dialect agnostic.
- Is my SQL uploaded anywhere?
- No. Everything runs in your browser memory, the page makes no network requests, and it works offline.
Related tools
JSON to Code
FormattingTurn JSON into TypeScript interfaces, Go structs, Java classes or Rust structs, with missing keys marked optional. Runs locally in your browser.
Mock Data
GeneratorsDescribe your fields once and get a batch of realistic mock records, exportable as JSON, CSV or a SQL INSERT. Everything is generated in your browser.
Text Cleaner
TextClean up a column pasted out of a log or spreadsheet: deduplicate, sort, drop blank lines, trim whitespace and strip line numbers, all in your browser.
JSON Formatter
FormattingFormat, minify and validate JSON, pinpointing syntax errors to an exact line and column. Optional key sorting; runs in your browser.
XML Formatter
FormattingFormat XML online by tag level, with comments, CDATA and DOCTYPE on their own lines and attribute values left untouched. Runs locally in your browser.
HTML Formatter
FormattingFormat HTML online by tag level, keeping text and inline tags on one line and script or pre content untouched. Runs locally, with nothing uploaded.