Tools
Sign inCreate account
All ToolsMathConverterDeveloperDesignTextBenchSign inCreate account
Runs locally

SQL Formatter

Lay out a SQL statement.

Ctrl+Enter runs. Ctrl+Shift+Backspace clears.

Export and import are available after you sign in. Sign in

Formats the statement you paste. It does not connect to a database or run the query.

About this tool

Make a one-line query from a log or an ORM readable before reviewing or debugging it. Paste the SQL and get clauses, joins and conditions laid out on separate lines.

How to use it

  1. 01

    Paste the SQL query.

  2. 02

    Review the formatted query.

  3. 03

    Copy it into your editor or review.

FAQ

Frequently asked questions

Does it run my query?

No. It only formats the text and never connects to a database.

Which SQL dialects work?

Standard SQL as used by PostgreSQL, MySQL, SQLite and similar databases formats well.

Nearby instruments

Text DiffLine-by-line additions and removals.NextJSON FormatterPretty-print JSON with a chosen indent.JSON MinifierStrip insignificant JSON whitespace.JSON ValidatorTell whether a document is valid JSON.JSON Tree ViewerExpand objects and arrays and copy a path.JSON DiffStructural additions, removals and changes.JSON Path TesterQuery a document with JSONPath.JSON to TypeScriptInfer an interface from a JSON sample.