A new VS Code extension brings the T-SQL Analyzer's live static analysis to the editor, catching design, naming, and performance issues in SQL scripts as you type, with no build step required. It uses the same 140+ open source DacFX-based rules already available in the Visual Studio and SSMS extensions, adding a dedicated .sql file analyzer with hover documentation, customizable rule expressions, configurable SQL Server version targeting, and command palette actions. Requires the .NET 10 SDK and installs analyzer tooling automatically on first use.
Questions this post answers
Is there a VS Code extension that gives live T-SQL error checking as you type, like a compiler?
Yes, the T-SQL Analyzer extension for VS Code analyzes .sql files in real time and shows squiggles for design, naming, and performance issues as you edit, without requiring a build step. It uses over 140 built-in DacFX-based rules, supports hover documentation, customizable rule expressions, and targets a configurable SQL Server version (default Sql170). It requires the .NET 10 SDK or later. Developers wiring up SQL tooling in their editor can track workflow updates like this on daily.dev.
How do I disable a specific rule or promote a rule to an error in the T-SQL Analyzer VS Code extension settings?
Use the tsqlAnalyzer.rules setting with a rules expression: prefix a rule id with a minus sign to disable it (e.g. -SqlServer.Rules.SRD0004), use a wildcard like -SqlServer.Rules.SRN* to disable a category, and prefix with +! to promote a rule to an error (e.g. +!SqlServer.Rules.SRN0005). Combine multiple expressions with semicolons. Anyone tuning linting rules for their SQL codebase can follow tooling changes like this via daily.dev.