SQL Formatter

What does an SQL formatter do?

An SQL formatter (also called SQL beautifier) reformats raw SQL queries with proper indentation, uppercase keywords, and line breaks between clauses. This makes queries easier to read in code review and maintain over time. It never changes query logic — only whitespace and casing.

Which SQL dialects are supported?

The formatter works with standard SQL keywords and is compatible with MySQL, PostgreSQL, SQLite, SQL Server (T-SQL), and Oracle SQL. It formats structure and keywords rather than dialect-specific syntax, making it useful across all common databases.

Will formatting change my query's results?

No. The formatter only changes whitespace and keyword capitalisation. It does not reorder clauses, rename columns, alter JOIN conditions, or modify string literal values. Your query will return exactly the same results before and after formatting.

How do I format SQL in VS Code or another IDE?

Paste your SQL here, click Format SQL, then copy the result back into your editor. Alternatively, VS Code has extensions like 'SQL Formatter' or 'Prettier SQL VSCode'. For a quick one-off format without opening an IDE, this online tool is faster.

Does it handle subqueries, multiple JOINs, and GROUP BY?

Yes. The formatter handles LEFT JOIN, RIGHT JOIN, INNER JOIN, FULL JOIN, CROSS JOIN, GROUP BY, ORDER BY, HAVING, UNION ALL, and nested WHERE conditions. The ON clause is indented beneath its JOIN, and AND/OR conditions are indented under WHERE.

Is my SQL uploaded to a server?

No. All formatting runs locally in your browser using JavaScript. Your SQL queries never leave your device — making this safe for production queries, secrets in connection strings, or sensitive business logic in your codebase.