SQL Formatter

SQLクエリの整形。

入力

出力

Indent:

Auto Uppercase

Uppercases SQL keywords (SELECT, FROM, WHERE...).

Clause Indentation

Each clause on its own line with indentation.

Copy Result

One-click copy to clipboard.

Free & Fast

No signup, no limits. Works instantly.

SQL Formatterについて

The SQL Formatter is a free, browser-based tool that cleans up and beautifies SQL queries, making them easy to read, review, and share. Raw SQL generated by ORMs, query builders, or logging tools is typically output as a dense single-line string with inconsistent casing and no indentation. This formatter normalizes all SQL keywords to uppercase (SELECT, FROM, WHERE, JOIN, GROUP BY, ORDER BY, and more), places each major clause on its own line, and indents comma-separated column lists and AND/OR conditions for maximum clarity. This makes it simple to spot missing joins, incorrect column references, or logical errors at a glance. The tool supports all standard SQL clauses including CTEs (WITH), subqueries, window functions, and conditional CASE/WHEN expressions. A minify mode is also available for when you need to pass a compact query to an API, log it on a single line, or embed it in code. A sample query is included so you can immediately see what formatted output looks like. Your SQL code never leaves your browser — no data is uploaded to any server.

SQL Formatterの使い方

Paste your SQL query into the left input panel, or click "Load Sample" to try the formatter with an example query.
Choose your preferred indentation size (2 or 4 spaces) from the dropdown.
Click "Format" to beautify the query with uppercase keywords, clause line breaks, and proper indentation.
Alternatively, click "Minify" to compress the query into a single compact line.
Review the output in the right panel, then click "Copy" to copy it to your clipboard.

よくある質問

Which SQL dialects are supported?

The formatter handles standard SQL keywords that are common across MySQL, PostgreSQL, SQLite, SQL Server, and Oracle. Dialect-specific syntax extensions are left as-is without modification.

Does it handle CTEs (WITH clauses)?

Yes. The WITH keyword is recognized as a clause boundary and placed on its own line, so Common Table Expressions are formatted with the same clarity as SELECT or JOIN blocks.

Is my SQL sent to a server?

No. All formatting runs in your browser. Database queries often contain sensitive table names, column names, or filter values — none of that information ever leaves your device.

Why are keywords converted to uppercase?

SQL keyword casing is a widely adopted convention that visually distinguishes keywords from table and column names, making queries faster to parse at a glance. The formatter follows this standard automatically.

Can I format stored procedures or multi-statement scripts?

The formatter works best on individual SELECT, INSERT, UPDATE, or DELETE statements. Multi-statement scripts with procedural logic (BEGIN/END blocks, variables) will be partially formatted based on recognized keywords.