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