SQL Formatter
Format and beautify SQL queries instantly. Support for MySQL, PostgreSQL, SQL Server, Oracle, and SQLite. Customize indentation, keyword case, and more. Perfect for database developers.
Embed This Tool
Add this tool to your website with customizable styling
How to Use
Paste your SQL query
Copy and paste your SQL query into the input area, or upload a .sql file. The tool accepts any SQL syntax from simple SELECT statements to complex queries with joins, subqueries, and CTEs.
Select your SQL dialect
Choose the SQL dialect that matches your database: Standard SQL, MySQL, PostgreSQL, SQL Server (T-SQL), Oracle (PL/SQL), or SQLite. Each dialect has specific syntax rules and formatting conventions.
Customize formatting options
Adjust the indentation (2 or 4 spaces, or tabs), and choose whether keywords should be UPPERCASE, lowercase, or preserved as-is. These settings help match your team's coding style guide.
View the formatted result
Your SQL query is instantly formatted with proper indentation, line breaks, and consistent keyword casing. The output panel shows the beautified query ready for use.
Copy or download
Click "Copy" to copy the formatted SQL to your clipboard, or download it as a .sql file. The statistics panel shows the number of lines, SQL keywords, and tables referenced in your query.
Frequently Asked Questions
Why should I format my SQL queries?
Formatted SQL is much easier to read, debug, and maintain. Proper indentation makes the structure of complex queries clear—you can quickly see JOINs, subqueries, and WHERE clauses. Consistent formatting also helps teams collaborate more effectively by following the same style conventions. It's especially valuable when reviewing code or tracking down bugs in production queries.
Which SQL dialects are supported?
The formatter supports Standard SQL (ANSI SQL), MySQL (MariaDB compatible), PostgreSQL, SQL Server (T-SQL with Microsoft-specific syntax), Oracle (PL/SQL with Oracle-specific features), and SQLite. Each dialect has specific formatting rules for keywords, functions, and syntax patterns unique to that database system.
Should I use UPPERCASE or lowercase keywords?
Both are valid and widely used. UPPERCASE keywords (SELECT, FROM, WHERE) make SQL keywords stand out clearly from table and column names, which many developers prefer for readability. Lowercase keywords give a cleaner, more modern look and are easier to type. Choose whatever matches your team's style guide, or use "Preserve" to keep the original casing from your input.
Can I format complex queries with CTEs and subqueries?
Yes! The formatter handles all SQL complexity including Common Table Expressions (CTEs with WITH clauses), nested subqueries, multiple JOINs, UNION statements, window functions, and more. Try the example queries to see how complex structures are formatted with clear indentation that shows the query hierarchy and logic flow.