Can I use it to plan migrations?

Absolutely, it includes capabilities for schema migration planning to help you transition from legacy structures to modernized designs smoothly.

How does this improve AI coding?

By providing Claude with specific data modeling rubrics, it ensures the AI generates more consistent, architecturally sound, and scalable database code.

Does this skill support visual diagram exports?

It generates Mermaid.js syntax, which can be rendered into visual diagrams by various markdown editors, GitHub, and specialized Mermaid tools.

Can it help with database normalization?

Yes, the skill provides expert analysis for 1NF, 2NF, and 3NF to ensure your data structure is efficient and free of unnecessary redundancy.

Is it compatible with SQL databases?

While it focuses on logical modeling, the patterns and diagrams generated are applicable to all major relational database systems like PostgreSQL, MySQL, and SQLite.

ER Diagram and Data Modeling

Name: ER Diagram and Data Modeling
Author: Agentient

byAgentient

0•

Database Management

Generates entity-relationship diagrams and provides expert data modeling guidance for robust database schema design.

This skill empowers Claude to act as a senior database architect by automating the creation of Mermaid-based ER diagrams and conducting deep normalization analysis. It streamlines the data modeling process by identifying primary and foreign keys, establishing proper cardinalities, and planning schema migrations, making it indispensable for developers designing new systems or refactoring legacy databases for better performance and data integrity.

Key Features

01Comprehensive normalization analysis covering 1NF, 2NF, and 3NF

02Strategic index recommendations for database performance optimization

03Mermaid-based ER diagram generation for visual schema representation

04Automated identification of primary and foreign key relationships

05Detailed schema migration planning and cardinality notation

060 GitHub stars

Use Cases

01Refactoring an existing database to improve normalization and reduce redundancy

02Designing a new relational database schema from scratch using Mermaid syntax

03Documenting complex data relationships for technical specifications or team onboarding

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add agentient/vibekit er-diagram-and-data-modeling

For use in Claude.ai and ChatGPT

Download Skill