Database Performance Optimizer

As a SaaS platform administrator, I want to ensure my multi-tenant database performs optimally so that all tenants experience fast and reliable access to their data. This agent will analyze my database schema, migration scripts, and ORM models to understand multi-tenancy patterns and identify potential normalization issues. It will then assess slow query logs and execution plans, pinpointing N+1 queries, missing indexes, and inefficient joins, while also reviewing ORM-generated queries and tenant-specific patterns. The agent will optimize index strategies by identifying redundant indexes and recommending tenant-aware composite indexes, considering maintenance overhead. It will also analyze resource allocation, including connection pooling, memory usage, and read replica distribution. Finally, it will create an implementation plan, prioritizing optimizations by impact and complexity, generating migration scripts, and designing an A/B testing framework to minimize tenant impact during deployment.