How should I format JOIN clauses?

Put each JOIN on its own line, indent ON conditions. Align join conditions for readability. Example:\nFROM users u\n INNER JOIN orders o ON u.id = o.user_id\n LEFT JOIN items i ON o.id = i.order_id

What about long SELECT column lists?

Options: 1) One column per line (best for many columns), 2) Multiple columns per line with logical grouping, 3) Leading commas (makes adding/removing columns easier). Align columns when using multiple lines.

How should subqueries be indented?

Increase indent level for subqueries. The opening parenthesis stays on the same line, closing parenthesis aligns with the clause that contains it. Treat each subquery as its own formatted query.

Does formatting change query execution?

No, SQL formatting is purely cosmetic. The database receives the same logical query regardless of whitespace. Some tools minify SQL to reduce network payload, but this doesn't affect performance.

SQL Formatter

Guide & TutorialOffline

Format and beautify SQL queries

Format and beautify SQL queries instantly with our free online SQL formatter. This tool helps database developers and analysts transform messy SQL into readable, properly indented queries for better maintainability. Simply paste your SQL and get formatted output in real-time.

Indent:

Uppercase keywords

SQL Query

0 characters, 1 lines

Formatted SQL

About SQL Formatting

Format and beautify SQL queries for better readability. This formatter supports common SQL syntax and keywords.

Features:

Automatic keyword detection and formatting
Customizable indentation
Uppercase or lowercase keywords
Column list formatting
WHERE clause formatting
Minification option

Supported statements: SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP

About SQL Formatter

SQL formatting transforms messy, single-line queries into readable, properly indented SQL. This is essential for code reviews, documentation, debugging, and maintaining SQL codebases. Well-formatted SQL is easier to understand, modify, and catch errors in.

How It Works

The formatter parses SQL syntax, identifies clauses (SELECT, FROM, WHERE, etc.), and applies consistent formatting rules: keywords uppercase/lowercase, proper indentation for nested queries, line breaks at logical points, and aligned columns. It preserves the query's functionality while improving readability.

Technical Details

SQL formatting involves: tokenization (identifying keywords, identifiers, literals), clause detection (SELECT, FROM, WHERE, JOIN, GROUP BY, etc.), nested query handling, and style application. Dialects (MySQL, PostgreSQL, SQL Server, Oracle) have syntax variations that formatters must handle.

Common Use Cases

Code Review

Format SQL for readable pull request reviews.

SELECT * FROM users WHERE active=1 → properly indented multi-line

Query Debugging

Format complex queries to identify logical errors.

Documentation

Format SQL examples in documentation and tutorials.

Legacy Code Cleanup

Standardize formatting across old SQL codebases.

Query Optimization

Readable queries make optimization opportunities clearer.

Code Examples

Before and After Formatting

sql

-- Before (hard to read)
SELECT u.id,u.name,u.email,o.total,o.created_at FROM users u INNER JOIN orders o ON u.id=o.user_id WHERE u.active=1 AND o.total>100 ORDER BY o.created_at DESC LIMIT 10;

-- After (formatted)
SELECT
    u.id,
    u.name,
    u.email,
    o.total,
    o.created_at
FROM users u
INNER JOIN orders o ON u.id = o.user_id
WHERE u.active = 1
    AND o.total > 100
ORDER BY o.created_at DESC
LIMIT 10;

Each clause on its own line, consistent indentation, aligned conditions. Much easier to scan and modify.

Using sql-formatter library

javascript

import { format } from 'sql-formatter';

const formatted = format(
  'SELECT * FROM users WHERE id = 1',
  {
    language: 'postgresql',
    tabWidth: 4,
    keywordCase: 'upper',
    linesBetweenQueries: 2,
  }
);

// Output:
// SELECT
//     *
// FROM
//     users
// WHERE
//     id = 1

sql-formatter supports multiple SQL dialects and customizable style options.

Command Line

bash

# Using sqlformat (Python)
pip install sqlparse
sqlformat --reindent --keywords upper -o output.sql input.sql

# Using pgFormatter (PostgreSQL)
pg_format -u 1 input.sql > output.sql

# In-place formatting
sqlformat --reindent -a input.sql

sqlparse is a Python library with CLI. pgFormatter is specialized for PostgreSQL.

Tips & Best Practices

Agree on formatting standards with your team and enforce via CI
Use IDE extensions for automatic formatting on save
Keep related conditions together for readability
Comment complex joins and subqueries
Consider trailing vs leading commas based on team preference

Common Mistakes to Avoid

Inconsistent keyword casing within a project
Over-indenting simple queries
Not aligning related elements (JOINs, AND/OR conditions)
Forgetting to handle dialect-specific syntax

When to Use This Tool

Use SQL formatter whenever writing, reviewing, or documenting SQL queries. Essential for team codebases, code reviews, and anywhere SQL readability matters.

Frequently Asked Questions

Both are valid - SQL is case-insensitive for keywords. Uppercase (SELECT, FROM, WHERE) is traditional and makes keywords stand out from identifiers. Lowercase is more modern and easier to type. Choose one and be consistent.

-- Before (hard to read) SELECT u.id,u.name,u.email,o.total,o.created_at FROM users u INNER JOIN orders o ON u.id=o.user_id WHERE u.active=1 AND o.total>100 ORDER BY o.created_at DESC LIMIT 10; -- After (formatted) SELECT u.id, u.name, u.email, o.total, o.created_at FROM users u INNER JOIN orders o ON u.id = o.user_id WHERE u.active = 1 AND o.total > 100 ORDER BY o.created_at DESC LIMIT 10;

import { format } from 'sql-formatter'; const formatted = format( 'SELECT * FROM users WHERE id = 1', { language: 'postgresql', tabWidth: 4, keywordCase: 'upper', linesBetweenQueries: 2, } ); // Output: // SELECT // * // FROM // users // WHERE // id = 1

# Using sqlformat (Python) pip install sqlparse sqlformat --reindent --keywords upper -o output.sql input.sql # Using pgFormatter (PostgreSQL) pg_format -u 1 input.sql > output.sql # In-place formatting sqlformat --reindent -a input.sql