sql-plan-audit
CommunitySpot PR plan regressions in SQL queries.
Authormizchi
Version1.0.0
Installs0
System Documentation
What problem does it solve?
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.
Core Features & Use Cases
- Identify plan changes across a PR by comparing planner output for all catalog queries.
- Surface regressions such as new SCANs or TEMP B-TREE usage that impact performance.
- Provide a CI-friendly JSON or text report for diffs and reviews.
Quick Start
Run the explain-runner with a schema file and a sqlc-style query catalog to generate a plan-diff report.
Dependency Matrix
Required Modules
node:sqlite
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sql-plan-audit Download link: https://github.com/mizchi/skills/archive/main.zip#sql-plan-audit Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 510,000+ vetted skills library on demand.