SQL Formatter & Beautifier

Format and beautify SQL queries with proper indentation. Supports MySQL, PostgreSQL, SQLite, T-SQL, and more.

Free Always No Account Needed 100% Client-Side

Dialect

Indent

Input SQL

Formatted SQL

SELECT
  u.id,
  u.name,
  u.email,
  COUNT(o.id) AS order_count,
  SUM(o.total) AS total_spent
FROM
  users u
  LEFT JOIN orders o ON u.id = o.user_id
WHERE
  u.created_at > '2024-01-01'
  AND u.status = 'active'
GROUP BY
  u.id,
  u.name,
  u.email
HAVING
  COUNT(o.id) > 0
ORDER BY
  total_spent DESC
LIMIT
  50;

About this tool

Readable SQL is easier to understand, review, and maintain. Long, unformatted SQL queries (especially from ORM-generated code or query logs) are notoriously hard to read.

This tool reformats SQL queries with: - Keyword uppercasing (SELECT, FROM, WHERE, JOIN, etc.) - Consistent indentation for nested queries and CTEs - Newlines before major clauses - Alignment of column lists and conditions

Supported dialects: - MySQL / MariaDB - PostgreSQL - SQLite - SQL Server (T-SQL) - Oracle (PL/SQL) - BigQuery / Spark SQL (standard SQL)

Paste any SQL — from a single SELECT to complex CTEs with window functions and subqueries — and get cleanly formatted output you can read and understand at a glance.

Frequently Asked Questions

Does this work with stored procedures?

Yes. The formatter handles CREATE PROCEDURE, BEGIN/END blocks, and variable declarations in T-SQL and PL/SQL.

Can it format very long queries?

Yes. There's no size limit — paste queries of any length including multi-page reports with many CTEs.

Does it change my query logic?

No. The formatter only changes whitespace and capitalization — the query logic and result are identical.

What is a CTE?

A Common Table Expression (WITH clause) defines a temporary named result set within a query, making complex queries more readable.

Related Tools

JSON Formatter

Format, validate, beautify, and minify JSON instantly. Syntax highlighting, error detection, and path copying. 100% client-side.

Diff Checker

Compare two texts side-by-side with highlighted differences. Supports plain text and smart JSON-aware diffing.

XML Formatter

Format and validate XML with syntax highlighting. Convert XML to JSON and JSON to XML. 100% client-side.

HTML Formatter

Format, beautify, and minify HTML. Auto-indent nested elements and collapse attributes. 100% client-side.