What database types does this skill support?

The skill natively supports MySQL 8.0 (default), PostgreSQL, and SQL Server, adapting syntax for types, increments, and timestamps accordingly.

Does it handle database relationships automatically?

Yes, it intelligently designs 1:1, 1:N, and N:N relationships, implementing junction tables where necessary and adding appropriate indexes on foreign key fields.

Can I visualize the generated schemas?

Yes, the skill generates DrawDB-compatible JSON and DBML files, which can be directly imported into the DrawDB tool for visual editing and viewing.

Are system fields like timestamps included?

By default, the skill includes standard fields such as primary key IDs, created_at, updated_at, and is_deleted for robust data management, unless otherwise specified.

Database Designer

Name: Database Designer
Author: shining319

byshining319

•

数据库管理

Generates production-ready database schemas, SQL scripts, and visual ER diagrams for diverse business systems.

关于

Database Designer is a specialized Claude Code skill that streamlines the data modeling process for developers, particularly those in single-person workflows. It automates the creation of comprehensive database architectures by following industry best practices like logical relationships, strategic indexing, and mandatory field commenting. Whether you're building a simple blog or a complex e-commerce platform, this skill generates ready-to-use SQL scripts for MySQL, PostgreSQL, or SQL Server, detailed Markdown documentation, and visual ER diagram files compatible with DrawDB, ensuring your data layer is scalable, consistent, and well-documented from day one.

主要功能

Smart inference of schema requirements based on minimal business domain descriptions.
Produces comprehensive Markdown documentation with table structures and field descriptions.
Multi-database support for MySQL, PostgreSQL, and SQL Server implementations.
Enforces industry best practices including logical foreign keys and strategic indexing.
Automatic generation of DrawDB-compatible JSON and DBML files for visual ER diagrams.
3 GitHub stars

使用场景

Generating visual ER diagrams and SQL scripts for technical documentation and developer handoffs.
Initializing the data architecture for a new SaaS or e-commerce application from scratch.
Refactoring existing database structures into a standardized, documented, and production-ready format.

关于

主要功能

Smart inference of schema requirements based on minimal business domain descriptions.
Produces comprehensive Markdown documentation with table structures and field descriptions.
Multi-database support for MySQL, PostgreSQL, and SQL Server implementations.
Enforces industry best practices including logical foreign keys and strategic indexing.
Automatic generation of DrawDB-compatible JSON and DBML files for visual ER diagrams.
3 GitHub stars

使用场景

Generating visual ER diagrams and SQL scripts for technical documentation and developer handoffs.
Initializing the data architecture for a new SaaS or e-commerce application from scratch.
Refactoring existing database structures into a standardized, documented, and production-ready format.