Does this skill support Azure SQL Database?

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

What is the advantage of using set-based operations over cursors?

SQL Server is optimized for set-based logic; using these patterns reduces transaction overhead and improves performance compared to row-by-row processing.

Is it useful for data migrations?

Yes, it includes patterns for schema migrations and logic adjustments when moving between SQL Server and other platforms like PostgreSQL.

Can it help me fix slow-running queries?

Absolutely. It provides strategies for index maintenance, query plan analysis, and identifying missing indexes to significantly improve I/O and execution speed.

How does this skill handle database security?

The skill enforces high-security standards by promoting parameterized queries and the correct use of QUOTENAME to prevent SQL injection vulnerabilities.

SQL Server & T-SQL Patterns

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

byflatrick

0•

Gestión de Bases de Datos

Optimizes SQL Server development with industry-standard T-SQL patterns, query performance tuning, and robust database administration strategies.

The SQL Server Patterns skill provides Claude Code with a comprehensive framework for developing, optimizing, and managing SQL Server and Azure SQL databases. It equips the agent with best practices for writing secure, parameterized T-SQL, implementing efficient set-based operations, and designing high-performance indexing strategies. Whether you are troubleshooting slow queries, managing complex transaction logic, or migrating schemas, this skill ensures your database code follows modern standards for performance, security, and maintainability for SQL Server 2016 and beyond.

Características Principales

01Secure T-SQL development via parameterized queries and sp_executesql

02Performance tuning through advanced indexing and statistics maintenance

03Set-based logic optimization to eliminate inefficient row-by-row cursors

04Robust transaction management and concurrency control using isolation levels

05Advanced data manipulation using CTEs, window functions, and TVPs

060 GitHub stars

Casos de Uso

01Identifying and resolving query performance bottlenecks using execution plan insights and missing index hints

02Implementing secure, ACID-compliant transaction handling in stored procedures for Azure SQL Database

03Refactoring legacy row-by-row cursors into efficient set-based T-SQL logic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt sqlserver-patterns

For use in Claude.ai and ChatGPT