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).

45 stars 6 forksAI, LLMs & Agents

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add j4flmao/agent-skills --skill data-modeling
Manual install
git 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-modeling

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

Details

Skill name
data-modeling
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

45

j4flmao/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).

DevOps & Cloud

AI Agent Architectures

45

j4flmao/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, LLMs & Agents

AI Agent Core Loop

45

j4flmao/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).

AI, LLMs & Agents

Data Vector Databases

45

j4flmao/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).

AI, LLMs & Agents

Data Dimensional Modeling

45

j4flmao/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).

AI, LLMs & Agents

Edge AI

45

j4flmao/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).

AI, LLMs & Agents

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