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.

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

01Automated SQL CREATE statement generation for tables and indexes

02Mermaid-based Entity-Relationship Diagram (ERD) generation

03Schema optimization for referential integrity and query performance

04Comprehensive database normalization (1NF through BCNF)

05Intelligent relationship mapping including junction tables for M:N

063 GitHub stars

Use Cases

01Designing a normalized schema for a new social media or e-commerce application

02Refactoring an existing flat-file data structure into a relational model

03Generating visual documentation and SQL DDL for technical design reviews

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection skill-adapter

For use in Claude.ai and ChatGPT

Download Skill