What problem does it solve?
Provides a structured, production-minded approach to designing and evolving database schemas so applications run reliably and efficiently while preserving data integrity and minimizing downtime during changes.
Core Features & Use Cases
- Schema modeling & normalization: identify entities and relationships, apply 1NF–3NF, and evaluate safe denormalization when justified by measured performance needs.
- Indexing & query optimization: choose index types and composite/partial/covering indexes to match query patterns and interpret EXPLAIN plans to remove sequential scans and slow joins.
- Migration & deployment patterns: plan zero-downtime migrations with add-backfill-switch-drop steps, create indexes concurrently, and validate rollbacks.
- Operational guidance: mitigate N+1 queries with eager loading or batching, select connection pool sizing, and apply ORM best practices and bulk operations.
- Use case: optimize a high‑traffic orders system by modeling order_items, adding targeted composite indexes, converting offset pagination to keyset cursors, and deploying migrations safely.
Quick Start
Ask the database-design skill to review the current schema for the users and orders tables, recommend normalization or denormalization changes, and provide an index plan and zero-downtime migration steps.
