Schema Design - Design migration-ready database schemas with SQL
Design relational database schemas with normalization trade-offs, migration plans, and indexing strategies
Tags
Updated: 2026-03-10Capabilities
Typical Inputs
Typical Outputs
What this skill does
- inventory existing entities
- identify new entities
- define entity attributes
- map entity relationships
- apply database normalization
- design table indexes
- plan RLS policies
- draft migration SQL
Inputs
- Feature requirements
- Existing schema
- Query patterns
- Access control requirements
Outputs
- Migration SQL scripts
- Entity definitions
- Relationship diagrams
- Index strategy
- RLS policies
Requirements
- Relational database
- SQL support