Does this skill work for both SQL and NoSQL databases?

Yes, while the examples often use SQL, the underlying patterns for normalization and denormalization apply to relational databases like PostgreSQL as well as document stores like MongoDB.

Can it help me design complex many-to-many relationships?

Absolutely. It provides specific implementation patterns using junction tables, composite primary keys, and indexing strategies to handle complex entity associations efficiently.

How does this skill assist with schema migrations?

It helps you evaluate how proposed changes impact existing data integrity and query performance, providing a structured approach to evolving your schema without breaking dependencies.

When should I choose normalization over denormalization?

Use normalization (3NF) as your default for transactional systems (OLTP) to ensure data integrity. Choose denormalization for read-heavy workloads (OLAP) where query performance is more critical than write speed.

Data Modeling Patterns

Name: Data Modeling Patterns
Author: applied-artificial-intelligence

byapplied-artificial-intelligence

•

Database Management

Designs optimized database schemas and data models using normalization, denormalization, and advanced relationship patterns.

About

This skill equips Claude with expert-level database architecture capabilities, providing systematic frameworks for designing scalable data models. It guides users through the critical trade-offs between normalization (1NF-5NF) and denormalization based on specific application access patterns. Whether you are building a new transactional system, refactoring legacy tables, or planning complex schema migrations, this skill ensures your data foundation is performant, maintainable, and aligned with domain-driven design principles.

Key Features

18 GitHub stars
Hybrid modeling techniques using materialized views and caching
Comprehensive normalization guidance from 1NF to BCNF
Implementation patterns for 1:1, 1:M, M:M, and self-referencing relationships
Performance-focused indexing and schema evolution planning
Read-optimized denormalization strategies for high-performance workloads

Use Cases

Refactoring existing data models to eliminate redundancy or solve performance bottlenecks
Designing a new production-grade relational database schema for a complex application
Mapping complex domain entities and business logic into efficient database structures

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add applied-artificial-intelligence/claude-code-toolkit data-modeling-patterns

For use in Claude.ai and ChatGPT

Download Skill

GitHub