Health and performance · stop 9 of 13
find_unused_indexes
Lists indexes that have never been used.
Works in read modeTool sets: dba · full
You might ask
“Which indexes could we drop?”
Your assistant may call find_unused_indexes to answer.
How it works
- Indexes with zero scans since statistics were last reset. Primary keys, unique and constraint-backed indexes are left out.
- Check how long statistics have been collecting before dropping anything.
Parameters
limitnumber- Maximum number of indexes to return. Default 10.
What your assistant reads
The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.
List indexes with idx_scan = 0 (never used since stats reset), excluding primary keys, unique indexes, and constraint-backed indexes.