How does this skill help with database security?

It provides standardized patterns for preventing SQL injection through parameterized queries and the secure use of sp_executesql with QUOTENAME for dynamic SQL.

When should I activate the sqlserver-patterns skill?

Activate this skill when writing T-SQL scripts, designing schemas, performing database migrations, or troubleshooting slow-running queries.

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 assist with query performance tuning?

Absolutely. It offers guidance on indexing strategies, identifying missing indexes via DMV queries, and using window functions to optimize complex data analysis.

SQL Server & T-SQL Patterns

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

byflatrick

0•

Gestión de Bases de Datos

Provides expert guidance and implementation patterns for SQL Server 2016+ and Azure SQL Database optimization and administration.

The sqlserver-patterns skill acts as a comprehensive reference for developers working within the Microsoft SQL Server ecosystem, including Azure SQL Database. It equips Claude with specialized knowledge to write high-performance T-SQL, design robust database schemas, and implement sophisticated indexing strategies. By following proven patterns for transaction management, error handling, and set-based operations, the skill helps developers avoid common pitfalls like SQL injection and performance-degrading cursors while ensuring data integrity and system scalability.

Características Principales

01Expert T-SQL best practices for SQL Server 2016+ and Azure SQL Database

02Advanced indexing strategies including clustered, non-clustered, and filtered indexes

03Secure implementation patterns for parameterized queries and dynamic SQL

04Optimization techniques for replacing row-by-row cursors with set-based operations

05Comprehensive transaction management and error handling (TRY-CATCH) templates

060 GitHub stars

Casos de Uso

01Troubleshooting and resolving query performance issues via indexing and statistics maintenance

02Designing and implementing secure stored procedures with robust transaction isolation

03Refactoring legacy cursor-based logic into high-performance set-based T-SQL queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt sqlserver-patterns

For use in Claude.ai and ChatGPT