BA ERD Generation

Generate Mermaid ERD diagrams and data dictionaries from elicitation notes.

Updated Apr 12, 2026
One-click install
npx skills add https://github.com/clovernguyen1010-ship-it/Clover_Nguyen --skill ba-erd-generation-clovernguyen1010-ship-it
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: BA ERD Generation
Source: https://github.com/clovernguyen1010-ship-it/Clover_Nguyen/tree/main/.agent/skills/ba-erd-gen
Command: npx skills add https://github.com/clovernguyen1010-ship-it/Clover_Nguyen --skill ba-erd-generation-clovernguyen1010-ship-it

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps business analysts translate elicitation notes into an Entity-Relationship Diagram (ERD) and a comprehensive Data Dictionary, enabling clear data modeling and design communication.

Core Features & Use Cases

  • ERD & Data Dictionary Generation: Convert requirements into Mermaid ERD diagrams and structured attribute definitions.
  • Incremental Updates: Update diagrams and dictionaries as new elicitation results arrive.
  • Validation & Guardrails: Enforce data-type, PK/FK presence, and relationship clarity for consistent designs.

Quick Start

Analyze the elicitation notes and generate a Mermaid ERD plus a data dictionary from business requirements.

Frequently Asked Questions about BA ERD Generation

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

FAQPage Schema
How do I generate an ERD and data dictionary from elicitation notes?

To generate an ERD and data dictionary from elicitation notes, use this Skill to identify entities, attributes, and relationships. It translates requirements into Mermaid erDiagram code and structured definitions with PK/FK, data types, and constraints.

Can I update my Mermaid ERD incrementally as new elicitation results arrive?

Yes, you can update your Mermaid ERD incrementally as new elicitation results arrive. The Skill supports incremental updates to both the diagram and the data dictionary, ensuring your database schema reflects the latest requirements.

How do I validate primary and foreign keys when modeling entities for a database schema?

To validate primary and foreign keys when modeling entities, the Skill enforces built-in guardrails. It validates input to ensure PK/FK presence, relationship clarity, and correct data types for consistent database schema designs.

What is the best way to translate business analysis requirements into a database schema?

This approach distinguishes itself by generating Mermaid erDiagram code directly from business requirements, bridging the gap between elicitation and technical design. It provides a structured data dictionary alongside the visual diagram for comprehensive design reviews.