Does it include index maintenance scripts?

Yes, it provides T-SQL snippets for checking fragmentation, managing index rebuilds, and identifying missing index hints from the query optimizer.

How does it help prevent SQL injection?

The skill enforces the use of parameterized queries and sp_executesql while providing safe dynamic SQL patterns using QUOTENAME for identifiers.

Does this skill support Azure SQL Database?

Yes, it includes specific best practices and patterns for both on-premise SQL Server 2016+ and modern Azure SQL Database instances.

Can it help me replace slow cursors?

Absolutely. It provides specific patterns for converting row-by-row cursor logic into high-performance, set-based T-SQL operations.

What is the primary benefit of using this skill with Claude?

It provides Claude with domain-specific knowledge to ensure generated SQL is not only functional but also optimized for performance and enterprise-grade security.

SQL Server Patterns

Name: SQL Server Patterns
Author: flatrick

byflatrick

0•

Database Management

Optimizes SQL Server and Azure SQL Database development with T-SQL best practices, performance tuning, and robust security patterns.

This skill provides a comprehensive library of patterns and standards for SQL Server (2016+) and Azure SQL Database. It equips Claude with the expertise to design high-performance schemas, write secure parameterized queries, and implement advanced T-SQL features like window functions and Common Table Expressions (CTEs). Whether you are troubleshooting slow queries, migrating from other database engines, or setting up complex transaction management, this skill ensures your database code follows industry-standard optimization and security protocols to minimize technical debt and maximize I/O efficiency.

Key Features

01Advanced indexing strategies for clustered, non-clustered, and filtered indexes

02Transaction handling frameworks with explicit error catching and isolation levels

03Secure dynamic SQL patterns utilizing sp_executesql and QUOTENAME

040 GitHub stars

05Performance-tuned T-SQL query and stored procedure templates

06Set-based operation patterns to replace inefficient row-by-row cursors

Use Cases

01Designing secure database schemas and migrations for Azure SQL Database environments

02Refactoring legacy T-SQL code to improve query execution speed and reduce locking

03Optimizing index maintenance and identifying missing index opportunities from query plans

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt sqlserver-patterns

For use in Claude.ai and ChatGPT