Does it assist with database performance monitoring?

It provides guidance on reviewing execution plans, updating statistics, and identifying SARGable predicates to ensure your queries utilize indexes effectively.

Does this skill support other databases like PostgreSQL or MySQL?

This skill is specifically optimized for Microsoft SQL Server and T-SQL syntax, focusing on its unique features like execution plans, DMVs, and specific indexing strategies.

How does the T-SQL Pro skill handle SQL security?

It enforces security-first patterns by prioritizing parameterized queries via sp_executesql, implementing row-level security, and validating all inputs to prevent SQL injection.

Can it help me move away from cursors and loops?

Yes, the skill is designed to favor set-based operations over cursors and loops, providing patterns for CTEs and window functions to improve performance.

T-SQL Pro & Database Optimization

Name: T-SQL Pro & Database Optimization
Author: theMickster

bytheMickster

데이터베이스 관리

Writes high-performance, secure T-SQL code and optimizes SQL Server database schemas using industry best practices.

소개

This skill transforms Claude into an expert SQL Server developer specializing in T-SQL programming, query tuning, and database architecture. It provides domain-specific guidance on complex set-based operations, execution plan analysis, and security protocols like SQL injection prevention via parameterization. Whether you are building robust stored procedures, designing advanced indexing strategies, or managing complex transactions, this skill ensures your database layer is maintainable, scalable, and follows Microsoft SQL Server's most efficient implementation patterns.

주요 기능

Query performance optimization and execution plan analysis
Advanced index strategy and fragmentation management
Robust transaction handling with XACT_ABORT and TRY/CATCH logic
Support for modern features like Temporal Tables and JSON integration
Secure T-SQL programming with mandatory query parameterization
0 GitHub stars

사용 사례

Designing normalized database schemas and managing data migrations
Developing secure, production-grade stored procedures and views
Refactoring slow-running queries and optimizing indexing strategies

소개

주요 기능

Query performance optimization and execution plan analysis
Advanced index strategy and fragmentation management
Robust transaction handling with XACT_ABORT and TRY/CATCH logic
Support for modern features like Temporal Tables and JSON integration
Secure T-SQL programming with mandatory query parameterization
0 GitHub stars

사용 사례

Designing normalized database schemas and managing data migrations
Developing secure, production-grade stored procedures and views
Refactoring slow-running queries and optimizing indexing strategies