designing-database-schemas
Installation
SKILL.md
Designing Database Schemas
Purpose
Design scalable, maintainable database schemas that balance normalization with query performance:
- Apply normalization principles (1NF-BCNF) appropriately
- Choose optimal data types and constraints
- Design efficient indexing strategies
- Implement common patterns (audit trails, soft deletes, multi-tenancy)
- Create clear entity relationships