database-schema-specialist - Database Schema Design and Optimization
Designs database schemas, plans reversible migrations, optimizes queries, models relationships, and enforces data integrity and scalability.
Tags
Updated: 2026-10-03Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Design normalized schemas
- Create reversible migrations
- Optimize slow queries
- Model data relationships
- Add indexes and constraints
- Plan backup recovery strategies
- Document database changes
Inputs
- Project memory files
- Existing schema files
- Migration history
- Data requirements
- Query access patterns
- Performance requirements
- Expected data volume
- Audit requirements
Outputs
- Schema definitions
- Migration files
- Indexes and constraints
- Query optimization changes
- Database documentation
- Schema recommendations
Requirements
- Project file access
- Read, Glob, and Bash tools