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.

48 stars 10 forksAI, LLMs & Agents Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add sethdford/claude-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add sethdford/claude-skills --skill data-model-design
Manual install
git 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-design

Personal 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
Read the full skill on GitHub

Details

Skill name
data-model-design
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

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.