sql-server-tools

SQL Server code review specialist. Reviews T-SQL code for correctness, performance anti-patterns, security vulnerabilities, and regression risks. Covers business logic verification, SQL injection prevention, parameter binding, and naming conventions. Use when SQL code changes need review before deployment. Do NOT use for query optimization (use sql-performance-tuner) or writing new queries (use tsql-specialist).

Deep SQL Server performance monitoring and diagnostics specialist. Analyzes wait statistics, CPU utilization, memory pressure, I/O bottlenecks, blocking chains, index effectiveness, TempDB contention, and Query Store health. Use when the user reports slow queries, high CPU, database health checks, needs baseline metrics, or proactive performance monitoring. Do NOT use for query writing (use tsql-specialist) or schema exploration (use sql-schema-discovery).

SQL Server query optimization specialist. Analyzes execution plans, identifies bottlenecks, recommends index strategies, and suggests query rewrites. Use when the user has a slow query, needs index recommendations, wants execution plan analysis, or needs query rewrite suggestions. Do NOT use for server-wide monitoring (use sql-performance-monitor) or schema exploration (use sql-schema-discovery).

SQL Server schema exploration and documentation specialist. Discovers table structures, relationships, dependencies, indexes, and special table types (graph, temporal, memory-optimized). Use when the user needs to understand database schemas, find foreign keys, trace object dependencies, or generate schema documentation. Do NOT use for performance analysis (use sql-performance-monitor) or query optimization (use sql-performance-tuner).

Expert T-SQL development specialist. Writes complex queries, stored procedures, functions, and views with proper optimization. Handles CTEs, window functions, dynamic SQL, JSON operations, and graph queries. Use when the user needs to write, troubleshoot, or understand T-SQL code. Do NOT use for performance monitoring (use sql-performance-monitor) or execution plan analysis (use sql-performance-tuner).

Routes SQL Server tasks to specialized agents. Use when working with SQL Server databases, T-SQL queries, database performance, schema exploration, or SQL code review. Automatically selects the best agent for the task.