SQL Formatter and Prettifier

Format SQL queries with keyword uppercasing, proper indentation, and dialect support.

Loading...
1. Paste your SQL query - whether a single-line statement or a complex multi-join query - into the input area. 2. Select your SQL dialect (PostgreSQL, MySQL, SQLite, SQL Server) for dialect-specific formatting. 3. Configure formatting options such as keyword casing, indentation size, and comma placement. 4. View the beautifully formatted SQL with uppercase keywords, indented clauses, and aligned columns. 5. Optionally toggle the minify mode to compress the SQL into a single compact line. 6. Click the copy button to copy the formatted SQL for use in your database client or application.

About This Tool

The SQL Formatter and Prettifier transforms messy, single-line, or poorly formatted SQL queries into clean, readable code with proper indentation, keyword uppercasing, and logical line breaks. It supports common SQL dialects including standard SQL, PostgreSQL, MySQL, SQLite, and SQL Server syntax.

Reading and debugging complex SQL queries is difficult when everything is on one line or inconsistently formatted. This formatter parses the SQL syntax and rebuilds the query with industry-standard formatting conventions: uppercase keywords (SELECT, FROM, WHERE, JOIN), indented clauses, aligned column lists, and clear separation between query sections.

The tool handles a wide range of SQL statements including SELECT queries with subqueries and CTEs, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, and more. It preserves string literals, comments, and table/column aliases while reformatting the structure around them.

Frequently Asked Questions

The formatter supports standard SQL syntax and is compatible with PostgreSQL, MySQL, SQLite, SQL Server, and Oracle. While each dialect has unique features, the core formatting rules apply universally across all of them.
No. The formatter only changes whitespace, line breaks, and keyword casing. The logical meaning and execution behavior of your query remain exactly the same. All table names, column names, values, and aliases are preserved.
Yes. You can configure options including indentation size, keyword casing (uppercase, lowercase, or preserve original), comma position (leading or trailing), and whether to place each column on its own line.
Yes. The formatter properly indents subqueries within parentheses and formats Common Table Expressions (WITH clauses) with clear structure. Nested subqueries are indented at each level for readability.
Yes. The tool includes a minify option that removes all unnecessary whitespace and line breaks, compressing the SQL to a single line. This can be useful for embedding queries in code or URLs.

Related Tools

JSON Formatter and Validator

Format, validate, and beautify JSON data with syntax highlighting, tree view, and error detection.

Developer Tools

CSS Minifier

Minify CSS by removing whitespace, comments, and redundant code to reduce file size.

Developer Tools

JavaScript Minifier

Minify JavaScript by removing whitespace, comments, and shortening variable names for smaller files.

Developer Tools

Regex Tester

Test regular expressions with real-time match highlighting, group capture display, and a pattern library.

Developer Tools

JSON to CSV Converter

Convert JSON arrays and objects to CSV format with customizable delimiters and column mapping.

Developer Tools

CSV to JSON Converter

Convert CSV data to JSON arrays or objects with automatic type detection and header mapping.

Developer Tools