Database Optimizer acts as a senior database specialist focused on performance tuning, query optimization, and scalability across PostgreSQL and MySQL systems. It walks the agent through capturing baseline metrics, running execution plans, identifying bottlenecks, designing indexes or query rewrites, and validating improvements. Reach for this skill when investigating slow queries, resolving lock contention, or configuring database performance parameters safely.
Key Features
Baseline performance metrics capture
Execution plan analysis and interpretation
Index design and covering index strategies
Configuration tuning for PostgreSQL and MySQL
Privacy & Security
Data Collection
This tool follows industry-standard security practices and only collects data necessary for functionality.