Erd

Skill KhaiTrang1995/agentic-awesome-kits/kits/software/drawio-kit/.claude/skills/erd

Generate ERD .drawio — entities, attributes, 1-1/1-N/N-N relationships, PK/FK. Hand-authored XML with TechSphereX AI palette; complex SQL DDL → /diagram --from-sql.From its SKILL.md

Install

npx -y skills add KhaiTrang1995/agentic-awesome-kits --skill erd

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
8 stars8 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

2.3 KB, 594 tokens by cl100k_base, as published. Nobody here has run it

/erd — Entity-Relationship Diagram (draw.io)

When to use

Data model for design docs / BA–dev alignment
A few–dozens of entities described in words (no SQL importer needed)
Need a hand-editable .drawio file

Switch to /diagram when: large SQL DDL file (sqlerd.py), auto-layout for dozens of tables, or batch PNG export.

Input examples

/erd Order 1-N OrderLine, Order N-1 Customer, Order 1-1 Payment --feature booking
/erd auth module: User, Role, UserRole (N-N), Permission
/erd @schema.sql   → suggest /diagram --from-sql if >8 tables

Workflow

Phase 1 — Inventory

List:

Entity	PK	Attributes (short)	Notes

Relationships: A 1—N B, A N—N B (// associative entity if needed).

Missing relationship names / cardinality → ask 1–2 questions; do not invent FKs.

Phase 2 — L3 layout preview

Node + edge table (ASCII/table). User reviews before XML.

Phase 3 — Generate XML

Use @_templates/erd.drawio as the frame:

Entity = rounded rect (or swimlane-style header): bold entity name + attr list
Mark PK as PK; FK as FK (text only)
Edge: endArrow=ERoneToMany / ERmandOne / ERzeroToMany when appropriate; fallback endArrow=block + labels 1 / N on the edge
Palette: entity fill #dae8fc, associative #fff2cc, external ref #f5f5f5 (per conventions)
Grid 20; entity box ~200×(40 + 20×attr count)

Phase 4 — L1 → Write

docs/diagrams/{feature}/erd-{slug}.drawio

Mandatory rules

@.claude/rules/drawio-conventions.md (core shapes, escape XML)
@.claude/rules/naming-conventions.md
@.claude/rules/approval-gate.md
Do not invent columns/relationships; TBD + ask
≤ 15 entities per page — more: split by domain or use /diagram + sqlerd/autolayout

Output