SQLFormat.org vs TSQLLint
SQLFormat.org
sqlformat.orgTSQLLint
github.comSide by side
| Figure | SQLFormat.org | TSQLLint |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | Yes | — |
| Web | Yes | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | — |
| Self-hosted | Yes | — |
| Plans published | 2 | 1 |
| Spec score · SQL Linters and Formatters | 8.4 (#4) | 7.4 (#19) |
| License | The site says the sqlparse module is released under the New BSD License. | The software is distributed under the MIT License, which grants permission to use, copy, modify, distribute, sublicense, and sell copies subject to its conditions. |
| Purpose | SQLFormat is a free online formatter for SQL statements. | TSQLLint describes, identifies, and reports anti-patterns in TSQL scripts. |
| Support | The site invites users to send feedback or report bugs using the Feedback button at the bottom of the page. | The repository provides issue and discussion navigation, but the opened project pages do not state a formal support offering. |
Plans
In their own words
SQLFormat.org
SQLFormat.org has no write-up on Specifiction yet; its figures are above.
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.