T-SQL Analyzer - Live Code Analysis for MSBuild.Sdk.SqlProj SQL Projects

Download this extension from the Visual Studio Marketplace or get the CI build

Analyze your SQL scripts as you type, and get suggestions for improvements based on best practices. The analyzer has over 140 rules covering performance, security, maintainability, and more.

The extension will respect any rule configuration you have in your SQL project, including whether analysis is enabled, SQL version and rule suppression.

<Project Sdk="MSBuild.Sdk.SqlProj/4.2.0">
  <PropertyGroup>
    <TargetFramework>net8.0</TargetFramework>
    <SqlServerVersion>Sql170</SqlServerVersion>
    <RunSqlCodeAnalysis>True</RunSqlCodeAnalysis>
    <CodeAnalysisRules>-SqlServer.Rules.SRD0006;-Smells.*</CodeAnalysisRules>
  </PropertyGroup>
</Project>

The extension also adds a menu item under Tools to run the T-SQL Analyzer tool against the currently open SQL script in the editor.

The extension automatically uses the .NET 10 dnx command to run the T-SQL Analyzer CLI tool as a NuGet package. No separate installation is required. The .NET 10 SDK is required and is automatically installed with the multiple workloads in Visual Studio.

How can I help?

If you enjoy using the extension, please give it a ★★★★★ rating on the Visual Studio Marketplace.

Should you encounter bugs or have feature requests, head over to the GitHub repo to open an issue if one doesn't already exist.

Another way to help out is to sponsor me on GitHub.

If you would like to contribute code, please fork the GitHub repo and submit a pull request.