Data Modeling
Use when the user asks about relational or graph data modeling: 3NF normalization, surrogate keys, temporal tables, table inheritance, property graph vs RDF or knowledge graph schemas. Produces a schema-first model with keys, constraints and denormalization rules. Not for Kimball star schemas (use data-dimensional-modeling) or graph DB operations (use data-graph-database).
Install
npx skills add j4flmao/agent-skills --skill data-modelinggit clone --depth 1 https://github.com/j4flmao/agent-skills.git /tmp/agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/agent-skills/skills/data/data-modeling ~/.claude/skills/data-modelingPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Data Modeling
## Purpose
Design robust, maintainable data models for relational and graph data stores with clear schema design principles, normalization strategies, and traversal patterns.
## Agent Protocol
### Trigger
Exact user phrases: "data model", "schema design", "normalization", "denormalization", "3NF", "table inheritance", "soft delete", "surrogate key", "graph model", "property graph", "RDF", "knowledge graph", "node edge model", "graph traversal".
### Input Context
- Data store type (relational, graph, or hybrid)
- Access patterns (OLTP, OLAP, graph queries)
- Volume and growth expectations
- Consistency and integrity requirements
- Existing schema constraints and migration path
- Team expertise with relational vs graph technologies
### Output Artifact
DDL statements, graph schema definitions, migration scripts. No file unless requested.
### Response Format
```
## Entity: {name}
| Field | Type | Constraints | Notes |
|-------|------|-------------|-------|
| {field} | {type} | {constraints} | {notes} |
```
```
## Graph: {name}
Nodes: {node types with properties}
Edges: {edge types with properties}
Indexes: {indexed properties}
Traversal: {common query patterns}
```
No preamble. No postamble. No explanations. No filler/hedging/transitions.
### Completion Criteria
- [ ] Entities normalized to appropriate normal form
- [ ] Table inheritance pattern selected (if applicable)
- [ ] Temporal tracking strategy defined (if needed)Details
- Skill name
data-modeling- Repository
- j4flmao/agent-skills
- Path
skills/data/data-modeling/SKILL.md- License
- MIT
- Repo updated
- 17 November 2026
FAQ
What does the Data Modeling skill do?
Use when the user asks about relational or graph data modeling: 3NF normalization, surrogate keys, temporal tables, table inheritance, property graph vs RDF or knowledge graph schemas. Produces a schema-first model with keys, constraints and denormalization rules. Not for Kimball star schemas (use data-dimensional-modeling) or graph DB operations (use data-graph-database).
How do I install the Data Modeling skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add j4flmao/agent-skills --skill data-modeling. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Data Modeling popular?
It lives in j4flmao/agent-skills, which has 45 GitHub stars and 6 forks.
Related skills
Agent Observability
45j4flmao/agent-skills
Use when the user asks about agent observability, tracing agent reasoning, debugging an agent loop, OpenTelemetry GenAI spans for LLM calls, LLM cost tracking per agent, agent audit logs or hallucination/eval monitoring in production. Produces instrumentation config, trace schema, dashboards, alerts and cost attribution. Not for generic service tracing without LLMs (use devops-opentelemetry).
AI Agent Architectures
45j4flmao/agent-skills
Use when the user asks to build an AI agent, design an agent that calls tools and keeps memory, write an agent system prompt or pick an agent framework (Claude Agent SDK, OpenAI Agents SDK, LangGraph). Produces an architecture brief covering loop, tools, memory, guardrails and evals, routing depth to child skills. Not for workflow patterns (use ai-agentic-workflows).
AI Agent Core Loop
45j4flmao/agent-skills
Use when the user asks about the agent loop, ReAct vs plan-and-solve, re-planning, Reflexion, an agent stuck in a loop, max iterations or termination conditions. Produces a loop spec or patch with state, success predicate, caps and no-progress detection. Not for overall agent design (use ai-agent-architectures) or tool schemas (use tool-calling-principles).
Data Vector Databases
45j4flmao/agent-skills
Use when the user asks to pick an index type for vector similarity search, pgvector, Qdrant, Milvus, Pinecone, Weaviate, HNSW vs IVF vs PQ, metadata filtering or storing embeddings. Produces vector store choice, collection schema and ANN index settings for recall, latency and memory. Not for full RAG pipeline design (use llm-rag-retrieval-internals).
Data Dimensional Modeling
45j4flmao/agent-skills
Use when the user asks to design a star schema for sales analytics, Kimball fact and dimension tables, grain, conformed dimensions, slowly changing dimensions (SCD Type 2), bus matrix or Data Vault 2.0. Produces a dimensional model with grain, keys, SCD choices and measures. Not for warehouse platform tuning (use data-data-warehouse).
Edge AI
45j4flmao/agent-skills
Use when the user asks about edge AI, on-device inference, TensorRT on Jetson, ONNX Runtime, LiteRT (TFLite), TinyML, int8 quantization, Coral, NPUs or ExecuTorch. Produces export, quantization and on-device benchmarking plans. Not for model training (use ml-deep-learning) or cloud LLM serving (use ml-inference-optimization).
Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.