← Aivana Database EngineerCONTENT HISTORYWHAT CHANGED · RULE-BASED ANALYSIS
Update to Aivana Database Engineer
Snapshot Sep 30, 2026 · 23:16 UTC · version 1.1.0
Collection source: not recorded for this historical snapshot.
First saved snapshot
No earlier snapshot is available to establish a change.
Compare saved observations
Download comparison JSONFull technical diff · 0 changed fields
Full snapshot data
{
"name": "explain-query",
"description": "Run structured explain/explain-analyze workflows and convert plan output into explainable optimization insights.",
"included_files": [],
"skill_md_contents": "---\nname: explain-query\ndescription: \"Run structured explain/explain-analyze workflows and convert plan output into explainable optimization insights.\"\n---\n\n# Explain Query\n\n## Use when\n- User asks why query is slow.\n- Planner needs operator-level bottleneck explanation.\n\n## Workflow\n1. Parse query intent and classify risk (read-only preferred mode).\n2. Collect `EXPLAIN` and `EXPLAIN ANALYZE` output in deterministic form.\n3. Annotate scan patterns, joins, sort/hash/temp spills, and lock indicators.\n4. Produce rewrite hypotheses with confidence scores.\n\n## Governance\n- Default to dry-run style if query could mutate data.\n- Provide \"why\" and \"impact estimate\" before any recommendation.\n\n## Output\n- `plan`, `bottlenecks`, `rewriteHints`, `estimatedCost`, `confidence`\n"
}SHA-256: 04d53ce2159b3c573443e8a943ac8ab4e53678b8942428fb67d84a02f4a0e907