sqlserver-codingUse when writing or reviewing SQL Server T-SQL code — enforces T-SQL naming conventions, stored procedure patterns, error handling with TRY/CATCH, transaction management, indexing strategies, and security best practices
sqlserver-er-knowledgebaseUse when reading ER diagrams committed in the project repo and building a structured knowledge base of entities, relationships, columns, keys, and constraints to inform code generation and review
sqlserver-frameworksUse when implementing SQL Server database code with frameworks — enforces patterns for EF Core (Code First, migrations, DbContext), Dapper (query patterns, multi-mapping), DbUp (script naming, runners), and Flyway (versioned migrations)
sqlserver-live-knowledgebaseFallback for sqlserver-er-knowledgebase — connects to a live SQL Server instance using the connection string from .env, introspects every database object (schemas, tables, columns, keys, indexes, views, stored procedures, functions, triggers, constraints, synonyms, sequences), builds a knowledge bas
sqlserver-project-structureUse when scaffolding or reviewing SQL Server project layout — SSDT project structure, migration folder conventions, seed data organization, and schema separation patterns
sqlserver-testingUse when writing tests for SQL Server database code — tSQLt for stored procedure unit tests, EF Core integration tests with transaction rollback, and test database lifecycle management