- Home
- SQL Linters and Formatters
- TSQLLint
TSQLLint
What it is
TSQLLint is a T-SQL linting tool that identifies and reports anti-patterns in SQL scripts. Its configurable rules can be switched off or set to warnings or errors; error-level findings cause a non-zero exit code. The command-line tool can fix findings it recognizes as fixable with the --fix or -x option. You can configure it with a .tsqllintrc file, or use its in-memory defaults if no file is present. Listed SQL Server compatibility levels are 80, 90, 100, 110, 120, 130, 140, and 150. Custom .NET plugins are supported when they implement TSQLLint's IPlugin interface and target net6.0. Before linting, the tool substitutes values from environment variables for placeholders in SQL files. Supported installation methods include dotnet-tool, Homebrew, and NPM. The VS Code extension activates on opening a .sql file and underlines possible issues for inspection on hover. SQL Server Management Studio can also use TSQLLint through External Tools. It is free software under the MIT License.
For and against
For
- Free under the MIT License.
- Rules can be set to off, warning, or error.
- Command-line option fixes eligible findings.
- Supports custom .NET plugins.
- VS Code and SSMS integration are listed.
Against
- Supports T-SQL only.
- Custom plugins must target net6.0.
- No formal support offering is stated.
The verdict
TSQLLint offers configurable T-SQL checks, optional fixes, and editor or SSMS workflows. Its listed scope is T-SQL, and the project pages do not describe a formal support offering.
Who it suits
TSQLLint suits people working with T-SQL scripts who want configurable checks and reports on undesirable patterns. It may also fit users who want linting through VS Code or SQL Server Management Studio.
Plans and prices
TSQLLint
MIT-licensed software · installable with dotnet-tool, Homebrew, or NPM
Read 30 Sep 2026 · github.com
On the record
- Auto-fix
- The command-line tool can fix problems it identifies as auto-fixable using the --fix or -x option.github.com · read 30 Sep 2026
- Configuration
- Users can create a .tsqllintrc configuration file, and the tool uses an in-memory default configuration when none is found.github.com · read 30 Sep 2026
- Install methods
- The project lists dotnet-tool, Homebrew, and NPM as officially supported installation methods.github.com · read 30 Sep 2026
- Intended users
- The documented use is for people working with TSQL scripts who want to configure and report on undesirable patterns.github.com · read 30 Sep 2026
- 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.github.com · read 30 Sep 2026
- Plugins
- Users can extend the tool with custom .NET plugins that implement TSQLLint's IPlugin interface and target net6.0.github.com · read 30 Sep 2026
- Purpose
- TSQLLint describes, identifies, and reports anti-patterns in TSQL scripts.github.com · read 30 Sep 2026
- Rule controls
- Rules can be configured as off, warning, or error; violations configured as errors return a non-zero exit code.github.com · read 30 Sep 2026
- Security
- The repository lists a security policy, but its security-policy page could not be opened during this research.github.com · read 30 Sep 2026
- SQL compatibility
- The configurable SQL Server compatibility levels listed are 80, 90, 100, 110, 120, 130, 140, and 150.github.com · read 30 Sep 2026
- SQL placeholders
- Before applying lint rules, TSQLLint replaces SQL file placeholders with values supplied through environment variables.github.com · read 30 Sep 2026
- SSMS integration
- The project says SQL Server Management Studio can use TSQLLint through its External Tools feature.github.com · read 30 Sep 2026
- Support
- The repository provides issue and discussion navigation, but the opened project pages do not state a formal support offering.github.com · read 30 Sep 2026
- VS Code integration
- The VS Code extension activates when a .sql file is opened and underlines potential problems for inspection by hovering.marketplace.visualstudio.com · read 30 Sep 2026