SQL Formatter

Format and beautify SQL queries online. Supports MySQL, PostgreSQL, T-SQL, and standard SQL. Free SQL beautifier.

Last updated: June 1, 2026

Input SQL

Formatted SQL

What is SQL Formatter?

A SQL formatter takes dense, unformatted SQL queries and reformats them with proper indentation, line breaks, and keyword capitalization for readability. Complex SQL queries — especially those with multiple JOINs, subqueries, CASE statements, and CTEs (Common Table Expressions) — become nearly impossible to understand when written as a single line. This tool structures them visually so the logical flow is clear, making code review, debugging, and optimization significantly easier.

How It Works

Paste your SQL query and select the dialect (Standard SQL, MySQL, PostgreSQL, or T-SQL). The tool parses the SQL syntax, identifies keywords (SELECT, FROM, WHERE, JOIN, etc.), and applies consistent formatting rules: major keywords start new lines, sub-clauses are indented, long expressions are wrapped, and keywords are uppercased for distinction from identifiers. The formatter handles subqueries, CTEs, UNION/INTERSECT, window functions, and all standard SQL constructs while preserving the query's logical meaning exactly.

Examples

Dense query → Formatted SQL

Input

SELECT u.name, o.total FROM users u JOIN orders o ON u.id=o.user_id WHERE o.total>100 ORDER BY o.total DESC

Output

SELECT
  u.name,
  o.total
FROM
  users u
  JOIN orders o ON u.id = o.user_id
WHERE
  o.total > 100
ORDER BY
  o.total DESC

Tips & Best Practices

💡

Uppercase SQL keywords (SELECT, FROM, WHERE) and lowercase identifiers to visually distinguish structure from data.

💡

Each JOIN should start on its own line for readability. The ON clause can stay on the same line for simple conditions.

💡

CTE (WITH clauses) should be formatted with the CTE name and AS on one line, the query body indented below.

Common Use Cases

•Making complex analytical queries readable for code review and team collaboration
•Formatting auto-generated SQL from ORMs or query builders for debugging purposes
•Standardizing SQL formatting across a codebase for consistency and maintainability
•Cleaning up legacy queries before optimization to understand their structure
•Preparing SQL examples for documentation, tutorials, and technical blog posts
•Formatting stored procedures and views for better readability in database management