SQL

SQL Formatter

Indent and tidy complex SQL so queries stay readable.

Format options

Choose indentation, keyword casing, and line break rules.

Indentation style

Pick tabs or 2/4 spaces; both are common in SQL.

Uppercase keywords

Convert SELECT/FROM/WHERE and JOIN keywords to uppercase.

Break select columns

Place each SELECT column on its own line after commas.

Break AND/OR in filters

Move AND/OR to new lines inside WHERE/HAVING for scan-friendly filters.

Break JOIN/ON blocks

Start JOIN and ON clauses on their own lines to visualize join chains.

Trim trailing spaces

Remove spaces at the end of formatted lines.

SQL input

Paste any SQL query to format indentation, clause breaks, and keyword casing.

Supports SELECT/INSERT/UPDATE/DELETE, JOIN chains, CTEs, and CASE blocks.

Formatted SQL

Review and copy the formatted SQL.

Use Select all or Copy to move the result into your editor.

What

SQL Formatter definition

A SQL formatter organizes queries with line breaks and indentation.

Cases

Use Cases

Make complex joins readable

Review and share queries with teammates

Spot syntax issues in long statements

How To

How to Format SQL Queries

A step-by-step guide to making SQL queries easier to read.

Paste SQL

Paste your SQL query into the input.

Adjust rules

Choose keyword casing and line-break options.

Format and copy

Run formatting and copy the formatted SQL.

Knowledge

Understanding SQL Formatting

Why Format SQL?

Formatted SQL is easier to read, debug, and maintain. Consistent formatting helps team members understand complex queries quickly. It also makes version control diffs more meaningful by standardizing whitespace.

Keyword Casing

SQL keywords (SELECT, FROM, WHERE) are case-insensitive but conventionally written in uppercase. This distinguishes keywords from table/column names. Some teams prefer lowercase for a more modern look.

Indentation Strategies

Common approaches: indent after SELECT/FROM/WHERE, align columns, indent JOIN conditions. Right-aligning keywords (SELECT, FROM, WHERE) creates a visual margin. Choose a style and apply it consistently.

Line Breaking

Break lines at logical points: after each SELECT column, before each JOIN, after WHERE/AND/OR. This makes complex queries scannable and helps identify missing conditions or joins.

SQL Dialects

Different databases (PostgreSQL, MySQL, SQL Server, Oracle) have syntax variations. Formatters typically handle standard ANSI SQL. Some dialect-specific syntax may not format perfectly but will remain functional.

FAQ

SQL formatter FAQ

What dialects does this handle?

It is tuned for ANSI-style SQL and works with Postgres, MySQL, and most dialects when queries use standard keywords.

Does it keep string literals untouched?

Yes. Quoted strings and identifiers stay as-is; only keywords and whitespace are adjusted.

How are JOIN chains formatted?

Each JOIN and its ON clause can break onto separate lines to highlight relationships.

Will it uppercase my keywords?

Enable 'Uppercase keywords' to convert recognized clause and join keywords to uppercase.

Can I keep SELECT columns on one line?

Turn off 'Break select columns' to keep comma-separated columns on the same line.

Does it support CTEs?

CTEs that start with WITH go on new lines with indentation preserved for subqueries.

How are AND/OR handled?

Turn on 'Break AND/OR' to put logical operators on new lines for faster scanning.

Will this change semicolons or comments?

Semicolons stay at statement ends; line and block comments are preserved on their own lines.

Dev Utils Tools

View all →

Python Beautifier

Format Python with indentation, wrapping, and whitespace controls.

JavaScript Beautifier

Tidy JavaScript with indentation, wrapping, and spacing options.

Markdown Preview

Render Markdown in real time with a clean, readable preview.

Cron Expression Parser

Validate cron schedules and preview upcoming runs.

SQL