Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add lyndonkl/claude --skill data-schema-knowledge-modeling -a claude-code
Open on GitHub

What 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-code

2Manually: put the files in place

~/.claude/skills/data-schema-knowledge-modeling/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/data-schema-knowledge-modeling/

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.

Similar skills

All skills for Data and databases →

From the same set49

The whole set →
market-mechanics-betting market-mechanics-betting is a Claude Code skill that converts probabilities into trading decisions by calculating market edge, sizing bets with Kelly, extremizing forecasts, and improving Brier Score calibration. CX Codex +1 179installs decision-matrix decision-matrix compares alternatives against weighted criteria, calculates scores, checks sensitivity to weight changes, and delivers a recommendation with trade-off analysis. CX Codex +1 165installs bayesian-reasoning-calibration The bayesian-reasoning-calibration skill applies Bayes' theorem to systematically revise probability estimates as new evidence arrives. It helps you forecast more accurately, avoid overconfidence, and justify why your beliefs change. CX Codex +1 162installs chain-roleplay-debate-synthesis chain-roleplay-debate-synthesis — a skill for Claude Code, Cursor, Codex and other IDEs runs structured debate between roles with competing priorities and synthesizes a unified decision. CX Codex +1 161installs brainstorm-diverge-converge The brainstorm-diverge-converge skill takes an open-ended question through idea generation, clustering, and evaluation. Use it to explore product directions, research questions, or possible experiments. CX Codex +1 153installs visualization-choice-reporting visualization-choice-reporting — a skill for Claude Code, Codex, Cursor and other platforms that matches chart types to data questions and produces reports with headlines, context and recommended actions. CX Codex +1 148installs expected-value The expected-value skill weighs possible gains and losses by their probabilities to compare uncertain choices. Use it to assess a product bet, rank projects, or map a decision tree. CX Codex +1 142installs deliberation-debate-red-teaming deliberation-debate-red-teaming is a Claude Code skill that tests plans and designs through adversarial viewpoints, uncovering assumptions, operational hazards, and security gaps before launch. CX Codex +1 139installs

Project sponsors

Companies that keep this analytics open