Database Skill

When to use this skill

Use when designing schemas, writing migrations, creating queries, modeling data relationships, or working on data access layers.

Data Modeling Principles

1. Start with the domain, not the database

• Model your domain entities first (in types/)
• Then map them to database tables/collections
• The domain model drives the schema, not the other way around

2. Normalize, then denormalize intentionally

• Start with normalized schema (3NF)
• Denormalize only when you have measured performance evidence
• Document every denormalization with the reason why