Database Design

Design efficient, maintainable database schemas with safe migration strategies.

Key Principles

• Start from requirements: identify entities, attributes, and relationships first
• Normalize for data integrity, denormalize selectively for read performance
• Design indexes based on actual query patterns, not guesses
• Migrations must be reversible and safe for zero-downtime deployments
• Choose the right ORM — Prisma for type safety, Drizzle for SQL-close, TypeORM for enterprise

Quick Start Checklist