Data Model Design
Design data models for business domains using entity-relationship or domain-driven design. Use when modeling new domains or refactoring data structures.
Install
/plugin marketplace add sethdford/claude-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add sethdford/claude-skills --skill data-model-designgit clone --depth 1 https://github.com/sethdford/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/architect/data-architecture/skills/data-model-design ~/.claude/skills/data-model-designPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Data Model Design Design data models that correctly represent business domains and support required queries efficiently. ## Context You are modeling a business domain in a database. The data model must reflect business semantics and perform well. ## Domain Context Based on relational theory and domain-driven design: - **Entities**: Things with identity (User, Order) - **Attributes**: Properties of entities (name, email) - **Relationships**: How entities connect (User has many Orders) - **Normalization**: Reduce redundancy; improves write performance - **Denormalization**: Intentionally duplicate data; improves read performance ## Instructions 1. **Identify Entities**: What are the main concepts? List with primary key. 2. **Identify Attributes**: For each entity, list properties. 3. **Define Relationships**: One-to-one, one-to-many, many-to-many. 4. **Normalize**: Remove update anomalies through normal forms. 5. **Denormalize Strategically**: Add calculated columns or tables for read performance. ## Anti-Patterns - **Premature Normalization**: Third-normal-form everywhere. Result: slow queries. **Guard**: Design for reads; denormalize if needed. - **Flat Tables**: No normalization; entity data scattered. Result: update anomalies. **Guard**: At least second-normal-form. ## Further Reading - _Relational Database Design_ — normalization fundamentals - _Domain-Driven Design_ — modeling business domains
Details
- Skill name
data-model-design- Repository
- sethdford/claude-skills
- Path
architect/data-architecture/skills/data-model-design/SKILL.md- License
- MIT
- Repo updated
- 11 March 2026
FAQ
What does the Data Model Design skill do?
Design data models for business domains using entity-relationship or domain-driven design. Use when modeling new domains or refactoring data structures.
How do I install the Data Model Design skill?
Claude Code plugin: /plugin marketplace add sethdford/claude-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Data Model Design popular?
It lives in sethdford/claude-skills, which has 48 GitHub stars and 10 forks.
Related skills
A B Test Design
48sethdford/claude-skills
Design rigorous A/B tests with hypotheses, variants, metrics, and sample size calculations.
A B Test Design Pm
48sethdford/claude-skills
Analytics and experimentation skill for product managers.
Abuse Case Design
48sethdford/claude-skills
Design abuse cases (negative use cases) showing how attackers misuse system features. Use when identifying attacks that exploit intended functionality or business logic flaws.
Page Object Model
48sethdford/claude-skills
Expert approach to page-object-model in test automation. Use when working with .
Concurrency Patterns
48sethdford/claude-skills
Actor model, CSP (Communicating Sequential Processes), lock-free patterns, async/await.
Performance Modeling
48sethdford/claude-skills
Model system performance, predict latency under load, identify bottlenecks. Use when optimizing performance or capacity planning.
Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.