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

•

Database Management

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.

Key Features

01Creates comprehensive data dictionaries with type mapping and constraints

02Generates visual Entity-Relationship Diagrams (ERDs) using Mermaid syntax

03Applies rigorous database normalization rules from 1NF to BCNF

04Guides through conceptual, logical, and physical modeling levels

05Supports industry-standard notations like Crow's Foot and UML

0612 GitHub stars

Use Cases

01Documenting existing legacy schemas for technical debt analysis and onboarding

02Architecting a new application database from raw business requirements

03Refactoring data structures to improve query performance and reduce redundancy

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add melodic-software/claude-code-plugins data-modeling

For use in Claude.ai and ChatGPT

Download Skill