get_index_recommendations
Analyze SQL Server databases to identify missing indexes that improve query performance and optimize database operations based on impact scoring.
Instructions
Get index recommendations for database optimization
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database name (optional) | |
| impact_threshold | No | Minimum impact score threshold (0-100, optional) | |
| limit | No | Maximum number of recommendations to return (optional, defaults to 10) | |
| schema | No | Schema name (optional, defaults to dbo) |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Database name (optional)",
"type": "string"
},
"impact_threshold": {
"description": "Minimum impact score threshold (0-100, optional)",
"type": "number"
},
"limit": {
"description": "Maximum number of recommendations to return (optional, defaults to 10)",
"type": "number"
},
"schema": {
"description": "Schema name (optional, defaults to dbo)",
"type": "string"
}
},
"type": "object"
}