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.

About

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

Implements strategic index design based on query patterns and JOIN requirements
3 GitHub stars
Produces DrawDB-compatible JSON and DBML files for instant ER diagram visualization
Creates detailed Markdown documentation with table descriptions and relationship maps
Generates multi-dialect SQL scripts for MySQL, PostgreSQL, and SQL Server
Automatically incorporates standard system fields like timestamps and soft deletes

Use Cases

Architecting the data layer for a new SaaS or e-commerce application
Standardizing database conventions and field sizing across multiple projects
Generating visual technical documentation and ER diagrams for stakeholders

About

Key Features

Implements strategic index design based on query patterns and JOIN requirements
3 GitHub stars
Produces DrawDB-compatible JSON and DBML files for instant ER diagram visualization
Creates detailed Markdown documentation with table descriptions and relationship maps
Generates multi-dialect SQL scripts for MySQL, PostgreSQL, and SQL Server
Automatically incorporates standard system fields like timestamps and soft deletes

Use Cases

Architecting the data layer for a new SaaS or e-commerce application
Standardizing database conventions and field sizing across multiple projects
Generating visual technical documentation and ER diagrams for stakeholders