ci
Generate a CI/CD pipeline — build, test, security scan, deploy. Supports GitHub Actions, GitLab CI, Bitbucket Pipelines.
@khaitrang1995Install SkillDevelopment
Skill
/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.
Claude Code
$ npx -y skills add KhaiTrang1995/agentic-awesome-kits --skill erd --agent claude-code
Codex
$ npx skills add KhaiTrang1995/agentic-awesome-kits --skill erd -a codex -y
Cursor
$ npx skills add KhaiTrang1995/agentic-awesome-kits --skill erd -a cursor -y
Gemini CLI
$ npx skills add KhaiTrang1995/agentic-awesome-kits --skill erd -a gemini-cli -y
GitHub Copilot
$ npx skills add KhaiTrang1995/agentic-awesome-kits --skill erd -a github-copilot -y
OpenCode
$ npx skills add KhaiTrang1995/agentic-awesome-kits --skill erd -a opencode -y
Windsurf
$ npx skills add KhaiTrang1995/agentic-awesome-kits --skill erd -a windsurf -y
SKILL.md
erd.SKILL.mdname: erd
description: 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.
user-invocable: true
argument-hint: "<entity/relationship description> [--feature slug] [@schema.sql]"
/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
`docs/diagrams/{feature}/erd-{slug}.drawio`
References
- @_templates/erd.drawio
- @.claude/rules/drawio-conventions.md
- Advanced: skill `/diagram` + `scripts/sqlerd.py`
Read more
name: erd description: 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. user-invocable: true argument-hint: "<entity/relationship description> [--feature slug] [@schema.sql]"
/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
`docs/diagrams/{feature}/erd-{slug}.drawio`
References
- @_templates/erd.drawio
- @.claude/rules/drawio-conventions.md
- Advanced: skill `/diagram` + `scripts/sqlerd.py`
Stats
10
Stars
5
Forks
Maintained
Maintenance
Python
Language
Last commit
Created
Ships withagentic-awesome-kits
Reusable AI Skill Kits for coding agents (Claude Code and any other subagent/slash-command-compatible tool).
1032 skills
Stars on GitHub
Momentum
- stars in total
- 10
Other skills on agentic-awesome-kits.
@khaitrang1995Install Skillcompose
Generate docker-compose.yml — multi-service, network, volumes, healthcheck.
@khaitrang1995Install Skilldockerfile
Generate an optimized Dockerfile — multi-stage build, security hardening, small image size.
@khaitrang1995Install Skillsecret
Generate Swarm secret/config management — external secret references, versioned rotation, config mounts.
@khaitrang1995Install Skillservice
Generate or update a single Swarm service definition — scaling, resource limits, rolling update policy, health check.
@khaitrang1995Install Skillstack
Generate a Docker Swarm stack file — services, deploy policy (replicas, placement, rolling update/rollback), overlay network.
@khaitrang1995Install SkillMore skills from other plugins.
Auto-invoked
brainstorming
You MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or…
@obraInstall Skillask-matt
Ask which skill or flow fits your situation. A router over the skills in this repo.
@mattpocockInstall SkillAuto-invoked
Questions about erd.
- Which coding agents can use erd?
- erd installs in Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, OpenCode and Windsurf with the skills CLI, using each agent's flag shown on this page. Flowy's auto-invocation, which fires a skill when your prompt matches, runs in Claude Code only.