SQL Formatter & Beautifier

Format, beautify, or minify SQL queries in 7 dialects — entirely in your browser

Input SQL

0 chars · 0 lines

Formatted SQL

0 chars · 0 lines
Formatted SQL will appear here as you type

What does a SQL formatter do?

A SQL formatter rewrites the whitespace of a query without changing its meaning. It places each major clause (SELECT, FROM, WHERE, GROUP BY, ORDER BY) on its own line, indents nested expressions and subqueries, and normalizes keyword casing. A 400-character one-line query that takes a minute to read becomes a 15-line statement whose structure is obvious at a glance.

This tool uses the open-source sql-formatter library, which actually tokenizes the query rather than applying naive find-and-replace rules. That is why the dialect setting matters: PostgreSQL allows double-quoted identifiers and casts like ::int, MySQL uses backticks, and T-SQL uses square brackets — each dialect is parsed with its own grammar so string literals, comments, and identifiers are never mangled.

Minify mode does the opposite: it removes comments and collapses all runs of whitespace into single spaces (while preserving whitespace inside string literals), which is useful for embedding a query in a log line, an environment variable, or a single-line configuration value.

SQL Formatter FAQ

Disclaimer: A2ZKit's tools, calculators, cheat sheets, and articles are provided for general information and educational purposes only, on an "as is" basis without warranties of any kind. They are not financial, investment, tax, accounting, medical, health, or legal advice, and are not a substitute for a qualified professional. Results may be inaccurate or incomplete — verify independently and consult an appropriate professional before making any decision. Some tools process files — such as PDFs and images — entirely in your browser; you are responsible for keeping your own backups, and we are not liable for any data loss, file corruption, or inaccurate output. You use A2ZKit entirely at your own risk. By using the site you agree to our Terms of Service.