SQL Formatter

Note: Bulk SQL formatting is currently not available. For formatting multiple queries, please use the standard tool multiple times or contact us about API access.

Use the Tool tab to format individual SQL queries

Format, beautify, and validate SQL queries with proper indentation and syntax highlighting. Supports MySQL, PostgreSQL, SQL Server, and other SQL dialects.

How to Use

1. Paste your SQL query into the text area
2. Choose your formatting preferences (indentation, keyword case, etc.)
3. Click "Format SQL"
4. Copy or download your formatted SQL

Formatting Options

• Indentation: Choose between 2 spaces, 4 spaces, or tabs
• Keyword Case: Format SQL keywords as UPPERCASE, lowercase, or preserve original
• Line Between Queries: Add blank lines between separate SQL statements
• Comma Position: Place commas at the start or end of lines

Example

SELECT u.id,u.name,u.email,o.order_id,o.total FROM users u INNER JOIN orders o ON u.id=o.user_id WHERE u.status='active' AND o.total>100 ORDER BY o.created_at DESC LIMIT 10;

SELECT
    u.id,
    u.name,
    u.email,
    o.order_id,
    o.total
FROM users u
INNER JOIN orders o ON u.id = o.user_id
WHERE u.status = 'active'
    AND o.total > 100
ORDER BY o.created_at DESC
LIMIT 10;

Supported SQL Statements

Best Practices

• Use UPPERCASE for SQL keywords (SELECT, FROM, WHERE, etc.)
• Use consistent indentation (4 spaces recommended)
• Put each column on a new line in SELECT statements
• Align JOIN conditions for readability
• Add comments to explain complex queries
• Use meaningful table and column aliases

Common Use Cases

• Clean up minified or compressed SQL queries
• Standardize SQL formatting across a team
• Make complex queries more readable for debugging
• Prepare queries for documentation
• Convert between different SQL style guides