Does this skill support physical foreign key constraints?

By default, the designer follows a 'logical relationship' principle (no physical FK constraints) to improve flexibility, but relationships are explicitly defined in documentation and visual diagrams.

Which database engines are supported?

The skill generates optimized syntax for MySQL 8.0, PostgreSQL, and SQL Server, adapting data types and auto-increment logic for each.

Can I customize the default fields like timestamps?

Yes. While it defaults to industry-standard fields (id, created_at, updated_at, is_deleted), you can instruct the skill to use custom system fields or omit them entirely.

Can I use the output in visual modeling tools?

Yes, it specifically generates JSON and DBML files that can be imported directly into DrawDB and other popular visual database design tools.

Database Schema Designer

Name: Database Schema Designer
Author: shining319

byshining319

•

Database Management

Generates production-ready database schemas with executable SQL scripts, visual ER diagrams, and comprehensive Markdown documentation.

The Database Schema Designer skill automates the end-to-end process of data modeling for solo developers and product teams. It interprets business requirements to create optimized table structures, strategic indexing, and logical relationships while adhering to modern best practices like snake_case naming and standardized system fields. By generating multiple outputs—including SQL for implementation, Markdown for documentation, and DrawDB-compatible files for visualization—it bridges the gap between conceptual design and production deployment.

Key Features

01Implements strategic index design based on query patterns and JOIN requirements

023 GitHub stars

03Produces DrawDB-compatible JSON and DBML files for instant ER diagram visualization

04Creates detailed Markdown documentation with table descriptions and relationship maps

05Generates multi-dialect SQL scripts for MySQL, PostgreSQL, and SQL Server

06Automatically incorporates standard system fields like timestamps and soft deletes

Use Cases

01Architecting the data layer for a new SaaS or e-commerce application

02Standardizing database conventions and field sizing across multiple projects

03Generating visual technical documentation and ER diagrams for stakeholders

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