Creates entity model documents with Mermaid.js ER diagrams and attribute tables defining entities, relationships, data types, and validation rules.

Apache-2.0Auto-check passedDatabases

Install Entity Model

skills CLI
$ npx skills add AI-Unified-Process/marketplace --skill entity-model -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install AI-Unified-Process/marketplace entity-model --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/AI-Unified-Process/marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/aiup-core/skills/entity-model .claude/skills/entity-model && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
entity-model
GitHub stars
141
Token cost
~1.9k tokens
SKILL.md length
714 words
Files
2 (incl. references)
Skills in repo
14
Repo updated
First seen
Licence
Apache-2.0

At a glance

Creates entity model documents with Mermaid.js ER diagrams and attribute tables defining entities, relationships, data types, and validation rules.

  • Works in 3 steps: A ### heading with the entity name in… → One sentence description → An attribute table with exactly these 5…
  • The user asks to create an entity model
  • SKILL.md covers Instructions, DO NOT, Document Structure and Required Format for Each Entity, plus 5 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Entity Model is an agent skill from AI-Unified-Process/marketplace. Creates entity model documents with Mermaid.js ER diagrams and attribute tables defining entities, relationships, data types, and validation rules. Use when the user asks to "create an entity model", "design a data model", "draw an ERD", "define database schema", "model entities", or mentions entity-relationship diagram, ER diagram, database design, or data modeling. Also trigger whenever the task is to produce, write, or design an entity model or data model document (e.g. docs/entitymodel.md) from a requirements…

Its SKILL.md is about 1.9k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including reference files (for example `references/REFERENCE.md`).

It sits in Databases, covering Database schema design and Diagrams. It works with Mermaid. The licence is Apache-2.0.

When your agent uses it

  • The user asks to create an entity model
  • Design a data model
  • Define database schema
  • Mentions entity-relationship diagram

Example prompts

  • “create an entity model”
  • “design a data model”
  • “draw an ERD”
  • “/entity-model”

Workflow steps

3 steps, taken from the first numbered list in SKILL.md.

  1. A ### heading with the entity name in UPPERCASE (UPPER_SNAKE_CASE, e.g. ### ROOM_TYPE — never ### Room Type or ## Entity: Room Type)
  2. One sentence description
  3. An attribute table with exactly these 5 columns in this order: Attribute, Description, Data Type, Length/Precision, Validation Rules

What it can do on your machine

Read from SKILL.md and the folder at commit d25bf91. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are markdown).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • unifiedprocess.ai

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Entity Model loads about 1.9k tokens when it runs, and up to ~2.3k if it reads all its reference files. Until then it costs about 191 tokens; SKILL.md has 714 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~191
When it runs · the whole SKILL.md, loaded when a task matches
~1.9k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~2.3k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from AI-Unified-Process/marketplace at commit d25bf91, republished under its Apache-2.0 licence (© AI-Unified-Process). 714 words, ~1,893 tokens.

Download SKILL.mdSave it as .claude/skills/entity-model/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
entity-model
description
Creates entity model documents with Mermaid.js ER diagrams and attribute tables defining entities, relationships, data types, and validation rules. Use when the user asks to "create an entity model", "design a data model", "draw an ERD", "define database schema", "model entities", or mentions entity-relationship diagram, ER diagram, database design, or data modeling. Also trigger whenever the task is to produce, write, or design an entity model or data model document (e.g. docs/entity_model.md) from a requirements catalog — including phrasings like "data model design", "the team needs an entity model before development", or a request to document entities with attributes, data types, precision, and validation or cross-attribute constraints.
<!--
Copyright 2025-2026 Simon Martinelli and the AI Unified Process contributors.
Part of the AI Unified Process — https://unifiedprocess.ai
Licensed under the Apache License, Version 2.0. See LICENSE and NOTICE.
-->

Entity Model

Instructions

Create or update the entity model at docs/entity_model.md based on docs/requirements.md. The document contains an ER diagram and attribute tables.

DO NOT

  • Add attributes/columns to the Mermaid diagram
  • Write prose descriptions like "Key attributes: name, email..."
  • Create a "Relationships" table

Document Structure

markdown
# Entity Model

## Entity Relationship Diagram

```mermaid
erDiagram
    ROOM_TYPE ||--o{ ROOM : "categorizes"
    GUEST ||--o{ RESERVATION : "makes"
ENTITY_NAME

One sentence describing the entity.

AttributeDescriptionData TypeLength/PrecisionValidation Rules
id...Long19Primary Key, Sequence
...............

Required Format for Each Entity

Every entity MUST have:

  1. A ### heading with the entity name in UPPERCASE (UPPER_SNAKE_CASE, e.g. ### ROOM_TYPE — never ### Room Type or ## Entity: Room Type)
  2. One sentence description
  3. An attribute table with exactly these 5 columns in this order: Attribute, Description, Data Type, Length/Precision, Validation Rules
Example Entity
ROOM_TYPE

Defines categories of rooms with shared characteristics.

AttributeDescriptionData TypeLength/PrecisionValidation Rules
idUnique identifierLong19Primary Key, Sequence
nameName of the room typeString50Not Null, Unique
descriptionDetailed descriptionString500Optional
capacityMaximum number of guestsInteger10Not Null, Min: 1, Max: 10
pricePrice per night in CHFDecimal10,2Not Null, Min: 0

Mermaid Diagram Rules

  • Show entity names and relationships ONLY
  • NO attributes inside entity blocks
  • Use relationship syntax: ENTITY_A ||--o{ ENTITY_B : "relationship"

Data Types (use only these)

The Data Type column must use exactly these values — never SQL or ORM types such as VARCHAR, TEXT, CHAR, bigint, numeric, serial, smallint, UUID, Timestamp, or Enum:

Data TypeLength/PrecisionUsage
Long19IDs, foreign keys
Stringvaries (50-500)Text fields
Integer10Whole numbers
Decimal10,2Currency, percentages
Boolean1True/false flags
Date-Date only
DateTime-Date and time

The Length/Precision column holds the bare value (e.g. 10,2) — never a type expression like DECIMAL(10,2).

Validation Rules (use only these values)

Compose every Validation Rules cell from this vocabulary, using the exact wording — never a prose description, and never an empty cell, dash, or "N/A":

Attribute TypeValidation Rules Value
Primary keyPrimary Key, Sequence
Natural or composite keyPrimary Key
Composite key and foreign keyPrimary Key, Foreign Key (TABLE.id)
Required fieldNot Null
Unique fieldNot Null, Unique
Foreign keyNot Null, Foreign Key (TABLE.id)
Optional fieldOptional
With rangeNot Null, Min: X, Max: Y
With valuesNot Null, Values: A, B, C
EmailNot Null, Format: Email

Examples: an email attribute is Not Null, Format: Email — never "must be a valid email address". A status attribute with a fixed set of states is Not Null, Values: Pending, Active, Completed, Cancelled — never "must be one of Pending, Active, Completed, Cancelled".

This table is a closed set: every Validation Rules cell is exactly one row from it. Do not combine rows into new patterns (Not Null, Unique, Format: Email is invalid — pick the one rule that matters most, here Not Null, Format: Email), and never write Min: without its matching Max: (Not Null, Min: 0 alone is invalid — use Not Null, Min: 0, Max: <upper bound> or just Not Null).

The same tables are available in references/REFERENCE.md. The path is relative to the folder containing this SKILL.md, not to the project root.

Show full SKILL.md (202 more words)Show less

Multi-Column Constraints

If validation spans multiple columns, add a #### Constraints heading below the entity's attribute table and list each constraint as a bullet, one rule per bullet:

markdown
#### Constraints

- Check-out date must be after check-in date.
- The number of guests must not exceed the room type's capacity.

Never write the constraints as a bold **Constraints:** line or as an extra table row, and omit the heading when the entity has no multi-column constraint.

Workflow

  1. Read the requirements document
  2. Use TodoWrite to create a task for each entity
  3. Write the document header and ER diagram (relationships only)
  4. For each entity:
    • Write ### heading
    • Write one sentence description
    • Write attribute table with 5 columns
    • Add a #### Constraints heading with a bullet list if needed
    • Mark todo complete
  5. Validate the document:
    • Every entity in the ER diagram has a corresponding attribute table section
    • Every attribute table has exactly 5 columns
    • No attributes appear inside the Mermaid diagram entity blocks
    • All foreign keys reference existing entities
    • Every foreign key has a relationship line in the ER diagram
    • Every entity heading is ### with the name in UPPERCASE
    • Multi-column constraints are a #### Constraints bullet list below the table
    • All Data Type values come from the Data Types table above (no SQL types anywhere)
    • All validation rules use values from the Validation Rules table above

© AI-Unified-Process, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file (references) in aiup-core/skills/entity-model of AI-Unified-Process/marketplace.

  • SKILL.md
  • references/REFERENCE.md

Open the folder on GitHubat commit d25bf91

Compare with similar skills

Entity Model next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Entity Model compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Entity Model this skillAI-Unified-Process/marketplace141—~1.9kAutomated safety check: PassApache-2.0
Drizzle Erdhiroppy/mf-dashboard418—~627Automated safety check: PassMIT
Data Model CreationTencentCloudBase/CloudBase-AI-Toolkit1.1k1 repos~1.8kAutomated safety check: PassMIT
Managedcode Orleans Graphmanagedcode/dotnet-skills486—~1.6kAutomated safety check: PassMIT
Data Model ExtractorEmeaAppGbb/spec2cloud100—~2.5kAutomated safety check: PassMIT
Datamodellmnimbalyst/nimbalyst1.9k—~713Automated safety check: PassMIT

Similar skills

  • Drizzle Erd

    hiroppy/mf-dashboard

    A skill your agent uses when needing to visualize database schema, generate ERD diagrams from Drizzle ORM schemas, or understand table relationships

    418 GitHub stars~627 tokensUpdated today
    DatabasesAuto-check passed
  • Data Model Creation

    TencentCloudBase/CloudBase-AI-Toolkit

    [Deprecated] Optional advanced tool for complex data modeling.

    1.1k GitHub starsUsed in 1 repo~1.8k tokens
    DatabasesAuto-check passed
  • Managedcode Orleans Graph

    managedcode/dotnet-skills

    Integrate ManagedCode.Orleans.Graph into an Orleans-based .NET application for grain-call policy enforcement, deadlock detection, live-call telemetry, and Mermaid graph diagnostics.

    486 GitHub stars~1.6k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Data Model Extractor

    EmeaAppGbb/spec2cloud

    Extract database schemas, data models, and entity relationships from code.

    100 GitHub stars~2.5k tokensUpdated 5 mo ago
    DatabasesAuto-check passed
  • Datamodellm

    nimbalyst/nimbalyst

    Create visual data models for database schemas using Nimbalyst's DataModelLM editor.

    1.9k GitHub stars~713 tokensUpdated today
    DatabasesAuto-check passed
  • Walkthrough

    alexanderop/walkthrough

    Generates a self-contained HTML file with an interactive, clickable Mermaid diagram (flowchart or ER diagram) that explains how a codebase feature, flow, architecture, or database schema works.

    141 GitHub stars~3.4k tokensUpdated 6 mo ago
    DevelopmentAuto-check: notes

More from AI-Unified-Process/marketplace

All 14 skills in this repo
  • Spec Review

    AI-Unified-Process/marketplace

    Reviews the specification artifacts in docs/ (requirements, use case diagram, use case specifications, test cases, BPMN process models, entity model, glossary) against each other in two parts: a…

    141 GitHub stars~2.9k tokensUpdated 3 days ago
    Auto-check passed
  • Use Case Spec

    AI-Unified-Process/marketplace

    Creates detailed use case specification documents with actors, preconditions, main success scenarios, alternative flows, postconditions, and business rules.

    141 GitHub stars~4.8k tokensUpdated 3 days ago
    Auto-check passed
  • Business Process

    AI-Unified-Process/marketplace

    Creates or updates BPMN 2.0 business process models (docs/processes/BP-XXX-.bpmn) from the requirements catalog and the use case diagram: one pool per process, one lane per actor, every activity one…

    141 GitHub stars~3.8k tokensUpdated 3 days ago
    Auto-check: warnings
  • Test Case

    AI-Unified-Process/marketplace

    Creates end-to-end test case documents (TC-.md) that chain several use cases into one user journey with a step-by-step Flow table, concrete test data, and final validations.

    141 GitHub stars~3.8k tokensUpdated 3 days ago
    Auto-check: warnings
  • Browserless Test

    AI-Unified-Process/marketplace

    Creates Vaadin Browserless server-side unit tests for Vaadin views covering navigation, component interactions, form validation, grid operations, and notifications.

    141 GitHub stars~4.8k tokensUpdated 3 days ago
    Auto-check: warnings
  • Hilla Test

    AI-Unified-Process/marketplace

    Creates tests for Hilla use cases on both sides of the browser boundary: Vitest + React Testing Library tests for the React/TypeScript view (with the generated endpoint clients mocked) and Spring…

    141 GitHub stars~3.9k tokensUpdated 3 days ago
    Auto-check: warnings

Works with

Categories

Questions about Entity Model

What does Entity Model do?

Creates entity model documents with Mermaid.js ER diagrams and attribute tables defining entities, relationships, data types, and validation rules. Entity Model is an agent skill from AI-Unified-Process/marketplace.js ER diagrams and attribute tables defining entities, relationships, data types, and validation rules.

When should I use Entity Model?

Entity Model fits situations like: the user asks to create an entity model; design a data model; define database schema; mentions entity-relationship diagram.

How do I install Entity Model in Claude Code?

Run `npx skills add AI-Unified-Process/marketplace --skill entity-model -a claude-code`. Or copy the skill folder (aiup-core/skills/entity-model in AI-Unified-Process/marketplace) into .claude/skills/entity-model in your project. Claude Code loads it when a task matches its description.

How do I install Entity Model in Codex?

Run `npx skills add AI-Unified-Process/marketplace --skill entity-model -a codex`. Or copy the skill folder (aiup-core/skills/entity-model in AI-Unified-Process/marketplace) into .agents/skills/entity-model in your project. Codex loads it when a task matches its description.

Can I use Entity Model in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add AI-Unified-Process/marketplace --skill entity-model -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/entity-model, .gemini/skills/entity-model, .github/skills/entity-model and .opencode/skills/entity-model in your project.

What does Entity Model need to run?

SKILL.md names no scripts, command-line tools or credentials: Entity Model is instructions for the agent only.

Does Entity Model access the network?

SKILL.md names 1 domain. As links in the text: unifiedprocess.ai. This is read from the text; nothing was executed.

Is Entity Model safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Entity Model use?

Entity Model is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Entity Model use?

About 1.9k tokens (SKILL.md is roughly 7.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 434 tokens, read only when the agent opens those files.

What are the alternatives to Entity Model?

Skills that share tags, products or a category with Entity Model: Drizzle Erd (hiroppy/mf-dashboard, 418 stars), Data Model Creation (TencentCloudBase/CloudBase-AI-Toolkit, 1.1k stars), Managedcode Orleans Graph (managedcode/dotnet-skills, 486 stars) and Data Model Extractor (EmeaAppGbb/spec2cloud, 100 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Entity Model?

AI-Unified-Process (a GitHub organization) maintains it in AI-Unified-Process/marketplace, which has 141 GitHub stars. The repository holds 14 skills in this directory. The repository was last updated on October 5, 2026.

Source: AI-Unified-Process/marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.