Advanced Patterns
About
This skill implements advanced database patterns including SCD Type 2 for historical tracking, Closure Table for hierarchical data, and Shared Family Budget functionality. Use it when you need to add versioning to dimension tables, manage complex hierarchies, or implement shared budget endpoints. It provides ready-to-use implementations with architectural references for database history and hierarchy management.
Quick Install
Claude Code
Recommendednpx skills add mattnigh/skills_collection -a claude-code/plugin add https://github.com/mattnigh/skills_collectiongit clone https://github.com/mattnigh/skills_collection.git ~/.claude/skills/Advanced PatternsCopy and paste this command in Claude Code to install this skill
GitHub Repository
Frequently asked questions
What is the Advanced Patterns skill?
Advanced Patterns is a Claude Skill by mattnigh. 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 Other category, tagged scd-type-2, closure-table, shared-budget, hierarchy and versioning.
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
LlamaGuard is Meta's 7-8B parameter model for moderating LLM inputs and outputs across six safety categories like violence and hate speech. It offers 94-95% accuracy and can be deployed using vLLM, Hugging Face, or Amazon SageMaker. Use this skill to easily integrate content filtering and safety guardrails into your AI applications.
This Claude Skill helps developers optimize cloud costs through resource rightsizing, tagging strategies, and spending analysis. It provides a framework for reducing cloud expenses and implementing cost governance across AWS, Azure, and GCP. Use it when you need to analyze infrastructure costs, right-size resources, or meet budget constraints.
This Claude Skill analyzes sports betting markets including spreads, over/unders, and prop bets by examining historical trends and situational statistics to identify value bets. It provides structured markdown output with actionable recommendations for educational purposes. Developers should use this for sports betting analysis tools while noting it's designed for entertainment/education only.
This skill quantizes LLMs to 8-bit or 4-bit precision using bitsandbytes, achieving 50-75% memory reduction with minimal accuracy loss. It's ideal for running larger models on limited GPU memory or accelerating inference, supporting formats like INT8, NF4, and FP4. The skill integrates with HuggingFace Transformers and enables QLoRA training and 8-bit optimizers.
