Advanced T-SQL patterns and techniques for SQL Server. Use this skill when: (1) User needs help with CTEs or recursive queries, (2) User asks about APPLY operator, (3) User wants MERGE or OUTPUT clause help, (4) User works with temporal tables, (5) User needs In-Memory OLTP guidance, (6) User asks about advanced grouping (ROLLUP, CUBE, GROUPING SETS).
Quickly install advanced-patterns AI skill to your development environment via command line
Source: josiahsiegel/claude-plugin-marketplace.
| Hierarchical data | Recursive CTE | | Top N per group | ROWNUMBER + CTE | | Correlated subquery alternative | CROSS/OUTER APPLY | | Upsert (insert or update) | MERGE | | Capture modified rows | OUTPUT clause | | Historical data tracking | Temporal tables | | High-throughput OLTP | In-Memory OLTP | | Multiple aggregation levels | ROLLUP/CUBE/GROUPING SETS |
Advanced T-SQL patterns and techniques for SQL Server. Use this skill when: (1) User needs help with CTEs or recursive queries, (2) User asks about APPLY operator, (3) User wants MERGE or OUTPUT clause help, (4) User works with temporal tables, (5) User needs In-Memory OLTP guidance, (6) User asks about advanced grouping (ROLLUP, CUBE, GROUPING SETS). Source: josiahsiegel/claude-plugin-marketplace.
Stable fields and commands for AI/search citations.
npx skills add https://github.com/josiahsiegel/claude-plugin-marketplace --skill advanced-patternsBrowse more skills from josiahsiegel/claude-plugin-marketplace
Advanced T-SQL patterns and techniques for SQL Server. Use this skill when: (1) User needs help with CTEs or recursive queries, (2) User asks about APPLY operator, (3) User wants MERGE or OUTPUT clause help, (4) User works with temporal tables, (5) User needs In-Memory OLTP guidance, (6) User asks about advanced grouping (ROLLUP, CUBE, GROUPING SETS). Source: josiahsiegel/claude-plugin-marketplace.
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/josiahsiegel/claude-plugin-marketplace --skill advanced-patterns Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
https://github.com/josiahsiegel/claude-plugin-marketplace