Does it generate visual diagrams?

Yes, the skill generates Mermaid syntax to produce clear, professional Entity-Relationship Diagrams (ERDs) for visualization.

Can it help with relationship mapping?

Yes, it identifies and defines one-to-one, one-to-many, and many-to-many relationships, including the creation of junction tables and foreign key constraints.

What normalization levels does this skill support?

It provides guidance for normalization principles ranging from First Normal Form (1NF) through Boyce-Codd Normal Form (BCNF) to eliminate data redundancy.

Can I use this for existing databases?

Absolutely. It can analyze your current schema to identify normalization violations and suggest refactored table structures or ALTER TABLE statements.

Database Schema Designer

Name: Database Schema Designer
Author: BbgnsurfTech

byBbgnsurfTech

•

数据库管理

Architects optimized relational database schemas through normalization, ERD visualization, and automated SQL generation.

关于

The Database Schema Designer skill enables Claude to function as a professional database architect, converting conceptual data requirements into highly efficient, normalized structures. It guides users through normalization levels from 1NF to BCNF, maps intricate entity relationships, and provides visual clarity via Mermaid-based ERD diagrams. Whether you are bootstrapping a new project or refactoring a legacy system, this skill ensures data integrity and performance by generating precise SQL statements and indexing strategies.

主要功能

3 GitHub stars
Complex entity relationship mapping (1:1, 1:N, N:M)
Indexing and referential integrity optimization
Automated normalization guidance (1NF to BCNF)
Mermaid-based ERD diagram generation
SQL DDL (CREATE/ALTER) statement generation

使用场景

Architecting a backend schema for a new web application from scratch
Generating visual schema documentation and SQL scripts for team reviews
Refactoring and normalizing redundant legacy database tables for better integrity

关于

主要功能

3 GitHub stars
Complex entity relationship mapping (1:1, 1:N, N:M)
Indexing and referential integrity optimization
Automated normalization guidance (1NF to BCNF)
Mermaid-based ERD diagram generation
SQL DDL (CREATE/ALTER) statement generation

使用场景

Architecting a backend schema for a new web application from scratch
Generating visual schema documentation and SQL scripts for team reviews
Refactoring and normalizing redundant legacy database tables for better integrity