EVERYTHING XIAOMI
Get listed

SQL Formatter VSCode

SQL Formatter VSCode is the official VSCode extension for the SQL Formatter library, designed to format SQL files in the editor.

Place
#23 of 26
Score
5.7
SQL Formatter VSCode's website

What SQL Formatter VSCode is

SQL Formatter VSCode is the official VSCode extension for the SQL Formatter library, designed to format SQL files in the editor. It lists support for dialects including BigQuery, DB2, DuckDB, Hive, MariaDB, MySQL, PL/SQL, PostgreSQL, Redshift, Snowflake, Spark, SQLite, Trino and Transact-SQL, among others. If the extension cannot detect a specific dialect, it falls back to generic SQL, which the project describes as appropriate 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. It can follow VSCode's tab-size and spaces settings or use its own configuration. Dialect detection relies on information from VSCode, so behavior can vary with the user's environment and installed extensions. The underlying formatter library is in maintenance mode, with feasible bug fixes but likely no new features. It does not support stored procedures or changing the delimiter from a semicolon; SQL templating syntax is also not directly supported. The extension is free and MIT-licensed.

Good

  • Supports a broad list of SQL dialects.
  • Offers casing, indentation and spacing settings.
  • Can use VSCode editor spacing settings.
  • Free, MIT-licensed extension.

Watch out

  • Stored procedures are not supported by the library.
  • The delimiter cannot be changed from a semicolon.
  • SQL templating syntax is not directly supported.
  • The formatter project is in maintenance mode.

Who it suits

This extension suits people who format SQL files in VSCode and want options for dialects and layout. It may be less suitable for workflows that depend on stored procedures, custom delimiters or direct SQL templating support.

Verdict

SQL Formatter VSCode provides configurable SQL formatting inside VSCode, with many dialect options and a generic fallback. Check its library limitations and maintenance status if your workflow depends on stored procedures, alternate delimiters or newer features.

Plans and prices

From SQL Formatter VSCode's own pricing page, checked 4 Oct 2001.

All about pricing
PlanPriceWhat it gives you
FreeFreeMIT-licensed VSCode extension for formatting SQL files

The facts

Each one read from SQL Formatter VSCode's own pages, with the date it was checked.

What it does

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

Alternatives to SQL Formatter VSCode

All alternatives
  1. 1

    Poor SQL

    Free planOpen sourceWebAPIExtensionLinux
    7.3Free plan
    Visit
  2. 2

    SQLFormat.org

    Free planOpen sourceWebAPIExtensionSelf-hosted
    7.1Free plan
    Visit
  3. 3

    sqlfmt

    Free planWebAPILinuxSelf-hosted
    6.7Free plan
    Visit
  4. 4

    RegSQL

    Free planWeb
    6.5From $8 a month
    Visit
  5. 5

    SQLCheck

    Free planLinuxmacOSWindows
    6.5Free plan
    Visit
  6. 6

    sqlfmt

    Free planWebAPI
    6.5From $9 a month
    Visit