skills.rest
KILWA73
KILWA73COMMUNITY
Explore all skills by this author →
GitHub

schema-designer

Generate normalized database schemas with Mermaid ERDs and migration code.

Updated Apr 12, 2026
Search Tags:#design#database#migration#sql#normalization#er-diagram
One-click install
npx skills add https://github.com/KILWA73/MiniSoc --skill schema-designer-kilwa73
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-designer
Source: https://github.com/KILWA73/MiniSoc/tree/main/.agents/skills/schema-designer
Command: npx skills add https://github.com/KILWA73/MiniSoc --skill schema-designer-kilwa73

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Visualize domain models as ER diagrams and generate ready-to-run migrations from a clear schema.

Core Features & Use Cases

  • Analyze Domain: identify entities, attributes, and relationships (1:1, 1:M, M:M) to form a coherent schema.
  • Normalize and Optimize: ensure 3NF normalization and intelligent indexing recommendations for foreign keys and query patterns.
  • Output Artifacts: generate a Mermaid ER diagram and a SQL or framework-specific migration with up() and down() methods.

Quick Start

Describe the domain to Schema Designer so it can produce an ERD and migrations.

Frequently Asked Questions about schema-designer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a database schema and migration from a domain description?▼

To generate a database schema, describe your domain so the tool can identify entities, attributes, and relationships, apply 3NF normalization, and output a Mermaid ER diagram alongside ready-to-run SQL migration code.

What is the best way to visualize domain models as an ER diagram and create migrations?▼

Visualizing domain models involves analyzing the domain to map 1:1, 1:M, and M:M relationships into a normalized schema, which then generates a Mermaid ER diagram and framework-specific migration files with up() and down() methods.

Can I get framework-specific migration code with up and down methods for my relational schema?▼

You can obtain framework-specific migration code by having the schema specification translated into SQL or framework migrations, complete with reversible up() and down() methods for immediate execution.

What level of normalization does the generated database schema follow?▼

The generated database schema follows Third Normal Form (3NF), ensuring entities and relationships are structured to eliminate data redundancy and maintain referential integrity across the relational model.

Related Skills

Explore More Design & Creative Skills→
peterquielpeterquiel
4

domain-model

Document domain models with entities, relationships, and business rules.

Community
Intermediate
inbharataiinbharatai
22

db-schema-designer

Design normalized relational database schemas with ERDs, indexes, constraints, and migration scripts.

Community
Intermediate
lance-doniflance-donif

data-model-creation

Generate Mermaid class diagrams for visual data relationship modeling.

Community
Advanced
AgentientAgentient
2

er-diagram-and-data-modeling

Identify and visualize entity-relationship structures from domain data.

Official
Basic