Run EXPLAIN QUERY PLAN on sqlc-style catalogs and diff plans against a baseline.
npx skills add https://github.com/mizchi/skills --skill sql-plan-audit
Please help me install this Agent Skill. Skill: sql-plan-audit Source: https://github.com/mizchi/skills/tree/main/sql/plan-audit Command: npx skills add https://github.com/mizchi/skills --skill sql-plan-audit
Run EXPLAIN QUERY PLAN against every query in a sqlc-style catalog and diff the plans against a baseline to detect new full-table SCANs and TEMP B-TREE sort scans introduced by PRs. SQLite/D1-only today; engine extension noted below.
Run the explain-runner with a schema file and a sqlc-style query catalog to generate a plan-diff report.
High-intent search queries and answers about installing and using this skill.
To detect SQLite query plan regressions in a pull request, run EXPLAIN QUERY PLAN on a sqlc-style catalog and diff the output against a baseline to surface new SCANs or TEMP B-TREE usage.
EXPLAIN QUERY PLAN diffing for sqlc queries is the process of comparing SQLite planner output against a baseline to identify performance changes, such as new full-table SCANs introduced by schema or query modifications.
Set up SQLite query plan auditing for CI pipelines by providing a schema file and a sqlc-style query catalog with name markers to generate JSON or text report diffs suitable for automated PR reviews.
EXPLAIN QUERY PLAN diffing is currently limited to SQLite and D1 projects, as it relies on the node:sqlite dependency to evaluate planner decisions and detect changes like new SCANs or TEMP B-TREE usage.
To generate a SQL plan diff report, you need a schema file and a sqlc-style queries catalog containing name markers, which the runner uses to execute EXPLAIN QUERY PLAN and emit CI-friendly diffs.
ahravAnalyze and optimize SQLite schemas, queries, indexes, and pragmas.
BillChiricoResolve GitHub pull request review threads and failing CI checks with commits.
hiromailyAutomate Atlas schema migrations and SQLC query generation workflows.
cffrankAnalyze D1/SQLite query plans and recommend indexes for Cloudflare edge deployments.
