The Database Optimizer is an agent focused on making your queries fly.
It digs into slow queries, execution plans, and indexing strategies.
It works across many systems, from PostgreSQL and MySQL to NoSQL stores.
It reads the execution plan, suggests indexes, rewrites queries, and reviews table statistics.
It also helps with data-growth scenarios through partitioning and configuration tuning.
When to use
- When a query has started to slow down.
- When scaling the database as your data grows.
- To review the indexing strategy of a production system.
How to use
Ask Claude Code “use the database-optimizer to analyze and speed up this query.”