# data-schema-knowledge-modeling

The data-schema-knowledge-modeling skill builds rigorous models of entities, relationships, and constraints for databases, knowledge graphs, and ontologies. Use it to formalize your data structure before development.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 159 installs · ★ 203 repo stars
- Author: lyndonkl
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/lyndonkl/claude/tree/HEAD/skills/data-schema-knowledge-modeling/SKILL.md
- Updated: 2026-09-01
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/data-schema-knowledge-modeling

## What it does

The skill walks through systematic data modeling: identifying entities and attributes, defining relationships (one-to-many, many-to-many), specifying constraints and invariants. It handles relational (SQL), document (NoSQL), graph, time-series, and data warehouse paradigms. Built-in patterns cover entity lifecycle management, soft deletes, polymorphic associations, hierarchies, multi-tenancy, and temporal modeling.

Each step guides you from requirements gathering through entity extraction, relationship definition, constraint specification, and model validation. The workflow links to methodology guides and an evaluation rubric for self-assessment. Output is a `data-schema-knowledge-modeling.md` file with complete specifications that prevent data inconsistencies and simplify implementation.

Installs via `npx skills add` or `gh skill install` depending on your platform. Once installed, access it through SKILL.md in the skill directory.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/data-schema-knowledge-modeling/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/data-schema-knowledge-modeling/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/data-schema-knowledge-modeling/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/data-schema-knowledge-modeling/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install lyndonkl/claude skills/data-schema-knowledge-modeling
```

2. **Manually: put the files in place**
- File: `.github/skills/data-schema-knowledge-modeling/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/lyndonkl/claude --path skills/data-schema-knowledge-modeling
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/data-schema-knowledge-modeling/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/lyndonkl/claude/tree/HEAD/skills/data-schema-knowledge-modeling/SKILL.md

## When to use it
- design a relational schema with normalization rules
- model a document database with embed vs reference strategy
- build a knowledge graph for recommendations or search
- specify an analytics warehouse with fact and dimension tables
- define constraints and invariants for data consistency

## Example prompts
- Design a schema for an e-commerce platform: users, products, orders, payments
- Model a social network knowledge graph: nodes for people and interests, edges for follows and likes
- Define a polymorphic relationship where comments can attach to posts or photos

## Similar
- [design-database-schema](https://affpapa.org/en/nevibecode/commands/design-database-schema.md) — command · 1021 installs
- [database-schema-designer](https://affpapa.org/en/nevibecode/plugins/database-schema-designer.md) — plugin · ★ 2707 repo stars
- [zenstack-schema-modeling](https://affpapa.org/en/nevibecode/skills/zenstack-schema-modeling.md) — skill · 470 installs
- [database-architect](https://affpapa.org/en/nevibecode/skills/database-architect.md) — skill · 586 installs
- [schema-consistency-checker](https://affpapa.org/en/nevibecode/skills/schema-consistency-checker.md) — skill · 265 installs
- [schema-designer](https://affpapa.org/en/nevibecode/plugins/schema-designer.md) — plugin · ★ 2858 repo stars

From the same set: [lyndonkl/claude](https://affpapa.org/en/nevibecode/by/lyndonkl/claude.md) — 49 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
