skills.rest
bs-koo
bs-kooCOMMUNITY
Explore all skills by this author →
GitHub

generate-erd-guide

Generate ERDCloud-ready DDL and DE-08 table-definition drafts from requirements and screen lists.

Updated Mar 27, 2026
Search Tags:#sql#data-modeling#generate#erd#database-design#ddl#er-diagram
One-click install
npx skills add https://github.com/bs-koo/gx-pm --skill generate-erd-guide
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: generate-erd-guide
Source: https://github.com/bs-koo/gx-pm/tree/main/plugins/gx-pm/skills/generate-erd-guide
Command: npx skills add https://github.com/bs-koo/gx-pm --skill generate-erd-guide

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

요구사항과 화면목록에서 엔터티 및 관계를 식별하고, ERDCloud 입력용 DDL과 DE-08 테이블정의서 초안을 자동으로 생성합니다.

Core Features & Use Cases

  • 요구사항/화면 목록에서 엔터티를 식별하고 관계를 도출합니다.
  • ERDCloud에 바로 입력할 수 있는 DDL 초안과 표준 테이블정의서 초안을 생성합니다.
  • 데이터베이스 유형(Oracle, PostgreSQL, MySQL) 등 환경에 맞춘 기본 규칙과 네이밍 규칙을 적용합니다.

Quick Start

요구사항 목록과 화면목록표를 입력하면 ERD와 DDL 초안이 자동으로 제시됩니다.

Frequently Asked Questions about generate-erd-guide

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

FAQPage Schema
How do I generate ERD and DDL from requirements and screen lists?▼

ERDCloud-ready DDL is generated by analyzing requirement lists and UI screen specifications to identify entities and relationships. The system then produces standard DDL drafts and DE-08 table definition documents tailored for direct import.

Can I use this to create database schemas for Oracle, PostgreSQL, and MySQL?▼

Yes, database schema DDL generation supports Oracle, PostgreSQL, and MySQL environments. The system applies environment-specific default rules and naming conventions to ensure the generated schemas match your target database accurately.

What is an ERDCloud-ready DDL draft and how does it help with data modeling?▼

ERDCloud-ready DDL is SQL formatted for direct import into ERDCloud, accelerating data modeling by translating identified entities and relationships into structured schemas. It eliminates manual schema coding and ensures standardized structure generation.

Does this tool produce table definition documents along with the SQL DDL?▼

Yes, it generates DE-08 table definition document drafts alongside SQL DDL. This ensures data modeling outputs include both executable schema code and standardized documentation required for public and SI project deliverables.

What is the best way to translate UI specs into a database schema?▼

Providing screen list tables directly as input is the best way to translate UI specs into a database schema. The system extracts data fields and relationships from UI requirements to derive entities and generate consistent DDL automatically.

Related Skills

Explore More Software Engineering Skills→
AradotsoAradotso
3

design-os-product-planning

Automate product planning, data modeling, UI design, and implementation handoff generation with Design OS.

Official
Intermediate
bs-koobs-koo

convert-ddl-to-tablespec

Convert CREATE TABLE DDL into DE-08 table definitions.

Community
Intermediate
OKHP3OKHP3
2

okhp3-mermaid-data

Generate entity-relationship and class diagrams in Mermaid syntax for database schemas.

Community
Intermediate
ramybarsoumramybarsoum

database-design

Generate ER diagrams, SQL table definitions, indexes, migrations, and EF Core configurations from feature descriptions.

Community
Advanced