Skip to main content

Database Optimization

Optimize database queries and schema for performance

Complexity: Complex | Duration: 30m+ | Category: Performance

Tags: performance database optimization queries

Workflow Diagram​

Steps​

Step 1: Query analysis​

Agent: database

architect - Analyze slow queries with EXPLAIN

Step 2: Index optimization​

Agent: database

architect - Design optimal indexes

Step 3: Schema optimization​

Agent: database

architect - Normalize/denormalize as needed

Step 4: Query rewriting​

Agent: database

architect - Optimize query structure

Step 5: Benchmarking​

Agent: application

performance - Measure query performance improvement

Step 6: Validation​

Agent: component

qa-validator - Verify data integrity maintained

Step 7: Review​

Agent: component

qa-reviewer - Review optimization strategy

Usage​

To execute this workflow:

/workflow performance/database-optimization.workflow

See other workflows in this category for related automation patterns.