Can this skill generate SQL code?

While its primary focus is structural modeling and documentation, it provides the physical mappings and column types required to easily generate DDL statements for PostgreSQL, SQL Server, and other dialects.

Can it help with database normalization?

Absolutely. It includes specific workflows to identify dependency violations and guide you through transforming data structures into 1NF, 2NF, 3NF, or BCNF.

Is it suitable for NoSQL modeling?

While the notation is traditionally relational, the entity identification and relationship mapping phases are highly effective for structuring document-oriented or graph databases.

Does it support Mermaid diagrams?

Yes, the skill is specifically designed to produce Mermaid-compatible ERD syntax for seamless visual documentation within Markdown files and GitHub repositories.

Data Modeling & Database Design

Name: Data Modeling & Database Design
Author: melodic-software

bymelodic-software

•

データベース管理

Designs and documents robust data structures using Entity-Relationship Diagrams, data dictionaries, and multi-level schema models.

概要

This skill empowers Claude to act as a professional data architect, guiding users through the end-to-end lifecycle of database design. It provides structured frameworks for identifying business entities, defining attributes, and establishing complex relationships using industry-standard Crow's Foot notation and Mermaid diagrams. Whether you are normalizing a legacy database to 3NF or architecting a new microservice data layer, this skill ensures data integrity, consistency, and professional-grade documentation across conceptual, logical, and physical modeling phases.

主な機能

Creates comprehensive data dictionaries with type mapping and constraints
Generates visual Entity-Relationship Diagrams (ERDs) using Mermaid syntax
Applies rigorous database normalization rules from 1NF to BCNF
Guides through conceptual, logical, and physical modeling levels
Supports industry-standard notations like Crow's Foot and UML
12 GitHub stars

ユースケース

Documenting existing legacy schemas for technical debt analysis and onboarding
Architecting a new application database from raw business requirements
Refactoring data structures to improve query performance and reduce redundancy

概要

主な機能

Creates comprehensive data dictionaries with type mapping and constraints
Generates visual Entity-Relationship Diagrams (ERDs) using Mermaid syntax
Applies rigorous database normalization rules from 1NF to BCNF
Guides through conceptual, logical, and physical modeling levels
Supports industry-standard notations like Crow's Foot and UML
12 GitHub stars

ユースケース

Documenting existing legacy schemas for technical debt analysis and onboarding
Architecting a new application database from raw business requirements
Refactoring data structures to improve query performance and reduce redundancy