Can it help with SQL injection prevention?

Absolutely. It provides specific templates for parameterized queries and secure dynamic SQL using sp_executesql and QUOTENAME.

How does it assist with performance tuning?

The skill offers guidance on indexing strategies, identifying missing indexes via system DMVs, and using SET-based operations over cursors.

Does it cover transaction management?

Yes, it provides patterns for explicit transaction handling, TRY/CATCH blocks, and selecting appropriate isolation levels like READ_COMMITTED_SNAPSHOT.

Does this skill support Azure SQL Database?

Yes, it includes specific patterns and best practices optimized for both SQL Server 2016+ and Azure SQL Database environments.

SQL Server & T-SQL Patterns

Name: SQL Server & T-SQL Patterns
Author: flatrick

byflatrick

0•

数据库管理

Provides expert guidance and implementation patterns for T-SQL query optimization, indexing strategies, and database administration.

This skill equips Claude with advanced SQL Server and Azure SQL Database expertise, focusing on performance-optimized T-SQL patterns and modern best practices. It helps developers move beyond row-by-row logic toward efficient set-based operations, implement robust error handling with explicit transactions, and design high-performance indexing strategies. Whether you are troubleshooting slow queries, building complex stored procedures, or managing Azure SQL environments, this skill ensures your database code follows production-grade security and scalability standards for SQL Server 2016 and beyond.

主要功能

01Comprehensive indexing strategies including clustered and filtered indexes

020 GitHub stars

03Set-based logic implementation to replace inefficient cursors

04Advanced transaction handling and isolation level management

05Optimized T-SQL query and stored procedure templates

06Query plan optimization and missing index detection

使用场景

01Troubleshooting and refactoring slow database queries or high I/O operations

02Designing secure, injection-proof database migrations and schemas

03Implementing complex business logic using CTEs and window functions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt sqlserver-patterns

For use in Claude.ai and ChatGPT