Tested in November 2026. Formatting in two dialects, keyword case, indent size, the one-line option and error messages were tested with sample queries.
How to format a SQL query
- Paste your SQL into the left box.
- Pick the SQL dialect, the indent size and how keywords should be written.
- Click Format SQL. Use Minify to one line to remove comments and line breaks instead.
- Click Copy result or Download .sql.
Tips for better results
- Choose the dialect your database uses. It helps with quotes and special keywords.
- Format a long query before you debug it so each clause sits on its own line.
- Use uppercase keywords if your team follows that style.
- Format one statement at a time if you paste a long script and see an error.
Limits to know about
- The formatter reads the shape of the query but does not run it or check table and column names.
- If the SQL cannot be read, you get an error message. Try another dialect or fix the syntax.
- Minify removes comments. Do not use it on queries that rely on comment hints.
- The first use needs an internet connection to load the formatting library.
Privacy
Your query is formatted inside your browser and is not sent to ToolsRiver. Only the open-source library is downloaded from a public CDN.
Frequently asked questions
Which databases are supported?
Standard SQL, MySQL, MariaDB, PostgreSQL, SQLite, SQL Server, Oracle PL/SQL, BigQuery, Snowflake and Amazon Redshift.
Does it change what my query does?
No. It only changes spaces, line breaks and optionally the case of keywords.
Can it fix errors in my SQL?
No. It shows an error if it cannot read the query.
Does it keep my comments?
Format keeps them. Minify removes them.
Is it free?
Yes, with no sign-up.
About this tool
ToolsRiver SQL Formatter lays out SQL queries in a clean readable style for many database dialects. It runs in your browser.