What normalization levels does this skill support?

The skill provides guidance and implementation for normalization principles ranging from First Normal Form (1NF) through Boyce-Codd Normal Form (BCNF) to ensure data integrity.

Can it generate visual diagrams of the database?

Yes, it generates Entity-Relationship Diagrams (ERDs) using Mermaid syntax, allowing you to visualize tables, columns, and relationships directly in your documentation.

Does it support specific SQL dialects?

It generates standard SQL CREATE statements, including primary keys, foreign keys, and indexes, which are compatible with major systems like PostgreSQL, MySQL, and SQLite.

How does it handle many-to-many relationships?

The skill identifies many-to-many relationships and automatically designs the necessary junction (link) tables and foreign key constraints to maintain referential integrity.

Database Schema Designer

Name: Database Schema Designer
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Architects normalized database schemas, generates Mermaid ERD diagrams, and produces optimized SQL CREATE statements for robust data modeling.

About

The Database Schema Designer skill empowers developers to build scalable data architectures directly within Claude by applying rigorous normalization principles from 1NF to BCNF. It simplifies the transition from conceptual data requirements to physical implementation by automatically mapping relationships, visualizing structures with Mermaid ERD diagrams, and generating production-ready SQL scripts. Whether you are bootstrapping a new application or refactoring a legacy database to eliminate redundancy, this skill ensures your data model follows industry best practices for integrity and performance.

Key Features

Automated SQL CREATE statement generation for tables and indexes
Mermaid-based Entity-Relationship Diagram (ERD) generation
Schema optimization for referential integrity and query performance
Comprehensive database normalization (1NF through BCNF)
Intelligent relationship mapping including junction tables for M:N
3 GitHub stars

Use Cases

Designing a normalized schema for a new social media or e-commerce application
Refactoring an existing flat-file data structure into a relational model
Generating visual documentation and SQL DDL for technical design reviews

About

Key Features

Automated SQL CREATE statement generation for tables and indexes
Mermaid-based Entity-Relationship Diagram (ERD) generation
Schema optimization for referential integrity and query performance
Comprehensive database normalization (1NF through BCNF)
Intelligent relationship mapping including junction tables for M:N
3 GitHub stars

Use Cases

Designing a normalized schema for a new social media or e-commerce application
Refactoring an existing flat-file data structure into a relational model
Generating visual documentation and SQL DDL for technical design reviews