Agents · davila7

Database Optimizer agent by davila7

An agent for analysing slow queries and improving database performance through indexing and query rewriting across several database systems.

This text was machine-translated from the publisher's own information and has not been checked by a human editor. The publisher's original text is the reference.

This resource was imported automatically from the sources listed below and has not been reviewed by the AI Gate team yet. The description is the publisher's own, as published. Check the repository before installing.

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
Not reviewedAgents
davila7

episode-orchestrator agent by davila7

An agent that orchestrates episode-based workflows by coordinating multiple specialized agents in sequence, with payload validation and conditional routing.

Software developmentProductivity & automation
Updated 18 Nov 2026
Not reviewedAgents
davila7

atlassian-requirements-to-jira

An agent that turns requirements documents into structured Jira epics and user stories, with duplicate detection and user approval before anything is created.

Productivity & automationSoftware development
Updated 18 Nov 2026
Not reviewedAgents
davila7

swift-mcp-expert: Swift MCP server agent

An agent that offers expert help for building Model Context Protocol servers in Swift with modern concurrency and the official MCP Swift SDK.

Software development
Updated 18 Nov 2026
Not reviewedAgents
davila7

shell-scripting-pro: agent for shell scripting

An agent for writing shell scripts with error handling, POSIX compliance and automation patterns, published by davila7.

Software developmentProductivity & automation
Updated 18 Nov 2026
Database Optimizer agent by davila7 | AI Gate Discover