About SQL Formatter & Beautifier

The SQL Formatter & Beautifier takes raw, compressed, or hand-written SQL queries and reformats them with consistent indentation, line breaks at clause boundaries, and optional keyword casing. It supports five dialects — Standard SQL, PostgreSQL, MySQL, T-SQL (SQL Server), and BigQuery — so dialect-specific syntax is handled correctly.

Readable SQL is easier to review, debug, and maintain. Because formatting runs entirely in your browser using the open-source sql-formatter library, none of your queries or schema names leave your machine.

Common Use Cases

Cleaning up auto-generated ORM queries that are output as a single unreadable line
Standardizing keyword case (e.g., all uppercase SELECT, FROM, WHERE) across a team's codebase
Preparing SQL snippets for documentation, code reviews, or pull request descriptions
Quickly minifying a formatted query back to one line before embedding it in application code

How to Use

Select your SQL dialect (Standard SQL, PostgreSQL, MySQL, T-SQL, or BigQuery)
Paste your query into the Input panel — formatting runs automatically as you type
Adjust indent width (2 spaces, 4 spaces, or tabs) and keyword case (UPPERCASE / lowercase / Preserve)
Click Copy to copy the formatted output, or Minify to collapse it to a single line

Frequently Asked Questions

Which SQL dialects are supported?

The formatter supports Standard SQL, PostgreSQL, MySQL, T-SQL (Microsoft SQL Server / Azure SQL), and Google BigQuery. Each dialect handles specific syntax differences like ILIKE, TOP, backtick identifiers, and window function extensions.

Will this tool execute my SQL query?

No. The formatter only parses and reformats the text of your query. It does not connect to any database, execute statements, or validate table or column names against a real schema.

Can I format multiple statements at once?

Yes. Paste multiple SQL statements separated by semicolons and the formatter will process all of them, inserting proper line breaks and indentation between each statement.