data-model-creation

Name: data-model-creation
Author: TencentCloudBase

Professional rules for AI-driven data modeling and creation. Use this skill when users need to create and manage MySQL databases, design data models using Mermaid ER diagrams, and implement database schemas.

TL;DR

Optional advanced tool for complex data modeling with Mermaid ER diagrams. Use only when simple SQL is insufficient.

What Is It

Advanced tool for complex multi-table database design
Generates Mermaid classDiagram for visual ER modeling
Automates foreign key and field type mapping
Supports enterprise-level data model documentation

Key Features

Complex multi-table relationship management
Automatic foreign key generation
Visual ER diagram (Mermaid) output
Enterprise data model documentation
Type mapping (string, number, boolean, x-enum, etc.)
Chinese-to-English naming (PascalCase/camelCase)
Required/unique/display_field function support
Array and region type handling (e.g., x-area-code)

How to Use

1.Analyze business requirements and identify core entities and relationships
2.Create Mermaid classDiagram with correct type mappings and naming
3.Apply strict generation rules: required(), unique(), display_field(), array types
4.Set publish=false initially, publish separately
5.Use only for complex modeling, not queries or simple table creation