Agents · davila7

sql-pro: SQL query optimization and database schema design agent

An agent for optimizing complex SQL queries, designing database schemas and resolving performance issues on PostgreSQL, MySQL, SQL Server and Oracle.

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

sql-pro is an agent for optimizing complex SQL queries, designing efficient database schemas and diagnosing performance problems across PostgreSQL, MySQL, SQL Server and Oracle. Its described work includes execution plan analysis, index strategy, query rewriting for better join order and data warehouse design patterns.

It suits cases where a query over large tables is too slow, for example a multi-table analytical query with window functions that must meet a response-time target. It also applies to designing data warehouse schemas: fact and dimension tables, slowly changing dimensions, incremental loading with MERGE statements and materialized views for common analytics queries.

The publisher distributes it as a Markdown agent definition file, which is invoked by describing the query, schema or performance problem and naming the database engine involved. The publisher's documentation does not list other setup steps.

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 19 Nov 2026 · its page on the source · figures reported by the source: aitmpl downloads 3752
    sql-pro

    Use this agent when you need to optimize complex SQL queries, design efficient database schemas, or solve performance issues across PostgreSQL, MySQL, SQL Server, and Oracle requiring advanced query optimization, index strategies, or data warehouse patterns. Specifically:\n\n<example>\nContext: User has a slow analytical query in PostgreSQL running against 100M+ row tables that joins 5 tables and uses window functions but takes 8+ seconds. Needs to meet <500ms SLA.\nuser: "My analytics query is taking 8 seconds and needs to run in <500ms. It's a complex join across 5 tables with window functio

    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 19 Nov 2026
Not reviewedAgents
davila7

Task Decomposition Expert (agent)

An agent that breaks a complex, multi-step goal into a work breakdown structure with dependencies, parallel tracks, effort estimates and a handoff plan to specialist agents.

Software developmentProductivity & automation
Updated 19 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 19 Nov 2026
sql-pro: SQL query optimization and database schema design agent | AI Gate Discover