Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

SQL Formatter VSCode

github.com

  • Free plan
  • Browser extension
6.8 Club score Visit github.com

What SQL Formatter VSCode is

SQL Formatter VSCode is the official Visual Studio Code extension for the SQL Formatter library, formatting SQL files inside the editor. It lists dialect support for BigQuery, DB2, DuckDB, Hive, MariaDB, MySQL, PL/SQL, PostgreSQL, Redshift, Snowflake, Spark, SQLite, Trino, Transact-SQL, and others. When a specific dialect is not detected, it falls back to generic SQL for basic and common statements. Configuration covers keyword, data type, function, and identifier casing; indentation; logical-operator line breaks; expression width; operator spacing; and semicolon placement. The extension can use VSCode tab-size and spaces settings or override them. Detection depends on information supplied by VSCode and installed extensions, so behavior can vary by environment. The underlying JavaScript library also provides a command-line interface and npm package. That library is in maintenance mode, does not support stored procedures or delimiter changes, and lacks direct SQL templating support. A parameter-placeholder workaround is documented for common templating cases.

Who it suits

This extension suits developers formatting SQL in VSCode across multiple dialects. It is less suitable when stored procedures, delimiter changes, or direct templating syntax are required.

Good to know, and what to watch

  • Free MIT-licensed VSCode extension
  • Supports many SQL dialects
  • Configurable casing and indentation
  • Can follow VSCode spacing settings
  • Offers automatic formatting
  • Underlying project is in maintenance mode
  • Stored procedures are unsupported
  • Delimiter changes from semicolons are unsupported
  • SQL templating is not directly supported

Free

Free

Open source

The verdict

SQL Formatter VSCode provides broad dialect coverage and detailed formatting controls within VSCode. Its maintenance-mode library and stated SQL limitations matter for advanced or templated database code.

What the maker publishes

Dialect fallback
If it cannot detect a specific dialect, the extension defaults to generic SQL, which the README describes as suitable for basic and common SQL statements. source
Dialect support
The extension lists dialects including BigQuery, DB2, DuckDB, Hive, MariaDB, MySQL, PL/SQL, PostgreSQL, Redshift, Snowflake, Spark, SQLite, Trino, and TransactSQL. source
Editor settings
The extension can use VSCode tab size and spaces settings or override them through its configuration options. source
Formatting options
Settings include keyword, data type, function, and identifier casing, indentation, logical operator line breaks, expression width, spacing around operators, and semicolon placement. source
Integration
The project identifies the product as a VSCode extension and links to the Visual Studio Marketplace as its extension listing. source
Intended users
The project describes the extension as a tool for formatting SQL files in VSCode. source
Library limitations
The underlying library does not support stored procedures or changing the delimiter from a semicolon. source
Maintenance
The underlying formatter project says it is in maintenance mode, with feasible bug fixes but likely no new features. source
Purpose
SQL Formatter VSCode is the official VSCode extension of the SQL Formatter library and formats SQL files. source
Related library
The underlying SQL Formatter library is a JavaScript library for pretty-printing SQL queries and also offers a command-line interface and npm package. source
Security and license
The extension repository identifies an MIT license and does not describe security certifications or compliance claims in its README. source
Support
The extension README directs users to report issues through the SQL Formatter library's GitHub issue tracker and recommends reading its FAQ first. source
Templating limitation
SQL templating syntax is not directly supported by the underlying library, though its README documents a parameter-placeholder workaround for common cases. source
VSCode environment
Dialect detection depends on information provided by VSCode and can vary with the user's VSCode environment and installed extensions. source

Checked against the maker's pages on 4 Oct 2026.