Which database systems are supported by this skill?

This skill is specifically designed for Microsoft SQL Server, focusing on T-SQL proprietary features like Temporal Tables, In-Memory OLTP, and specific syntax for MERGE and APPLY.

Does this skill cover performance optimization?

Yes, it includes patterns for In-Memory OLTP (Hekaton) and natively compiled stored procedures, which are essential for high-concurrency, high-throughput database operations.

How does it handle data synchronization?

It utilizes the MERGE statement combined with the OUTPUT clause, allowing you to synchronize data between tables while simultaneously capturing exactly which rows were inserted, updated, or deleted.

Can this skill help with hierarchical data structures?

Yes, it provides detailed patterns for Recursive Common Table Expressions (CTEs) to navigate and display parent-child relationships such as organizational charts or bill of materials.

Advanced T-SQL Patterns

Name: Advanced T-SQL Patterns
Author: JosiahSiegel

byJosiahSiegel

•

Database Management

Implements complex SQL Server techniques including recursive CTEs, temporal tables, and memory-optimized operations.

This skill empowers Claude with specialized Transact-SQL (T-SQL) patterns for high-performance SQL Server development. It provides production-ready implementations for complex data structures like hierarchical organizations via recursive CTEs, efficient data synchronization using the MERGE and OUTPUT clauses, and sophisticated reporting through advanced grouping sets. Whether you are managing historical data tracking with temporal tables or optimizing high-throughput workloads with In-Memory OLTP, this skill offers the domain-specific guidance and implementation patterns required for enterprise-grade database engineering.

Key Features

01Temporal table configuration for automated point-in-time historical tracking

02In-Memory OLTP and natively compiled procedures for high-performance workloads

03Advanced APPLY operators for correlated subqueries and unpivoting data

04Recursive CTEs for managing hierarchical and tree-structured data

05MERGE and OUTPUT clauses for robust data synchronization and auditing

067 GitHub stars

Use Cases

01Implementing system-versioned historical data auditing for compliance

02Building organizational charts or category hierarchies using recursive queries

03Generating multidimensional business intelligence reports using ROLLUP and CUBE

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add josiahsiegel/claude-plugin-marketplace advanced-patterns

For use in Claude.ai and ChatGPT

Download Skill