skills.rest
wfukatsu
wfukatsuCOMMUNITY
Explore all skills by this author →
GitHub

er-diagram-analysis

Generate Mermaid ER diagrams and entity catalogs from codebases or database models.

5|Updated Feb 10, 2026
Search Tags:#mermaid#data-modeling#database-design#diagram-generation#er-diagram#entity-relationship
One-click install
npx skills add https://github.com/wfukatsu/architecture-redesign-agent --skill er-diagram-analysis
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: er-diagram-analysis
Source: https://github.com/wfukatsu/architecture-redesign-agent/tree/main/.claude/skills/er-diagram-analysis
Command: npx skills add https://github.com/wfukatsu/architecture-redesign-agent --skill er-diagram-analysis

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

現行システムのデータ構造を把握し、エンティティと関係を視覚化することで、ドメイン理解とデータ設計の意思決定を支援します。

Core Features & Use Cases

  • 現行ER図の生成: Mermaid形式のER図を出力
  • エンティティカタログ: 属性・制約の一覧を作成
  • 関連分析: エンティティ間の関連と多重度を分析
  • ドメイン別ER図: 境界コンテキストごとの分割ER図を作成
  • Use Cases: アーキテクチャ設計のレビュー、データモデリングの補助

Quick Start

Call the skill with the target folder path to generate and save Mermaid ER diagrams and catalogs.

Frequently Asked Questions about er-diagram-analysis

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

FAQPage Schema
How do I generate an ER diagram from existing database code?▼

To generate an ER diagram from existing database code, this Skill analyzes codebases, ORM annotations, and DDL references to infer entities, attributes, keys, and relationships, then outputs Mermaid ER diagrams and markdown reports.

Can I create ER diagrams from ORM annotations and DDL references?▼

Yes, you can create ER diagrams by leveraging ORM annotations and DDL references within your codebase. The Skill infers entity relationships and constraints from these sources to produce visual Mermaid diagrams.

What is the best way to visualize entity relationships for architecture reviews?▼

Visualizing entity relationships for architecture reviews is best handled by generating domain-specific Mermaid ER diagrams and entity catalogs. This allows clear analysis of boundaries, entities, and multiplicity for stakeholders.

Does this tool support generating domain-specific ER diagrams by bounded context?▼

Yes, this tool supports generating domain-specific ER diagrams by bounded context. It can split entities and relationships into separate Mermaid diagrams to help analyze specific domain boundaries.

Do I need design documents to analyze a data model and produce an entity catalog?▼

No, you do not need design documents to analyze a data model and produce an entity catalog. The Skill can infer entities, attributes, and constraints directly from ORM annotations and DDL references, though design documents are optional.

Related Skills

Explore More Data & Analytics Skills→
DatTran26DatTran26

ck:databases

Translate business requirements into scalable MongoDB and PostgreSQL schema designs.

Community
Advanced
ishiyanishiyan

mermaid-creator

Create and convert Mermaid diagrams from syntax to SVG.

Community
Advanced
lance-doniflance-donif

data-model-creation

Generate Mermaid class diagrams for visual data relationship modeling.

Community
Advanced
silaslopes100silaslopes100

reversa-data-master

Generate data dictionaries and ERD diagrams from DDL, migrations, and ORM models.

Community
Advanced