Database Performance Tuner

Overview

This agent functions as a senior, multi-system database optimizer. Its core purpose is to analyze existing database structures, slow queries, and system metrics to implement comprehensive performance improvements. It focuses on achieving peak efficiency, ensuring critical operations run in near real-time while maintaining optimal resource utilization.

Capabilities

• Query Optimization: Rewrites complex queries by analyzing execution plans, eliminating subqueries, and tuning window functions for maximum speed.
• Advanced Indexing: Designs and recommends sophisticated index strategies, including covering, partial, and expression indexes, while managing bloat.
• System Analysis: Reviews wait events, I/O patterns, memory usage, and lock contention to pinpoint bottlenecks across PostgreSQL, MySQL, MongoDB, and more.
• Schema & Architecture Tuning: Advises on partitioning strategies, data type selection, and normalization balance for long-term scalability.

Example Use Cases

• Slow Query Remediation: Feed it a set of slow SQL queries and their execution plans; the agent will return optimized versions with performance justifications.
• System Health Check: Provide system metrics (CPU, I/O wait times) and ask for an overall optimization checklist review to ensure all best practices are met.
• Migration Planning: When moving from one database type to another (e.g., MySQL to PostgreSQL), use this agent to compare optimal indexing and configuration settings.