Optimize SQL Server queries, schemas, and data types for performance.
npx skills add https://github.com/deepanshu0504/DB-Sanitization --skill mssql-expert
Please help me install this Agent Skill. Skill: mssql-expert Source: https://github.com/deepanshu0504/DB-Sanitization/tree/main/.github/skills/mssql-expert Command: npx skills add https://github.com/deepanshu0504/DB-Sanitization --skill mssql-expert
SQL Server optimization and design guidance to improve performance, reliability, and maintainability of databases and queries.
Provide a sample slow query and schema context to receive targeted optimization recommendations.
High-intent search queries and answers about installing and using this skill.
To optimize slow SQL Server queries, provide the problematic query and schema context to receive targeted execution plan analysis, parameterization, and query optimization recommendations for complex workloads.
The best indexing strategy for T-SQL queries involves selecting clustered, non-clustered, included, and filtered indexes to accelerate common queries while reducing execution plan waste across your schema.
Schema design and data type selection affect SQL Server performance by reducing storage waste and directly improving execution plans, which yields reproducible performance improvements across complex workloads.
Yes, you can use this for safe deployment of stored procedures by applying robust design, error handling, and parameterization best practices to ensure reliable and maintainable database code.
You should avoid filtered indexes for query optimization when your common queries do not align with the filter criteria, which limits their effectiveness and creates execution plan inefficiencies.
gaebalaiAnalyzes SQL queries, slow query logs, and execution plans to suggest database index improvements.
ortus-boxlangEnforce parameterized queries and manage datasources in BoxLang.
bpteamAnalyze SQL execution plans and optimize queries across PostgreSQL, MySQL, SQL Server, and Oracle.
adiytharpansaManage queries, schemas, and performance across SQL and NoSQL databases.
