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 object creation 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/3.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 works with both SQL Server and Azure SQL Database projects based on MSBuild.Sdk.SqlProj or Microsoft.Build.Sql.

The extension depends on the T-SQL Analyzer CLI tool, which is installed as a .NET global tool. If you haven't installed the tool yet, you can do so by running the following command in a terminal:

dotnet tool install -g ErikEJ.DacFX.TSQLAnalyzer.CLI

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.