data-schema-knowledge-modeling — Claude Code skill
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.
no license 159 installs ★ 203 updated 2026-09-01
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a claude-codeWhat data-schema-knowledge-modeling 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.
What it helps with
- 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 for the agent
- 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
How to install data-schema-knowledge-modeling
1Skills CLI (Vercel)
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a claude-code2Manually: put the files in place
~/.claude/skills/data-schema-knowledge-modeling/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/data-schema-knowledge-modeling/
1Skills CLI (Vercel)
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a codex2Manually: put the files in place
.agents/skills/data-schema-knowledge-modeling/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a cursor2Manually: put the files in place
.cursor/skills/data-schema-knowledge-modeling/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install lyndonkl/claude skills/data-schema-knowledge-modeling2Manually: put the files in place
.github/skills/data-schema-knowledge-modeling/SKILL.md1Skills CLI (Vercel)
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a gemini-cli2Platform CLI
gemini skills install https://github.com/lyndonkl/claude --path skills/data-schema-knowledge-modelingManually: put the files in place
.devin/skills/data-schema-knowledge-modeling/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about data-schema-knowledge-modeling
How do I install data-schema-knowledge-modeling in Claude Code?
Run npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a claude-code, then open ~/.claude/skills/data-schema-knowledge-modeling/SKILL.md.
What does data-schema-knowledge-modeling do?
It helps create rigorous models of entities, attributes, relationships, and constraints for SQL, NoSQL, graphs, time-series, and data warehouses. Includes patterns for soft deletes, hierarchies, polymorphism, and multi-tenancy.
Which database types does this skill support?
Relational (SQL), document (NoSQL), knowledge graphs, time-series, and dimensional (analytics) schemas. For each type it provides guidance on normalization, denormalization tradeoffs, and cardinality decisions.