SQL Safe Formatter & Format on Save for PostgreSQL, MySQL, T-SQL, PL/SQL

Format SQL in VS Code without breaking it. Free, no sign-in, works offline.

• Never changes your code. Each result is checked token by token against your SQL. If anything other than whitespace or keyword case would change, the file stays as it is and a message names the line.
• Keeps what other formatters break: $$ and $BODY$ bodies, DELIMITER $$ blocks, N'...' strings, [names with spaces], `root`@`localhost`, =>, commented-out code, GO and / lines, psql \ commands and COPY ... FROM stdin rows.
• 20 dialects, picked for you from the language mode, the file name or the text: PostgreSQL, MySQL, MariaDB, T-SQL, Oracle PL/SQL, SQLite, BigQuery, Snowflake, Redshift, Spark, Hive, Db2, DuckDB, Trino, ClickHouse and more.
• Stored procedures indented by block, with BEGIN/END, IF/ELSE, loops, DECLARE, EXCEPTION and package bodies.
• Large files work. A 5 MB script took 3.5 to 6 seconds in real VS Code tests (4 threads), with a Cancel button. VS Code stays responsive, because formatting runs outside the editor's process.

Use it

• To format a file, press Shift+Alt+F (Shift+Option+F on a Mac), or right-click and choose Format Document.

• To format a selection, select lines and press Cmd+K Cmd+F (Ctrl+K Ctrl+F), or choose Format Selection.

• To format on save, add this to your settings.

  "[sql]": {
    "editor.formatOnSave": true,
    "editor.defaultFormatter": "zovo.zovo-sql-formatter"
  }
  

• To pick the dialect, click the dialect in the status bar (for example PostgreSQL). The choice is kept for that file. The setting sqlFormatter.dialect sets it for all files.

• For SQL inside a string (Python, JavaScript, Java, C#, Go, PHP), select the SQL or put the cursor in the string, then right-click and choose Format SQL in String.

When it does not format

The file is left as it is when:

• the SQL cannot be read in the chosen dialect (the message names the line, and Pick Dialect tries another one),
• the result would change a token (a string, a name, an operator or a comment),
• the text is nested too deep, or formatting takes longer than the time limit (30 seconds by default).

Format the Rest formats every statement it can read and keeps the others exactly as written. With format on save, the same message shows only once a minute and then moves to the status bar.

Stored procedures

Plain statements inside a procedure are formatted as usual. Control lines go on their own lines and the body is indented by block. MySQL DELIMITER sections, T-SQL GO batches and Oracle / lines are kept.

Why this one

Reviews of two popular SQL formatter listings report these problems. Each one has a test in this repository.

This extension uses the open source sql-formatter library (MIT) for plain statements. The checks, the dialect detection, the procedure layout and the client-line handling are its own.

Settings

Privacy

No network access, no telemetry, no account. The extension reads only the file you format.

Support Zovo

Zovo extensions are free, with no ads and no tracking. They are made by theluckystrike on GitHub. If this one saves you time, you can support the work:

• Sponsor on GitHub
• PayPal
• Follow theluckystrike on GitHub

More tools by Zovo

• SQLite DB Viewer & SQLite Viewer, Database Viewer (Read-Only) browses SQLite tables read-only and runs SELECT queries.
• XLSX Viewer for Excel, CSV & Parquet opens CSV, TSV, Excel and Parquet files as a sortable, filterable table.
• Large JSON Viewer, JSON Browser & JSON Tree shows large JSON files as a searchable tree, copies JSONPath and turns arrays of objects into a table.
• JSONL Viewer, Large JSONL Table & NDJSON Viewer opens JSONL and NDJSON files as a table, as records or as a chat view.
• Avro Viewer, Apache Arrow Viewer & Feather Viewer opens Avro, Arrow and Feather files as a paged table.

See all Zovo extensions on the Marketplace.

License

MIT. The bundled sql-formatter library is MIT licensed (see vendor/sql-formatter.LICENSE).