Free Online SQL Formatter
Format and beautify SQL queries online with syntax highlighting. Supports MySQL, PostgreSQL, SQL Server, Oracle, BigQuery, Snowflake and more. Free, 100% client-side.
100% Client-Side · Your data never leaves your browserHow to Use SQL Formatter
Paste your SQL query into the Input SQL panel on the left. Select your database dialect and preferred indent size from the toolbar.
- Click Format or press Ctrl/Cmd+Enter to produce the formatted, syntax-highlighted output in the right panel.
- Use Load sample to insert a multi-table example query and see the formatter in action.
- Click Copy to copy the formatted SQL to your clipboard.
The formatter handles SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and most other standard SQL statements. Subqueries and CTEs are indented for clarity.
Frequently Asked Questions
Which SQL dialects are supported?
The formatter supports Standard SQL, BigQuery, DB2, Hive, MariaDB, MySQL, N1QL, PL/SQL (Oracle), PostgreSQL, Redshift, SingleStoreDB, Snowflake, SparkSQL, SQLite, TransactSQL (SQL Server), and Trino.
Does the formatter validate SQL syntax?
No. The formatter restructures whitespace and indentation to produce readable output, but it does not execute or fully parse the SQL. Invalid SQL may still be formatted without an error message.
What indentation options are available?
You can choose 2-space or 4-space indentation. The setting controls how deeply nested clauses (such as subqueries and CASE expressions) are indented.
Will the formatter change my query logic?
No. Formatting only affects whitespace — keywords, identifiers, literals, and the overall query structure remain unchanged.
Is my SQL sent to any server?
No. All formatting is done in your browser using the sql-formatter library. Your queries never leave your device.
Why should I choose a specific dialect?
Different databases use different reserved words and quoting conventions. For example, MySQL uses backtick quoting while PostgreSQL uses double quotes. Selecting the correct dialect ensures reserved words are capitalised correctly and identifiers are handled appropriately.