plugin
SQL query optimizer
sql-query-optimizer
Finds slow SQL in .sql files and application code, reads the real execution plan and rewrites the query. Forces a dry run on every BigQuery command.
When to use it
A query is slow or expensive in BigQuery, Postgres or MySQL.
Includes: 1 subagent
Includes: 4 skills
- BigQuery query optimizationReads the BigQuery query plan (stages, shuffle, workers) and fixes pruning, join order, skew and function choices.
- Context captureSaves what was done, why and how into context/memory/ so another agent or session can pick up the work.
- Context restoreReads the shared memory at the start of a session and summarizes earlier decisions before any work begins.
- SQL query optimizationReads EXPLAIN plans on Postgres, MySQL or SQL Server and fixes indexes, selectivity, joins, CTEs and pagination.
Includes: 1 hook
Technical description
Diagnoses and rewrites slow BigQuery and relational SQL queries using real execution plans.