MSSQL MCP Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

find_missing_indexes

Discover missing indexes in SQL Server databases by analyzing query execution patterns, optimizing performance with actionable insights based on impact scoring.

Instructions

Identify potentially missing indexes based on query execution patterns

Input Schema

Name	Required	Description
`connectionName`	No	Named connection to use (e.g., 'production', 'staging')
`connectionString`	No	SQL Server connection string (uses default if not provided)
`minImpact`	No	Minimum impact score to include (default: 1000)
`schema`	No	Schema name (default: dbo)

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "connectionName": {
      "description": "Named connection to use (e.g., 'production', 'staging')",
      "type": "string"
    },
    "connectionString": {
      "description": "SQL Server connection string (uses default if not provided)",
      "type": "string"
    },
    "minImpact": {
      "description": "Minimum impact score to include (default: 1000)",
      "type": "number"
    },
    "schema": {
      "description": "Schema name (default: dbo)",
      "type": "string"
    }
  },
  "type": "object"
}

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/c0h1b4/mssql-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server