mcp-sqlserver
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MSSQL_MCP_CONNECTIONS | No | Path to a connections.json file (alternative to the default location). | |
| MSSQL_MCP_CONNECTIONS_JSON | No | Inline JSON string containing the connections configuration. |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_connectionsB | List all available SQL Server connections grouped by connectionGroup |
| reload_connectionsA | Reload connections from connections.json file without restarting the MCP server. Closes existing connection pools and loads new configuration. |
| queryC | Execute a SQL query on the database |
| get_schemaB | Get database schema information for specific tables |
| get_indexesC | Get index information for a table |
| get_execution_planB | Get execution plan for a query |
| get_stored_procedureC | Get stored procedure definition |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 7 tools
Each tool targets a distinct concern: connection management, query execution, schema inspection, index inspection, execution plans, and stored procedure definitions. The purposes are clearly separated with no meaningful overlap.
Most tools follow a consistent verb_noun pattern like list_connections, get_schema, and get_indexes. The bare 'query' deviates slightly but is understandable and not confusing.
Seven tools is well-scoped for a SQL Server MCP server, covering connection management and common database inspection operations without unnecessary bloat.
The tool surface covers connection management, query execution, schema, index, execution plan, and stored procedure access. A minor gap is the lack of explicit listing tools for tables or procedures, but these can be queried through the query tool.