SKILL·6716FB

advanced-patterns

majiayu000
Updated 2 months ago
37 views
58
9
58
View on GitHub
Metadesign

About

This skill provides advanced T-SQL patterns and techniques for SQL Server developers. Use it for help with CTEs, recursive queries, APPLY operator, MERGE statements, temporal tables, and advanced grouping operations. It offers practical guidance for complex SQL Server scenarios like hierarchical data, upserts, and performance optimization.

Quick Install

Claude Code

Recommended
Primary
npx skills add majiayu000/claude-skill-registry -a claude-code
Plugin CommandAlternative
/plugin add https://github.com/majiayu000/claude-skill-registry
Git CloneAlternative
git clone https://github.com/majiayu000/claude-skill-registry.git ~/.claude/skills/advanced-patterns

Copy and paste this command in Claude Code to install this skill

GitHub Repository

majiayu000/claude-skill-registry
Path: skills/data/advanced-patterns
0
FAQ

Frequently asked questions

What is the advanced-patterns skill?

advanced-patterns is a Claude Skill by majiayu000. Skills package instructions and resources that Claude loads on demand, so Claude can perform advanced-patterns-related tasks without extra prompting.

How do I install advanced-patterns?

Use the install commands on this page: add advanced-patterns to Claude Code as a plugin, or clone its repository into your skills directory, then restart Claude so it picks up the skill.

What category does advanced-patterns belong to?

advanced-patterns is in the Meta category, tagged design.

Is advanced-patterns free to use?

Yes. advanced-patterns is listed on AIMCP and free to install. It runs inside Claude, so no separate service account is required to use the skill itself.

Related Skills

content-collections
Meta

This skill provides a production-tested setup for Content Collections, a TypeScript-first tool that transforms Markdown/MDX files into type-safe data collections with Zod validation. Use it when building blogs, documentation sites, or content-heavy Vite + React applications to ensure type safety and automatic content validation. It covers everything from Vite plugin configuration and MDX compilation to deployment optimization and schema validation.

View skill
polymarket
Meta

This skill enables developers to build applications with the Polymarket prediction markets platform, including API integration for trading and market data. It also provides real-time data streaming via WebSocket to monitor live trades and market activity. Use it for implementing trading strategies or creating tools that process live market updates.

View skill
creating-opencode-plugins
Meta

This skill helps developers create OpenCode plugins that hook into 25+ event types like commands, files, and LSP operations. It provides the plugin structure, event API specifications, and implementation patterns for JavaScript/TypeScript modules. Use it when you need to intercept, monitor, or extend the OpenCode AI assistant's lifecycle with custom event-driven logic.

View skill
sglang
Meta

SGLang is a high-performance LLM serving framework that specializes in fast, structured generation for JSON, regex, and agentic workflows using its RadixAttention prefix caching. It delivers significantly faster inference, especially for tasks with repeated prefixes, making it ideal for complex, structured outputs and multi-turn conversations. Choose SGLang over alternatives like vLLM when you need constrained decoding or are building applications with extensive prefix sharing.

View skill