redundantIndexes
redundantIndexesIdentify structurally redundant database indexes by detecting non-unique indexes whose leading columns form a strict prefix of another same-type index, independent of workload usage.
Instructions
Find structurally overlapping non-unique indexes whose leading columns are a strict prefix of another same-type index. Unlike unusedIndexes, this does not depend on workload scan counters.
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": {
"connection": "<connection>"
},
"name": "redundantIndexes"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | Omit to scan the schema. | |
| schema | No | ||
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| count | Yes | Number of redundant-index findings returned. | |
| table | No | ||
| schema | No | ||
| findings | No | Schema lint or redundant-index findings. |