About SQL Formatter

Format and prettify SQL queries. Part of the DevTools Surf developer suite. Browse more tools in the Generators collection.

Use Cases

• Formatting complex ORM-generated queries for debugging
• Standardizing SQL style across a team's migration files
• Making stored procedures readable during code review
• Cleaning up ad-hoc analytics queries before sharing results

Tips

• Format minified SQL queries for readable code reviews
• Uppercase SQL keywords for consistent team style conventions
• Paste complex joins to visually verify table relationships

Fun Facts

• SQL was originally called SEQUEL (Structured English Query Language) at IBM in 1974 but was renamed due to a trademark conflict.
• The SQL standard (ISO 9075) has grown from 600 pages in SQL-92 to over 4,400 pages in SQL:2023.
• Edgar F. Codd published his relational model paper in 1970, but it took until 1979 for Oracle to release the first commercial SQL database.

FAQ

Which SQL dialects are supported?

PostgreSQL, MySQL, SQLite, SQL Server, Oracle, BigQuery, Snowflake. Dialect affects keyword capitalization and function name handling.

What style does it produce?

Uppercase keywords, commas leading, joins on their own line, WHERE clauses aligned. Modify the options to match your project's style guide.

Does it validate the SQL?

Syntax check per dialect. Execution-level validation (does the table exist?) requires a live database — out of scope.

What about stored procedures?

Supported for each dialect's procedural extensions (PL/pgSQL, T-SQL, PL/SQL). Indentation rules for control flow (BEGIN/END, IF) are dialect-specific.