Lookup And Relationship Design

Quality score: 70/100 · Category: General · Sub-category: design-creative

Designing Lookup vs Master-Detail vs Hierarchical vs External relationships: cascade delete, roll-up summaries, ownership, sharing implications, polymorphic lookups, relationship depth limits. NOT for record-type strategy (use data-model-design-patterns). NOT for junction object patterns (use many-to-many-relationships).

What this skill does

Lookup And Relationship Design is a production-ready Claude Code skill (quality score 70/100) in the design-creative sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/lookup-and-relationship-design/ and loads when your prompt matches the skill's trigger.

Who uses this skill

The Lookup And Relationship Design skill is built for Claude Code users and developers across all disciplines looking for general-purpose AI assistance. It is part of the open ClaudSkills registry, a community-curated catalog of 15,000+ capabilities you can install for Claude Code — the Claude CLI agent.

How to install

Free

Manual install (2 steps)

mkdir -p ~/.claude/skills/lookup-and-relationship-design
curl -L https://claudskills.com/skills/lookup-and-relationship-design/SKILL.md \
  -o ~/.claude/skills/lookup-and-relationship-design/SKILL.md

Or just download SKILL.md directly and drop it into ~/.claude/skills/lookup-and-relationship-design/. Claude Code auto-discovers it on next session.

Skills live at ~/.claude/skills/lookup-and-relationship-design/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\lookup-and-relationship-design\SKILL.md on Windows. See the full install guide for step-by-step instructions.

Pro

One-click install via the desktop app

The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.

More General skills

Browse all General skills in the ClaudSkills registry, or explore these top-rated picks from the same category:

Browse all General skills → Top 100 skills

Part of ClaudSkills — the open registry for Claude Code skills. · What's New · Install guide · About · llms.txt

Part of Acreator Store — Adam Lankamer's AI tools: GifPerfect · AspectPerfect · SlomoPerfect · Ucaption · UTagger · AutoXPoster · TestYourSkills