How do I format a one-line SQL query?

Paste the query into SQL input, keep Mode on Format, and the Formatted SQL panel updates. Major clauses such as SELECT, FROM and WHERE go on their own lines. Then click Copy or Download .sql.

Can I make SQL keywords uppercase and change the indentation?

Yes. Keywords can be UPPERCASE, lowercase or Preserve, and Indent can be 2 spaces, 4 spaces or 8 spaces (tab).

How do I minify SQL into one line?

Switch Mode to Minify. Newlines and extra whitespace are collapsed into single spaces, which is handy for embedding a query in code.

Does it support MySQL, PostgreSQL or SQL Server dialects?

There is no dialect setting. It uses one built-in tokenizer and keyword list that handles common SQL, including string literals, -- and block comments, and multi-word keywords like LEFT JOIN.

Is my SQL sent to a server?

No. Formatting uses a tokenizer written into the page and runs in your browser as you type, so queries with table names or data are not transmitted.

Yes. Every tool is free to use, with no account and no credit card. The work runs on your device rather than on our servers, which is what keeps it free to run.

Does it work on mobile?

Yes. It runs in current mobile browsers on iOS and Android, with nothing to install.

🗄️

Free SQL Formatter & Beautifier

Pretty-print SQL queries with proper indentation, configurable keyword case, and line breaks on major clauses. Works with any SQL dialect.

Runs in your browserNo sign-up, no pop-upsNo login requiredFree forever

Works offline once loaded

Keywords:

Indent:

SQL input

Formatted SQL

Formatted SQL appears here…

Common uses

Format SQL for Pull Request ReviewsClean up SQL queries before committing to make them readable in code reviews.
Format SQL to Find BugsFormatting reveals structural issues like missing JOINs or misaligned conditions.
Format SQL for DocumentationMake SQL examples in your docs, blog posts, or tutorials beautiful and easy to read.
Format ORM-Generated SQLORMs (Sequelize, Prisma, ActiveRecord) produce single-line SQL — format it to debug what they actually generated.
Format Reporting QueriesBig analytical SQL queries become unmanageable without formatting. Indent them for clarity.

How It Works

This SQL formatter is built entirely from a hand-written tokenizer and formatter — no external library is used. Formatting and syntax highlighting run instantly in the browser as you type, with no server involved.

1
Tokenizer splits the SQL
A character-by-character tokenizer walks your input and breaks it into typed tokens: string literals (handling both backslash escapes and SQL's doubled-quote style), line comments (--), block comments (/* */), operators, parentheses, identifiers, and numbers. Whitespace is collapsed to a single space token.
2
Compound keywords are merged
After tokenizing, a second pass merges adjacent tokens that form multi-word keywords — so 'LEFT' followed by 'JOIN' becomes a single 'LEFT JOIN' token, and 'GROUP' followed by 'BY' becomes 'GROUP BY'. This is what lets the formatter treat them as single layout units.
3
Block layout or minification
In format mode, block-starting keywords (SELECT, FROM, WHERE, JOIN, etc.) are placed on their own line at zero indent, and everything that follows is indented. AND/OR force a new indented line. Commas at the top paren level also flush to a new line. In minify mode, all newlines and redundant whitespace are collapsed to a single-space-separated sequence.
4
Syntax highlighting via regex
The formatted output is passed through a single regex that matches comments, string literals, numbers, and identifiers in one sweep. Each match is wrapped in a React span with a color class — comments in muted italic, strings in amber, numbers in purple, and SQL keywords (checked against the full keyword set) in teal — producing the colored output panel.