How does it help with query performance?

It provides patterns for identifying missing indexes, avoiding costly row-by-row cursors, and using inline table-valued functions to help the optimizer generate better execution plans.

Can it help prevent SQL injection?

Absolutely. It includes strict templates for parameterized queries and safe dynamic SQL execution using sp_executesql and QUOTENAME to ensure user input is never concatenated directly.

Does this skill support Azure SQL Database?

Yes, the patterns are optimized for both on-premises SQL Server 2016+ and Azure SQL Database environments.

Is it useful for database migrations?

Yes, it provides specific guidance for implementing SQL Server-specific features and performance patterns when migrating to or from other platforms like PostgreSQL.

SQL Server & T-SQL Patterns

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

byflatrick

0•

数据库管理

Implements industry-standard T-SQL best practices and performance optimization patterns for SQL Server and Azure SQL Database.

This skill provides Claude with a comprehensive reference for modern SQL Server development, focusing on performance, security, and maintainability. It covers everything from preventing SQL injection with parameterized queries to advanced indexing strategies, transaction management, and window functions. Whether you are designing new schemas, troubleshooting slow queries, or migrating from other database systems like PostgreSQL, this skill ensures your T-SQL code adheres to expert patterns for SQL Server 2016+ and Azure SQL environments.

主要功能

01Standardized templates for stored procedures and Table-Valued Functions (TVFs)

020 GitHub stars

03Transaction management with proper error handling using TRY/CATCH

04Parameterized query and dynamic SQL security patterns

05Performance optimization using SET-based operations over cursors

06Advanced indexing strategy and maintenance routines

使用场景

01Designing secure, injection-proof database interaction layers

02Optimizing slow-running T-SQL queries and identifying missing indexes

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