Side by side
SQL Formatter VSCode vs Sqruff
Both stand on sql linters and formatters. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Free plan Extension
Pick SQL Formatter VSCode if you want configurable SQL formatting inside VSCode at no cost. Look elsewhere if your workflow depends on stored procedures, custom delimiters, or direct SQL templating support; the project also says it is unlikely to add new features.
Visit SQL Formatter VSCode Free plan ExtensionLinuxMac+3
Sqruff brings linting, formatting, and automated fixes to a range of SQL dialects, with editor and CI options. Treat dbt support as experimental when assessing it for dbt projects.
Visit SqruffThe facts
| SQL Formatter VSCode | Sqruff | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Not published |
| Runs on | Extension | Extension, Linux, Mac, Self-hosted, Web, Windows |
| Lowest paid plan | Free or on request | Free or on request |
| Plans published | 1 | 1 |
| Maker | Not published | Not published |
| Website | github.com | github.com |
| On sql linters and formatters | #20 of 26 | #16 of 26 |
SQL Formatter VSCode: what it does well
- Free, MIT-licensed VSCode extension.
- Lists support for 17 SQL dialects.
- Offers configurable casing, indentation, and line-break options.
- Can use VSCode editor spacing settings or its own configuration.
- Automatic formatting fixes are available.
What to know first
- Does not support stored procedures.
- Cannot change the delimiter from a semicolon.
- SQL templating syntax is not directly supported.
- The project is in maintenance mode, with likely no new features.
Sqruff: what it does well
- Supports a broad range of SQL dialects.
- Provides automatic fixes and custom rules.
- Offers VS Code, Zed, and LSP integrations.
- Free and open source under Apache-2.0.
What to know first
- dbt project support is experimental.
- Available editors outside VS Code and Zed need LSP support for integration.
Alternatives to SQL Formatter VSCode Alternatives to Sqruff The whole list