SQL Formatting Best Practices & Online SQL Formatter

Why Format SQL?

Raw or minified SQL queries are notoriously hard to read, especially complex ones with multiple JOINs, subqueries, and WHERE clauses. Well-formatted SQL:

• Makes code review significantly faster
• Makes bugs easier to spot (off-by-one JOIN conditions, wrong aliasing)
• Reduces onboarding time for new developers
• Improves maintainability of stored procedures and views

Keyword Casing

There are two dominant conventions — choose one and be consistent:

• UPPERCASE keywords (traditional): SELECT id, name FROM users WHERE active = 1
• lowercase keywords (modern): select id, name from users where active = 1

Uppercase is more common in legacy codebases and SQL Server environments. Lowercase is increasingly popular in PostgreSQL and modern stacks. Both are equally valid — consistency within a codebase is what matters.

Indentation and Line Breaks

Break complex queries across multiple lines. A widely used convention:

SELECT
  u.id,
  u.name,
  o.total
FROM users u
  INNER JOIN orders o ON u.id = o.user_id
WHERE u.active = 1
  AND o.created_at > '2026-01-01'
ORDER BY o.created_at DESC
LIMIT 100;

Key principles: each major clause on its own line, selected columns indented, JOIN conditions aligned.

Aliasing Best Practices

• Always use explicit aliases for tables in multi-table queries
• Use meaningful short aliases (u for users, o for orders)
• Always use the AS keyword for column aliases for clarity: COUNT(*) AS total_orders

Comment Your SQL

Complex queries deserve comments, especially in stored procedures:

-- Returns top 10 users by order value in the last 30 days
SELECT u.id, u.name, SUM(o.total) AS total_spend
FROM users u
INNER JOIN orders o ON u.id = o.user_id
WHERE o.created_at >= NOW() - INTERVAL '30 days'
GROUP BY u.id, u.name
ORDER BY total_spend DESC
LIMIT 10;

Using the ToolsPal SQL Formatter

1. Paste your SQL query into the input panel
2. Choose your preferred keyword case (upper or lower)
3. The formatted query appears instantly with proper indentation and line breaks
4. Copy or download the formatted result