query-optimizer

Analyze and optimize SQL queries for better performance, suggesting indexes, query rewrites, and execution plan improvements

Database query optimization with index recommendations and EXPLAIN analysis

SQL query optimization for PostgreSQL/MySQL with indexing, EXPLAIN analysis. Use for slow queries, N+1 problems, missing indexes, or encountering sequential scans, OFFSET pagination, temp table spills, inefficient JOINs.

SQL optimization, query tuning, and database performance expert for production systems

Database architecture and SQL optimization with PostgreSQL expertise

Use this agent when you need to optimize database performance for B2B applications at enterprise scale. This agent specializes in multi-tenant database optimization, query performance tuning, indexing strategies, connection pooling, and database scaling for SaaS platforms. Handles PostgreSQL, MySQL, MongoDB, and cloud database optimizations. Examples: