verify_index
Measure a candidate index on a disposable clone, comparing read savings to write costs and checking for regressions, to produce an evidence-based adoption verdict.
Instructions
MEASURE a candidate index on a disposable data-bearing clone and return a verdict. This is the only tool that produces evidence: real CREATE INDEX, EXPLAIN (ANALYZE, BUFFERS) with grounded parameters before/after, a measured write-cost micro-benchmark, and a regression check across the top production queries. Verdict = read savings vs write cost at observed traffic rates, REJECT on any top-query regression.
Needs a clone provider on the profile (clone_provider = "docker") and Docker running; the clone is destroyed afterwards, always. Takes tens of seconds to minutes depending on database size. Fails loudly when the profile cannot measure — there is no degraded verdict.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"profile": "<profile>",
"index_def": "<index_def>"
},
"name": "verify_index"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sqls | No | ||
| profile | Yes | ||
| queryids | No | ||
| index_def | Yes | ||
| regression_top_n | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||