Find Missing Indexes
find_missing_indexesIdentify potentially missing SQL Server indexes by analyzing query execution patterns to improve database performance.
Instructions
Identify potentially missing indexes based on query execution patterns
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "find_missing_indexes"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | SQL Server connection string (uses default if not provided) | |
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| schema | No | Schema name (default: dbo) | |
| minImpact | No | Minimum impact score to include (default: 1000) |