Which database systems are supported by this skill?

The Database Designer supports MySQL 8.0 as the default, but can also generate optimized schemas for PostgreSQL and SQL Server.

Does it handle standard fields like timestamps automatically?

Yes, it automatically includes standard system fields such as ID, created_at, updated_at, and is_deleted (soft delete) unless specified otherwise.

How can I visualize the database schema generated?

The skill generates both JSON and DBML files that are fully compatible with DrawDB, allowing you to import them and view a visual ER diagram instantly.

Does it create physical foreign keys in the SQL script?

By default, it follows the principle of using logical relationships instead of physical foreign key constraints to maintain flexibility, though it explicitly documents these relationships.

What documentation does the skill provide?

It generates a comprehensive Markdown document including a database overview, detailed table structures, field descriptions, index lists, and relationship explanations.

Database Designer

Name: Database Designer
Author: shining319

byshining319

•

Database Management

Generates production-ready database schemas, SQL scripts, and ER diagrams compatible with DrawDB.

The Database Designer skill streamlines the data modeling process by creating comprehensive schemas based on business requirements. It automates the generation of documentation, executable SQL for multiple engines including MySQL, PostgreSQL, and SQL Server, and visual ER diagram files. By adhering to professional design principles—such as logical relationships, strategic indexing, and mandatory system fields—it ensures your database architecture is scalable, maintainable, and ready for deployment in any development environment.

Key Features

01Comprehensive Markdown documentation for tables and relationships

02Multi-database support for MySQL, PostgreSQL, and SQL Server

03Automated ER diagram generation in DrawDB JSON and DBML formats

043 GitHub stars

05Built-in best practices for indexing and realistic field sizing

06Standardized system field injection for timestamps and soft deletes

Use Cases

01Architecting a new SaaS product database from high-level business requirements

02Generating executable SQL scripts and migration files for backend services

03Visualizing complex data models through DrawDB integration for team reviews

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add shining319/claude-code-single-person-workflow database-designer

For use in Claude.ai and ChatGPT

Download Skill