Is it useful for database migrations?

Yes, it provides specific logic patterns for migrating schemas and T-SQL objects between PostgreSQL and SQL Server platforms.

How does it handle performance tuning?

It provides templates for identifying missing indexes via DMVs, checking fragmentation, and converting inefficient cursors into optimized set-based operations.

Does this skill support Azure SQL Database?

Yes, it includes specific patterns and best practices tailored for both on-premises SQL Server 2016+ and Azure SQL Database environments.

Can it help with SQL injection prevention?

Absolutely. The skill strictly enforces the use of parameterized queries and secure dynamic SQL via sp_executesql and input validation using QUOTENAME.

SQL Server Patterns

Name: SQL Server Patterns
Author: flatrick

byflatrick

0•

数据库管理

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

The SQL Server Patterns skill provides a comprehensive library of domain-specific guidance for developers working with SQL Server 2016 and later. It equips Claude with the ability to generate secure, parameterized queries, design efficient indexing strategies (including filtered and covering indexes), and implement robust error handling using TRY...CATCH blocks. This skill is essential for optimizing query performance, managing transaction isolation levels, and migrating between database platforms like PostgreSQL and Azure SQL while maintaining high standards of data integrity and system performance.

主要功能

01Standardized transaction management and error handling

02Optimized T-SQL query and stored procedure generation

030 GitHub stars

04Secure dynamic SQL implementation using sp_executesql

05Advanced indexing strategies and maintenance patterns

06Azure SQL Database and PostgreSQL migration guidance

使用场景

01Refactoring row-by-row cursor logic into high-performance set-based operations

02Designing scalable database schemas with covering and composite indexes

03Implementing secure, injection-proof dynamic SQL for flexible reporting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt sqlserver-patterns

For use in Claude.ai and ChatGPT