Overview Version History Q & A Rating & Review
SQL Code Quality
Instant SQL validation for your team — no API key, no setup, works offline.
Checks every .sql file for syntax errors, performance issues, and style problems the moment you save.
What It Checks
🔴 Syntax
Rule
Severity
Unbalanced parentheses
Error
Unclosed string literals
Error
JOIN without ON clause (cross join risk)
Error
WHERE 1=1 always-true condition
Warning
Alias without AS keyword
Warning
Rule
Severity
SELECT * (avoid fetching all columns)
Warning
NOT IN with subquery (use NOT EXISTS)
Warning
Function in WHERE clause (blocks index)
Warning
LIKE with leading wildcard (%value)
Warning
Cursor usage (use set-based instead)
Warning
Missing WITH (NOLOCK) on reads
Info
SELECT DISTINCT overuse
Info
ORDER BY column number
Info
🎨 Code Style
Rule
Severity
Lowercase SQL keywords
Info
sp_ prefix on stored procedures
Warning
Missing schema prefix (dbo.Table)
Info
Missing SET NOCOUNT ON in procedures
Warning
ISNULL vs COALESCE
Info
Hardcoded dates
Info
PRINT statements left in code
Warning
How to Use
Auto-analysis on save — just save your .sql file and issues appear instantlyRight-click in the editor → SQL: Validate & Analyze Current File View all issues in the Problems panel (Ctrl+Shift+M)
Status bar shows live count: $(database) SQL ❌2 ⚠️3 ℹ️5
Settings
Setting
Default
Description
sqlQuality.autoAnalyzeOnSavetrueAuto-run on every save
sqlQuality.enableSyntaxCheckstrueToggle syntax rules
sqlQuality.enablePerformanceCheckstrueToggle performance rules
sqlQuality.enableStyleCheckstrueToggle style rules
Supported File Extensions
.sql .ddl .dml .proc .view .func .trg
