Recommend indexes
litescope_adviseFind missing indexes, redundant indexes, and full table scans in SQLite databases, and get actionable CREATE/DROP INDEX recommendations.
Instructions
Analyze a local SQLite database for performance problems and recommend fixes: foreign keys with no index, redundant indexes, and full table scans for any supplied queries. Returns findings with runnable CREATE/DROP INDEX suggestions. Read-only — recommends, never alters the schema. (Local files only.)
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": {
"source": "<source>"
},
"name": "litescope_advise"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| source | Yes | Local SQLite file path (advise requires direct file access) | |
| queries | No | Optional SQL queries to check for full table scans |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | The analyzed database. | |
| findings | Yes | Issues with rule, severity, and a runnable suggestion. |