ORM Query Optimizer

Optimize database queries generated by ORMs.

When to Use

• Slow database queries in production
• N+1 query problems
• Need to add proper database indexes

Instructions

1. Identify slow queries via logs or EXPLAIN
2. Detect N+1 query patterns
3. Add eager loading where appropriate
4. Suggest proper indexes for common queries
5. Rewrite complex queries for performance
6. Add query caching strategies
7. Generate migration for new indexes