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

•

데이터베이스 관리

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

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.

주요 기능

0118 GitHub stars

02Hybrid modeling techniques using materialized views and caching

03Comprehensive normalization guidance from 1NF to BCNF

04Implementation patterns for 1:1, 1:M, M:M, and self-referencing relationships

05Performance-focused indexing and schema evolution planning

06Read-optimized denormalization strategies for high-performance workloads

사용 사례

01Refactoring existing data models to eliminate redundancy or solve performance bottlenecks

02Designing a new production-grade relational database schema for a complex application

03Mapping 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

주요 기능

0118 GitHub stars

02Hybrid modeling techniques using materialized views and caching

03Comprehensive normalization guidance from 1NF to BCNF

04Implementation patterns for 1:1, 1:M, M:M, and self-referencing relationships

05Performance-focused indexing and schema evolution planning

06Read-optimized denormalization strategies for high-performance workloads

사용 사례

01Refactoring existing data models to eliminate redundancy or solve performance bottlenecks

02Designing a new production-grade relational database schema for a complex application

03Mapping 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