skills.rest
williamwang25
williamwang25COMMUNITY
Explore all skills by this author →
GitHub

data-model-creation

Create relational data models as Mermaid classDiagrams from entity relationships and constraints.

Updated May 14, 2026
Search Tags:#mermaid#data modeling#er diagram#cloudbase#relational schema#schema planning#tool-driven workflow
One-click install
npx skills add https://github.com/williamwang25/ams-admin --skill data-model-creation-williamwang25
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-model-creation
Source: https://github.com/williamwang25/ams-admin/tree/main/.windsurf/skills/cloudbase/references/data-model-creation
Command: npx skills add https://github.com/williamwang25/ams-admin --skill data-model-creation-williamwang25

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill prevents time-consuming trial-and-error in complex database design by guiding you to model entities and relationships first, then convert that structure into a consistent, implementable schema.

Core Features & Use Cases

  • Mermaid classDiagram/ER-style modeling: Create a visual, relationship-aware data model using Mermaid classDiagram for multi-entity designs.
  • Model-first relational planning: Inspect existing models for naming consistency and structure before proposing changes.
  • Controlled workflow to implementation: Produce a validated modeling pass, then hand off SQL/table work to direct SQL tools when you’re ready.
  • Use case: When building an asset management domain that needs users, assets, and change history to be precisely linked, use this Skill to define entity boundaries and cardinalities before writing any SQL.

Quick Start

Use the data-model-creation skill to produce a Mermaid classDiagram ER-style blueprint for a multi-entity relational schema described in your request, then review and refine the entities and relationships before generating SQL in a follow-up tool.

Frequently Asked Questions about data-model-creation

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

FAQPage Schema
How do I design a relational data model before writing SQL?▼

You can design a relational data model by drafting a Mermaid classDiagram ER-style blueprint first. This approach maps entity boundaries, constraints, and cardinalities to validate structure before implementing SQL tables.

What is model-first database schema planning used for?▼

Model-first schema planning prevents trial-and-error in complex database design by visually defining multi-entity relationships and naming consistency first. You get a validated Mermaid blueprint to inspect before generating physical tables.

Can I use Mermaid classDiagram for multi-entity relational schema inspection?▼

Yes, Mermaid classDiagram supports multi-entity schema inspection by mapping relational constraints and relationship directions. It validates naming consistency and structure across linked entities like users, assets, and change history.

Does the data-model-creation workflow generate SQL directly?▼

No, the workflow produces a validated Mermaid modeling pass first. After you review and refine the relational schema, it hands off the structure to direct SQL tools for actual table generation.

When should I not use ER-style diagrams for relational schema design?▼

ER-style diagrams are not ideal for simple single-table designs lacking relational constraints. They are built for complex multi-entity domains where visualizing cardinalities and relationship directions prevents structural errors.

Related Skills

Explore More Software Engineering Skills→
MUmerRazzaqMUmerRazzaq
1

database-schema-design

Design relational schemas, create ERDs, and write DDL scripts.

Community
Intermediate
lxb031018lxb031018
2

data-model-creation

Generate Mermaid classDiagram relational data models for CloudBase schema planning.

Community
Advanced
mbpzmbpz

data-model-creation

Create CloudBase data models with Mermaid classDiagram visual representations.

Community
Advanced
anthrilanthril
3

postgres-schema-audit

Audit Postgres schemas and generate Markdown reports, ER diagrams, and draft migrations.

Official
Advanced