sqlfmt vs TSQLLint
sqlfmt
sqlfmt.appTSQLLint
github.comSide by side
| Figure | sqlfmt | TSQLLint |
|---|---|---|
| Price from | $9/mo | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | — |
| Plans published | 2 | 1 |
| Spec score · SQL Linters and Formatters | 7.9 (#12) | 7.4 (#19) |
| Support | The maker lists [email protected] as the fastest way to reach it for questions, bug reports, feature ideas, and feedback. | The repository provides issue and discussion navigation, but the opened project pages do not state a formal support offering. |
Plans
In their own words
TSQLLint
TSQLLint checks T-SQL scripts for anti-patterns and reports the findings. Its command-line tool can correct issues it identifies as auto-fixable with the --fix or -x option. Rules can be set to off, warning, or error; an error-level violation produces a non-zero exit code. Users can save settings in a .tsqllintrc file, or use the tool’s in-memory defaults when no file is present. The listed SQL Server compatibility levels are 80, 90, 100, 110, 120, 130, 140, and 150. Custom .NET plugins can extend it if they implement TSQLLint’s IPlugin interface and target net6.0. Before linting, it substitutes SQL file placeholders with values from environment variables. Official installation methods include dotnet-tool, Homebrew, and NPM. Its VS Code extension marks potential problems in opened .sql files for inspection on hover, and SQL Server Management Studio can invoke it through External Tools. TSQLLint is free under the MIT License and runs on Linux, macOS, and Windows, with an editor extension also listed.