Does this skill support Azure SQL Database?

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

How does it help prevent SQL injection?

It provides standardized patterns for using parameterized queries and sp_executesql, ensuring that user inputs are never concatenated directly into SQL strings.

Can it assist with query performance tuning?

Absolutely. It includes guidance on indexing strategies, identifying missing indexes via DMVs, and refactoring cursors into set-based operations for better throughput.

Does it include support for modern T-SQL features?

Yes, it covers modern features like Common Table Expressions (CTEs), Window Functions (LAG, LEAD, RANK), and Table-Valued Parameters (TVPs).

What transaction isolation levels are covered?

The skill provides templates for standard READ COMMITTED logic as well as advanced Snapshot Isolation and READ_COMMITTED_SNAPSHOT patterns for high-concurrency environments.

SQL Server Patterns

Name: SQL Server Patterns
Author: flatrick

byflatrick

0•

数据库管理

Provides optimized T-SQL patterns and SQL Server best practices for high-performance database development and administration.

This skill equips Claude with specialized knowledge of SQL Server and Azure SQL Database, offering a library of production-ready patterns for T-SQL scripting, indexing, and transaction management. It guides developers through optimizing query performance using set-based operations, implementing robust error handling with TRY-CATCH blocks, and designing efficient schemas that follow modern administration standards for SQL Server 2016 and beyond. Whether you are migrating from PostgreSQL or building native Azure SQL applications, this skill ensures your database code is secure, scalable, and maintainable.

主要功能

01Robust transaction handling with XACT_ABORT and TRY/CATCH logic

02Set-based operation refactoring to eliminate inefficient cursors

030 GitHub stars

04Secure parameterized query templates and sp_executesql patterns

05Modern T-SQL implementation for CTEs and Window Functions

06Advanced indexing strategies including filtered and covering indexes

使用场景

01Designing and optimizing schemas for Azure SQL Database environments

02Troubleshooting and resolving query performance bottlenecks using DMVs

03Refactoring legacy row-by-row logic into high-performance set-based 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