skills.rest
gaoqiongxie
gaoqiongxieCOMMUNITY
Explore all skills by this author →
GitHub

database-designer

Generate MySQL schemas with ER diagrams, DDL scripts, and Java entity code.

1|1|Updated Apr 9, 2026
Search Tags:#database design#mysql#schema migration#erd#index optimization#ddl#java entity
One-click install
npx skills add https://github.com/gaoqiongxie/skills-ai --skill database-designer-gaoqiongxie
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-designer
Source: https://github.com/gaoqiongxie/skills-ai/tree/main/database-designer
Command: npx skills add https://github.com/gaoqiongxie/skills-ai --skill database-designer-gaoqiongxie

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually designing relational databases requires creating ER diagrams, writing DDL scripts, generating entity code, applying normalization rules, and planning schema migrations, which is time-consuming, error-prone, and often leads to performance bottlenecks or inconsistent schema designs.

Core Features & Use Cases

  • Full Schema Artifact Generation: Creates Mermaid ERDs, MySQL DDL scripts, and MyBatis-Plus Java entity code directly from natural language business requirements.
  • Normalization & Optimization Checks: Analyzes table designs against 1NF to BCNF normalization rules, recommends index strategies based on query patterns, and flags common design pitfalls.
  • Zero-Downtime Migration Planning: Generates expand-contract migration scripts to safely modify schema without interrupting running services.
  • Use Case: For example, when building an e-commerce order management system, you can input your business entities (users, products, orders, order items) and their relationships to get a complete, optimized database design in seconds.

Quick Start

Describe your business scenario including core entities, relationships, and common query patterns to receive a complete MySQL database design with ERD, DDL, and Java entity code.

Frequently Asked Questions about database-designer

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

FAQPage Schema
How do I generate MySQL DDL and Java entity code from natural language business requirements?▼

To generate MySQL DDL and Java entity code, input your business requirements including core entities and relationships, and the system outputs Mermaid ERDs, DDL scripts, and MyBatis-Plus Java entities.

What is the best way to plan zero-downtime schema migrations for MySQL?▼

The best way to plan zero-downtime schema migrations is to generate expand-contract migration scripts, which safely modify relational database schemas without interrupting running services.

How do I apply database normalization rules and optimize indexes when designing a MySQL schema?▼

To apply database normalization and optimize indexes, the system analyzes table designs against 1NF to BCNF rules and recommends index strategies based on your common query patterns to prevent performance bottlenecks.

Can I get an ER diagram along with DDL scripts for an e-commerce order management database?▼

Yes, you can get an ER diagram along with DDL scripts by inputting e-commerce business entities like users, products, orders, and order items to receive a complete MySQL database design with Mermaid ERDs.

Does this database design approach work with MyBatis-Plus and standard MySQL environments?▼

Yes, this database design approach works with MyBatis-Plus and standard MySQL environments by generating consistent, performant relational database structures that follow industry-standard naming conventions.

Related Skills

Explore More Software Engineering Skills→
TonyQ-AITonyQ-AI
9

domain-modeling

Extract core business concepts, entity relationships, and domain rules from requirement specifications.

Community
Intermediate
xiaoweidotnetxiaoweidotnet
22

table-creation

Generate database DDL and Java ORM code for MySQL and PostgreSQL.

Community
Intermediate
EIS-ITSEIS-ITS

Backend Queries

Generate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.

Official
Intermediate
Fancu1Fancu1

database-design

Design and optimize relational and NoSQL database schemas with migration patterns.

Community
Intermediate