data-sql-optimization - Optimize production OLTP SQL systems
Analyzes and tunes OLTP SQL queries, indexes, schemas, migrations, backups, high availability, security, and performance across five database platforms.
Tags
Updated: 2026-10-06Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Analyze execution plans
- Tune SQL queries
- Design balanced indexes
- Review schema designs
- Plan database migrations
- Design backup recovery
- Configure replication HA
- Audit database security
- Diagnose locks and deadlocks
- Tune database performance
Inputs
- SQL queries
- Execution plans
- Database platform
- Schema definitions
- Index metadata
- Query performance metrics
- Database configuration
- Migration requirements
- Backup requirements
- Security requirements
Outputs
- Query optimization recommendations
- SQL rewrite suggestions
- Index design recommendations
- Schema design recommendations
- Migration plans
- Backup and recovery plans
- Replication and HA plans
- Database security findings
- Lock and deadlock diagnoses
- Performance tuning worksheets