erd-diagram

Extract ORM models and DDL to generate IE-notation ER diagrams in draw.io.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/so-ota-biz/ai-agent-orchestration-settings --skill erd-diagram
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: erd-diagram
Source: https://github.com/so-ota-biz/ai-agent-orchestration-settings/tree/main/.agent/skills/erd_diagram
Command: npx skills add https://github.com/so-ota-biz/ai-agent-orchestration-settings --skill erd-diagram

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill reads ORM models, migrations, and raw DDL from backend repositories to automatically generate ER diagrams in Draw.io using IE notation, providing both a comprehensive overview and domain-split views for readability.

Core Features & Use Cases

  • Automatically detects sources (Django, SQLAlchemy, Rails, Prisma, TypeORM, GORM, Sequelize, Mongoose for reference) and extracts tables, primary keys, foreign keys, unique constraints, and indexes.
  • Always outputs a single comprehensive overview diagram; for schemas with many tables, also generates domain-specific diagrams (targeting ~30 tables per diagram) to maintain readability.
  • Produces diagrams in mxGraph XML for direct opening in Draw.io, with a legend and clear notation for 1:1, 1:N, and many-to-many relationships; supports self-references and associative tables.

Quick Start

Run the ER diagram skill against your backend repository to generate the initial overview diagram and, if necessary, domain-based splits.

Frequently Asked Questions about erd-diagram

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate an ER diagram from Django or SQLAlchemy ORM models?

To generate an ER diagram from Django or SQLAlchemy ORM models, this skill automatically detects your source files and extracts tables, primary keys, and foreign keys to produce Draw.io diagrams using IE notation.

Can I create database diagrams from raw SQL DDL and Prisma schemas?

Yes, you can create database diagrams from raw SQL DDL and Prisma schemas; the tool detects migrations and DDL files to extract schema definitions and output mxGraph XML for direct opening in Draw.io.

What is the best way to visualize many-to-many relationships and associative tables in an ER diagram?

The best way to visualize many-to-many relationships and associative tables in an ER diagram is using IE notation, which this skill generates to accurately map N:M links, self-references, and logical foreign keys with clear legends.

How do I handle ER diagrams for large schemas with hundreds of tables?

To handle ER diagrams for large schemas with hundreds of tables, this skill generates a comprehensive overview diagram and automatically creates domain-specific splits targeting roughly thirty tables per diagram to maintain readability.

Does this ER diagram generator support TypeORM, GORM, and Sequelize?

Yes, this ER diagram generator supports TypeORM, GORM, and Sequelize; it detects your ORM framework to extract unique constraints, indexes, and relationships for comprehensive Draw.io schema visualization.

Why are external references and logical foreign keys documented separately in the generated Draw.io diagrams?

External references and logical foreign keys are documented separately in generated Draw.io diagrams to ensure accurate schema representation, preventing unresolved links from cluttering the core IE notation diagram.