SQL Formatter Online
Paste SQL or open a .sql file to format it in 20 dialects. Strings, comments, $$ bodies and quoted names stay exactly as written, and each statement is listed with its tables. No account and no upload.
SQL Formatter for VS Code and Cursor, free
- Format with Shift+Alt+F, format a selection, or format on save.
- Format SQL inside Python, JavaScript, Java, C#, Go and PHP strings.
- The dialect is picked for you from the language mode, the file name or the text, and big files format in several threads with a Cancel button.
Optional Zovo Pro, USD 19 once: format all SQL files in a folder, and compare two SQL files ignoring formatting. 3 free tries for each.
Drop a .sql file here
or
.sql scripts and other SQL text up to 16 MB: PostgreSQL, MySQL, MariaDB, T-SQL, Oracle PL/SQL, SQLite, BigQuery, Snowflake and more.
Statements
| # | Line | Kind | Tables | Result |
|---|
Open this in VS Code or Cursor
This page runs the format engine of the free SQL Formatter extension. In VS Code and Cursor it also formats on save, formats a selection, formats SQL inside Python, JavaScript, Java, C#, Go and PHP strings, and picks the dialect from the file for you.
Free, MIT license. About SQL Formatter for VS Code.
Zovo Pro
Format a whole folder of SQL files, and compare two SQL files ignoring formatting. Zovo Pro, USD 19 once.
In the SQL Formatter extension, Zovo Pro formats every .sql file in a folder with the same safe engine (or writes a Markdown report and changes nothing, for a review or a CI check), and compares two SQL files with formatting ignored, so only real changes show. Each Pro tool works 3 times for free. One payment covers the Pro tools in 22 Zovo extensions. Everything that is free stays free.
After a card payment you get a key on the page. With GitHub Sponsors you sign in from the extension. Details on the Zovo Pro page.
Related tools
- SQLite Editor & Viewer on the VS Code Marketplace (also on Open VSX). Opens .db and .sqlite files as tables, edits cells and runs SQL.
- Postgres & MySQL Query Client. Runs Postgres and MySQL queries, edits rows and exports CSV in VS Code.
- Oracle SQL & SQL Server Query Client. Runs Oracle SQL and T-SQL and browses tables in VS Code.
- SQLite Editor & Viewer. Opens .db and .sqlite files as tables, with a SQL box.
- SQLite Viewer Online, free in your browser.
- CSV Viewer Online, free in your browser.
- Excel Viewer Online, free in your browser.
Questions
Is my SQL uploaded anywhere?
No. The page reads the file or the text you paste inside this tab and formats it in a background worker of the page. Its Content Security Policy sets connect-src to none, so the page cannot send your SQL anywhere. Open the Network tab of your browser tools and you will see no request when you format.
Can it break my SQL?
It is built not to. Strings, quoted names and $$ bodies are set aside before formatting and put back after it, and then the result is compared with your SQL token by token. If anything other than whitespace or keyword case would change, the page shows your text unchanged and names the line. Format the rest then formats every statement it can read and keeps the others exactly as written.
Which dialects does it know?
Standard SQL, PostgreSQL, MySQL, MariaDB, T-SQL (SQL Server), Oracle PL/SQL, SQLite, BigQuery, Snowflake, Amazon Redshift, Spark SQL, Hive, IBM Db2, Db2 for i, DuckDB, Trino, Couchbase N1QL, SingleStore, TiDB and ClickHouse. Auto picks one from the file name and from hints in the text, such as $$ bodies, DELIMITER lines, GO lines or PRAGMA.
What happens to DELIMITER, GO and psql lines?
They are kept byte for byte. MySQL DELIMITER sections, T-SQL GO batches, the Oracle / line and SQL*Plus commands, psql backslash commands and COPY ... FROM stdin rows are left as they are, and each statement between them is formatted on its own.
Does it indent stored procedures?
Yes. Procedures, functions, triggers and PL/SQL packages are indented by block, with BEGIN and END, IF and ELSE, loops, DECLARE and EXCEPTION. Turn off Indent procedures by block to format them as plain statements.
What does the statement list show?
Every statement with its first line, its kind (such as SELECT, INSERT, CREATE TABLE or CREATE FUNCTION) and the tables it names after FROM, JOIN, INTO, UPDATE and TABLE, plus whether it was formatted. Click a row to jump to its line in your SQL.
Does it work offline?
Yes. After the first visit the page keeps a copy of its own files, so it formats SQL with no connection.
What is free and what is Zovo Pro?
Everything on this page is free. In the SQL Formatter extension, Format Document, Format Selection, format on save, Format SQL in String and every setting are free too. Formatting a whole folder of SQL files and comparing two SQL files ignoring formatting are Zovo Pro, with 3 free tries each. One USD 19 payment covers the Pro tools in every Zovo extension.