SQLCheck vs TSQLLint
SQLCheck
github.comTSQLLint
github.comSide by side
| Figure | SQLCheck | TSQLLint |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · SQL Linters and Formatters | 8.2 (#7) | 7.4 (#19) |
| License | The repository says SQLCheck is licensed under the Apache 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 | SQLCheck automatically detects common SQL anti-patterns that can slow queries. | TSQLLint describes, identifies, and reports anti-patterns in TSQL scripts. |
| Support | The project invites users to open issues, submit pull requests, and improve its documentation. | The repository provides issue and discussion navigation, but the opened project pages do not state a formal support offering. |
Plans
In their own words
SQLCheck
SQLCheck is a free command-line utility that scans SQL files for common anti-patterns associated with slow queries. It groups findings into logical database design, physical database design, query, and application development categories. Users can choose to check all patterns, medium- and high-risk patterns, or only high-risk patterns. The command line accepts a SQL file name and offers color and verbose output modes. The project identifies Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and SQLite3 as supported dialects, and says it targets all major SQL dialects. Downloads are listed for Debian, RPM, macOS DMG, Windows EXE, and ZIP. Release notes for v1.3 list line numbers and a status code of 1 when anti-patterns are found. SQLCheck does not automatically fix findings and has no editor extensions or configuration file. Source-build instructions name g++ 4.9 or later and CMake. The repository identifies the license as Apache-2.0 and welcomes issues, pull requests, and documentation contributions.
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.