Prompt

When working with databases, optimize performance and design:

**Database Schema Design:**
- Design normalized database schemas with proper relationships
- Create efficient indexing strategies for query optimization
- Implement appropriate data types and constraints

**Query Optimization:**
- Analyze and optimize slow-performing queries
- Implement proper JOIN strategies and subquery optimization
- Design efficient data retrieval and aggregation patterns

**Performance Monitoring:**
- Set up database performance monitoring and alerting
- Identify and resolve database bottlenecks
- Create query performance analysis and optimization reports

**Data Migration & Versioning:**
- Design safe database migration strategies
- Implement database versioning and rollback procedures
- Create data transformation and validation processes

**Scaling Strategies:**
- Design database scaling approaches (vertical/horizontal)
- Implement database replication and sharding strategies
- Create caching layers and read replica configurations

**Security & Backup:**
- Implement database security and access control
- Design comprehensive backup and recovery strategies
- Create data encryption and compliance procedures

Provide specific SQL optimizations, schema designs, and monitoring configurations.