🗃️ SQL Formatter & Beautifier

Format and beautify SQL queries online. Supports MySQL, PostgreSQL, SQL Server, SQLite. Keyword casing, indent size, and minify mode.

SQL Input

Formatted Output

How to Use

Paste your SQL

Paste or type your SQL query into the left panel. Single queries, multi-statement scripts, and subqueries are all supported.

Choose options

Select the SQL dialect (MySQL, PostgreSQL, SQL Server, or SQLite), indent size, and keyword casing (UPPER or lower).

Format and copy

Click Format (or Ctrl+Enter) to beautify the query. Use Minify to compress it. Click Copy to use the result in your project.

Frequently Asked Questions

Does this SQL formatter support stored procedures? +

The formatter handles standard SQL including SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, and JOIN queries. Complex stored procedure syntax with BEGIN/END blocks, IF/ELSE, and DECLARE statements is formatted as best-effort.

What is the difference between beautify and minify? +

Beautify adds line breaks, consistent indentation, and keyword casing for human readability. Minify removes all extra whitespace to produce the smallest possible query string — useful for embedding in code or measuring query length.

Should SQL keywords be uppercase or lowercase? +

Both styles are equally valid — SQL is case-insensitive. The convention of UPPERCASE keywords (SELECT, FROM, WHERE) is traditional and widespread because it visually separates reserved words from table/column names. Many style guides (like Google SQL Style Guide) prefer lowercase for everything.

Does formatting change how the query runs? +

No. Formatting only affects whitespace and keyword case — it has no effect on query execution, performance, or results. The SQL engine ignores whitespace.

Is my SQL query sent to a server? +

No. All formatting runs entirely in your browser using JavaScript. Your SQL code never leaves your device.

完整指南：SQL格式化工具

为什么要格式化SQL？

ORM生成或API传输的SQL通常是单行不可读的文本。格式化工具应用一致的缩进、关键词大写和列对齐，使代码审查、调试和文档编写变得容易。

如何使用

粘贴SQL查询到输入区。
选择方言：MySQL、PostgreSQL、SQLite、MSSQL。
格式化并复制结果。

专业技巧

SQL关键词大写（SELECT、FROM）提高可读性——SQL本身不区分大小写。
添加注释前先格式化——更易注释结构化的代码。
格式化后的查询更容易识别WHERE和JOIN ON子句中需要索引的字段。