Which database engines does this skill support?

The Database Designer skill supports MySQL 8.0 (default), PostgreSQL, and SQL Server.

Does it create physical foreign key constraints?

By default, the skill follows a 'logical relationship' principle, mapping relationships in documentation and diagrams without creating physical constraints to maintain performance and flexibility.

How does the skill handle naming conventions?

It strictly follows industry-standard snake_case naming conventions for all tables, fields, and indexes to ensure consistency across the schema.

Where are the design files saved?

All generated files, including SQL scripts and Markdown docs, are saved in a standardized directory structure under 'outputs/ /database/'.

Can I visualize the generated database design?

Yes, the skill generates JSON and DBML files that are fully compatible with DrawDB, allowing you to import and visualize your ER diagrams instantly.

Database Designer

Name: Database Designer
Author: shining319

byshining319

•

데이터베이스 관리

Designs production-ready database schemas and generates SQL scripts, ER diagrams, and comprehensive documentation.

소개

The Database Designer skill is a specialized tool for architecting robust, scalable database schemas directly within your development workflow. It automates the creation of entity-relationship diagrams (DrawDB compatible), SQL DDL scripts, and detailed Markdown documentation while enforcing industry best practices such as logical relationship modeling, consistent snake_case naming, and optimized indexing. Whether you are building an e-commerce platform or a simple blog, this skill ensures your data layer is professionally structured, well-documented, and ready for implementation.

주요 기능

Exports visual ER diagrams in DrawDB-compatible JSON and DBML formats
Automatically applies standardized system fields like timestamps and soft deletes
Produces detailed Markdown documentation with table field lists and index rationales
3 GitHub stars
Enforces logical relationship principles and strategic index design
Generates multi-database SQL scripts for MySQL, PostgreSQL, and SQL Server

사용 사례

Generating visual ER diagrams and documentation for existing database requirements
Architecting the data layer for a new microservice or MVP
Rapidly prototyping complex e-commerce or CRM schemas with best-practice defaults

소개

주요 기능

Exports visual ER diagrams in DrawDB-compatible JSON and DBML formats
Automatically applies standardized system fields like timestamps and soft deletes
Produces detailed Markdown documentation with table field lists and index rationales
3 GitHub stars
Enforces logical relationship principles and strategic index design
Generates multi-database SQL scripts for MySQL, PostgreSQL, and SQL Server

사용 사례

Generating visual ER diagrams and documentation for existing database requirements
Architecting the data layer for a new microservice or MVP
Rapidly prototyping complex e-commerce or CRM schemas with best-practice defaults