← Aivana Database EngineerCONTENT HISTORY

Update to Aivana Database Engineer

Snapshot Sep 30, 2026 · 23:16 UTC · version 1.1.0

Collection source: not recorded for this historical snapshot.

WHAT CHANGED · RULE-BASED ANALYSIS

First saved snapshot

No earlier snapshot is available to establish a change.

Compare saved observations

Download comparison JSON

Full technical diff · 0 changed fields

Full snapshot data

{
  "name": "index-portfolio-optimizer",
  "description": "Optimize the whole index portfolio by finding redundant, overlapping, unused, and high-write-cost indexes.",
  "included_files": [],
  "skill_md_contents": "---\nname: index-portfolio-optimizer\ndescription: Optimize the whole index portfolio by finding redundant, overlapping, unused, and high-write-cost indexes.\n---\n\n# Index Portfolio Optimizer\n\nRun:\n\n```bash\nnode runtime/runTool.js index_portfolio_optimizer '{\"indexes\":[{\"name\":\"ix_a\",\"columns\":[\"status\"],\"reads\":100,\"writes\":50},{\"name\":\"ix_ab\",\"columns\":[\"status\",\"created_at\"],\"reads\":200,\"writes\":60}]}'\n```\n\nReturns redundant indexes, drop candidates, create candidates, and action order.\n"
}

SHA-256: c861be40cb718c9d6914ca49d8bde8464fbb35a4f3cebc623ed1017e824270e2