What implementation files does it produce?

The skill generates comprehensive SQL CREATE TABLE statements, including primary keys, foreign keys, constraints, and optimized indexes for immediate deployment.

Does it support database normalization?

Absolutely. The skill provides guidance and implementation for normalization levels from First Normal Form (1NF) through Boyce-Codd Normal Form (BCNF).

Can this skill generate visual diagrams?

Yes, it generates Mermaid-based Entity-Relationship Diagrams (ERDs) to help you visualize table relationships and data flow.

Can I use this to refactor an existing database?

Yes, you can provide your current schema to have the skill identify normalization violations and suggest a more efficient, refactored design.

Database Schema Designer

Name: Database Schema Designer
Author: jeremylongshore

byjeremylongshore

•

883

데이터베이스 관리

Designs, normalizes, and visualizes relational database schemas with automated SQL generation and ERD mapping.

소개

This skill empowers Claude to architect robust database structures by applying rigorous normalization principles from 1NF to BCNF. It automates the creation of Entity-Relationship Diagrams (ERDs) using Mermaid syntax and generates production-ready SQL CREATE statements, making it an essential tool for developers building new applications or refactoring legacy data models to ensure data integrity, minimize redundancy, and optimize query performance.

주요 기능

Visual ERD generation using Mermaid diagram syntax
Production-ready SQL DDL generation including constraints and indexes
Schema refactoring to eliminate data redundancy and improve integrity
Automated normalization guidance from 1NF through BCNF
Intelligent mapping of one-to-one, one-to-many, and many-to-many relationships
883 GitHub stars

사용 사례

Architecting a new application database from high-level requirements
Generating visual documentation and SQL scripts for complex data models
Normalizing legacy flat-file data into structured relational tables

소개

주요 기능

Visual ERD generation using Mermaid diagram syntax
Production-ready SQL DDL generation including constraints and indexes
Schema refactoring to eliminate data redundancy and improve integrity
Automated normalization guidance from 1NF through BCNF
Intelligent mapping of one-to-one, one-to-many, and many-to-many relationships
883 GitHub stars

사용 사례

Architecting a new application database from high-level requirements
Generating visual documentation and SQL scripts for complex data models
Normalizing legacy flat-file data into structured relational tables