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
Creates entity model documents with Mermaid.js ER diagrams and attribute tables defining entities, relationships, data types, and validation rules.
$ npx skills add AI-Unified-Process/marketplace --skill entity-model -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install AI-Unified-Process/marketplace entity-model --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ 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-srcUse ~/.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/
Install the "entity-model" agent skill from https://github.com/AI-Unified-Process/marketplace/tree/main/aiup-core/skills/entity-model into .claude/skills/entity-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "entity-model", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/AI-Unified-Process/marketplace/tree/main/aiup-core/skills/entity-modelType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add AI-Unified-Process/marketplace --skill entity-model -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install AI-Unified-Process/marketplace entity-model --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/AI-Unified-Process/marketplace.git skills-src && mkdir -p .agents/skills && cp -r skills-src/aiup-core/skills/entity-model .agents/skills/entity-model && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "entity-model" agent skill from https://github.com/AI-Unified-Process/marketplace/tree/main/aiup-core/skills/entity-model into .agents/skills/entity-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "entity-model", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add AI-Unified-Process/marketplace --skill entity-model -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install AI-Unified-Process/marketplace entity-model --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/AI-Unified-Process/marketplace.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/aiup-core/skills/entity-model .cursor/skills/entity-model && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "entity-model" agent skill from https://github.com/AI-Unified-Process/marketplace/tree/main/aiup-core/skills/entity-model into .cursor/skills/entity-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "entity-model", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/AI-Unified-Process/marketplace.git --path aiup-core/skills/entity-model--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add AI-Unified-Process/marketplace --skill entity-model -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install AI-Unified-Process/marketplace entity-model --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/AI-Unified-Process/marketplace.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/aiup-core/skills/entity-model .gemini/skills/entity-model && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "entity-model" agent skill from https://github.com/AI-Unified-Process/marketplace/tree/main/aiup-core/skills/entity-model into .gemini/skills/entity-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "entity-model", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install AI-Unified-Process/marketplace entity-modelInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add AI-Unified-Process/marketplace --skill entity-model -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/AI-Unified-Process/marketplace.git skills-src && mkdir -p .github/skills && cp -r skills-src/aiup-core/skills/entity-model .github/skills/entity-model && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "entity-model" agent skill from https://github.com/AI-Unified-Process/marketplace/tree/main/aiup-core/skills/entity-model into .github/skills/entity-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "entity-model", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add AI-Unified-Process/marketplace --skill entity-model -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install AI-Unified-Process/marketplace entity-model --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/AI-Unified-Process/marketplace.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/aiup-core/skills/entity-model .opencode/skills/entity-model && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "entity-model" agent skill from https://github.com/AI-Unified-Process/marketplace/tree/main/aiup-core/skills/entity-model into .opencode/skills/entity-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "entity-model", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
entity-modelCreates 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. 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.
3 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit d25bf91. It shows what the files ask for, not the result of running them.
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.
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.
Links to these hosts (documentation or services it may open):
unifiedprocess.aiFrom URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
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.
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.
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.
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.
.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.<!--
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.
-->
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.
# Entity Model
## Entity Relationship Diagram
```mermaid
erDiagram
ROOM_TYPE ||--o{ ROOM : "categorizes"
GUEST ||--o{ RESERVATION : "makes"One sentence describing the entity.
| Attribute | Description | Data Type | Length/Precision | Validation Rules |
|---|---|---|---|---|
| id | ... | Long | 19 | Primary Key, Sequence |
| ... | ... | ... | ... | ... |
Every entity MUST have:
### ROOM_TYPE — never ### Room Type or ## Entity: Room Type)Defines categories of rooms with shared characteristics.
| Attribute | Description | Data Type | Length/Precision | Validation Rules |
|---|---|---|---|---|
| id | Unique identifier | Long | 19 | Primary Key, Sequence |
| name | Name of the room type | String | 50 | Not Null, Unique |
| description | Detailed description | String | 500 | Optional |
| capacity | Maximum number of guests | Integer | 10 | Not Null, Min: 1, Max: 10 |
| price | Price per night in CHF | Decimal | 10,2 | Not Null, Min: 0 |
ENTITY_A ||--o{ ENTITY_B : "relationship"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 Type | Length/Precision | Usage |
|---|---|---|
| Long | 19 | IDs, foreign keys |
| String | varies (50-500) | Text fields |
| Integer | 10 | Whole numbers |
| Decimal | 10,2 | Currency, percentages |
| Boolean | 1 | True/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).
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 Type | Validation Rules Value |
|---|---|
| Primary key | Primary Key, Sequence |
| Natural or composite key | Primary Key |
| Composite key and foreign key | Primary Key, Foreign Key (TABLE.id) |
| Required field | Not Null |
| Unique field | Not Null, Unique |
| Foreign key | Not Null, Foreign Key (TABLE.id) |
| Optional field | Optional |
| With range | Not Null, Min: X, Max: Y |
| With values | Not Null, Values: A, B, C |
| Not 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.
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:
#### 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.
#### Constraints heading with a bullet list if needed### with the name in UPPERCASE#### Constraints bullet list below the table© 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
SKILL.md and 1 other file (references) in aiup-core/skills/entity-model of AI-Unified-Process/marketplace.
Open the folder on GitHubat commit d25bf91
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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Entity Model this skillAI-Unified-Process/marketplace | 141 | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | |
| Drizzle Erdhiroppy/mf-dashboard | 418 | — | ~627 | Automated safety check: Pass | MIT | |
| Data Model CreationTencentCloudBase/CloudBase-AI-Toolkit | 1.1k | 1 repos | ~1.8k | Automated safety check: Pass | MIT | |
| Managedcode Orleans Graphmanagedcode/dotnet-skills | 486 | — | ~1.6k | Automated safety check: Pass | MIT | |
| Data Model ExtractorEmeaAppGbb/spec2cloud | 100 | — | ~2.5k | Automated safety check: Pass | MIT | |
| Datamodellmnimbalyst/nimbalyst | 1.9k | — | ~713 | Automated safety check: Pass | MIT |
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
TencentCloudBase/CloudBase-AI-Toolkit
[Deprecated] Optional advanced tool for complex data modeling.
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.
EmeaAppGbb/spec2cloud
Extract database schemas, data models, and entity relationships from code.
nimbalyst/nimbalyst
Create visual data models for database schemas using Nimbalyst's DataModelLM editor.
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.
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…
AI-Unified-Process/marketplace
Creates detailed use case specification documents with actors, preconditions, main success scenarios, alternative flows, postconditions, and business rules.
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…
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.
AI-Unified-Process/marketplace
Creates Vaadin Browserless server-side unit tests for Vaadin views covering navigation, component interactions, form validation, grid operations, and notifications.
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…
Works with
Categories
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.
Entity Model fits situations like: the user asks to create an entity model; design a data model; define database schema; mentions entity-relationship diagram.
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.
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.
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.
SKILL.md names no scripts, command-line tools or credentials: Entity Model is instructions for the agent only.
SKILL.md names 1 domain. As links in the text: unifiedprocess.ai. This is read from the text; nothing was executed.
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.
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.
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.
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.
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.