sqlserver-expert

Provide T-SQL optimization, indexing, and CDC guidance for SQL Server.

10|7|Updated Jan 5, 2026

Search Tags:#performance #indexing #cdc #ef-core #sqlserver #t-sql

Ready to run

npx skills add https://github.com/cuongtl1992/vibe-skills --skill sqlserver-expert

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sqlserver-expert
Source: https://github.com/cuongtl1992/vibe-skills/tree/main/skills/database/sqlserver-expert
Command: npx skills add https://github.com/cuongtl1992/vibe-skills --skill sqlserver-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Tackle SQL Server performance bottlenecks and design questions by delivering expert guidance on T-SQL optimization, indexing, CDC implementation, and .NET integration patterns with EF Core or Dapper.

Core Features & Use Cases

Comprehensive T-SQL optimization recommendations for slow queries and deadlocks.
Index design, including when to add, modify, or remove indexes and how to measure impact.
CDC setup, data capture querying, and integration patterns with .NET apps.
Guidance for schema design, EF Core mappings, and Dapper data access optimizations.

Quick Start

Review a slow SQL query and return an optimized rewritten version with suggested indexes.

Frequently Asked Questions about sqlserver-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I optimize slow T-SQL queries and resolve deadlocks in SQL Server?▼

To optimize slow T-SQL queries and resolve deadlocks, analyze the execution plan to identify bottlenecks. This Skill provides rewritten T-SQL statements, targeted index recommendations, and error handling patterns to improve throughput in enterprise SQL Server environments.

When should I add, modify, or remove indexes in SQL Server?▼

You should add, modify, or remove indexes based on query usage patterns and performance impact measurements. This Skill delivers expert index design strategies, helping you determine optimal indexing structures and measure their effect on SQL Server query performance.

What is the best way to set up CDC and query captured data in SQL Server?▼

Setting up CDC in SQL Server involves enabling capture on target tables and querying the change tracking functions. This Skill provides step-by-step CDC implementation recommendations and integration patterns to consume captured data effectively.

Can I use EF Core or Dapper with SQL Server for optimized data access?▼

Yes, you can use EF Core or Dapper with SQL Server for optimized data access. This Skill offers specific guidance on EF Core mappings and Dapper optimizations to ensure efficient integration and query execution within your .NET applications.

Does this SQL Server guidance apply to enterprise application schema design?▼

Yes, this SQL Server guidance applies to enterprise schema design by addressing structural bottlenecks and data integrity. It delivers validated, actionable recommendations for schema design, indexing, and query optimization tailored for enterprise-scale environments.