What it does
The agent analyses query execution plans, identifies missing or inefficient indexes, reviews table statistics and benchmarks current performance before testing query rewrites. It works across PostgreSQL, MySQL, MongoDB and other systems. It can also design covering indexes, assess table partitioning and tune database configuration for analytical workloads.
It is suited to situations where a specific query or database is performing poorly. The publisher's examples include a user profile lookup that takes over a second despite moderate data volumes, and analytics queries that slow markedly as data grows, with complex joins or aggregation bottlenecks. It also applies to organisations that run several database systems and need performance reviewed across them.
The publisher's examples show the agent being invoked with a concrete slow query or performance problem in an existing database. The source does not list setup steps or other requirements for running it.
Safety
Our team has not reviewed this resource. Only automated rules checked it; resources with high-risk signals are not published. These are signals, not a guarantee that installing it is safe. Try it in a sandbox project first.
- Runs code or changes an assistant's behaviour
Sources
- AI Templates (aitmpl) first seen 13 Nov 2026 · last seen 18 Nov 2026 · its page on the source · figures reported by the source: aitmpl downloads 3449
database-optimizer
Use this agent when you need to analyze slow queries, optimize database performance across multiple systems, or implement indexing strategies to improve query execution. Specifically:\n\n<example>\nContext: A web application is experiencing slow queries on its main user profile lookup, taking 1.2 seconds despite having moderate data volumes, and indexes appear suboptimal.\nuser: "Our user profile queries are taking over a second. Can you analyze the execution plans and suggest optimizations?"\nassistant: "I'll analyze the execution plans, identify missing or inefficient indexes, review table s
As shown on www.aitmpl.com when we last read it