SqlServer.Rules

概要

SqlServer.Rules provides a comprehensive library of over 120 static code analysis rules designed to ensure T-SQL best practices within SQL Database Projects. It seamlessly integrates into modern SQL projects (based on MSBuild.Sdk.SqlProj or Microsoft.Build.Sql) via NuGet packages, and can also be manually applied to classic Visual Studio SQL Database projects. Beyond its core rule sets, including a fork of TSQL-Smells, the tool offers a versatile .NET command-line interface (SqlAnalyzerCli) for analyzing SQL scripts or projects and outputting results in various formats. Notably, the CLI can function as an MCP Server, enabling real-time SQL code feedback through GitHub Copilot Chat in Visual Studio and VS Code. Additionally, a Visual Studio extension (T-SQL Analyzer) is available for live analysis directly within the IDE, providing instant insights into code quality.

主な機能

• Provides a command-line interface for analyzing SQL scripts and projects.
• Serves as an MCP Server, integrating with GitHub Copilot Chat for live code feedback.
• Offers over 120 static code analysis rules for T-SQL.
• 188 GitHub stars
• Seamlessly integrates into modern SQL Database Projects via NuGet.
• Includes an additional "TSQL Smells" rule set.

ユースケース

• Enforce T-SQL best practices and coding standards in SQL Database Projects.
• Automate static code analysis for SQL during build processes.
• Obtain real-time feedback on SQL code within IDEs using GitHub Copilot Chat.