database-designer
Comprehensive database design tool creating complete schemas with tables, fields, indexes, and ER diagrams. Use when users request database design for any system. Generates Markdown docs, SQL scripts, and DrawDB-compatible JSON/DBML files. Supports MySQL, PostgreSQL, SQL Server. Triggers: database design, schema, ER diagram, SQL, data model. | 全面的数据库设计工具，创建完整的数据库架构。触发词：数据库设计、数据库架构、ER图、SQL、数据模型、表设计。
Security Assessment
About database-designer
The Database Designer skill is a comprehensive tool designed to create complete database schemas tailored to user specifications. It addresses the common challenges faced during database design, such as ensuring proper structure, consistency, and adherence to best practices. By automating the generation of schemas, SQL scripts, and visual ER diagrams, this skill simplifies the database design process and reduces the potential for errors, making it easier for users to implement robust database systems.
FAQ
What database systems does the Database Designer support?
The Database Designer supports MySQL, PostgreSQL, and SQL Server.
Can I customize the database design based on specific requirements?
Yes, the skill allows for customization based on user requirements, including core entities and key features.
Are there any limitations on the number of indexes per table?
Yes, there is a maximum of 5 indexes per table unless more are specifically requested by the user.
Does the skill generate documentation for the database design?
Yes, it generates comprehensive Markdown documentation alongside SQL scripts and visual ER diagrams.
Is there support for physical foreign keys in the generated schemas?
No, the skill does not create physical foreign key constraints; it focuses on logical relationships only.
Install database-designer
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill