MCP Server
MCP
Microsoft SQL Server
By Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.
Install
nuget:[email protected]Configuration Example
{
"remotes": [],
"packages": [
{
"registryType": "nuget",
"registryBaseUrl": "https://api.nuget.org/v3/index.json",
"identifier": "Alyio.McpMssql",
"version": "1.2.0",
"runtimeHint": "dnx",
"transport": {
"type": "stdio"
},
"environmentVariables": [
{
"description": "Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.",
"format": "string",
"isSecret": true,
"name": "MCPMSSQL_CONNECTION_STRING"
},
{
"description": "Optional human-readable description for the default profile.",
"format": "string",
"name": "MCPMSSQL_DESCRIPTION"
},
{
"description": "Max rows per interactive query (default 500; ceiling 1000).",
"format": "number",
"name": "MCPMSSQL_QUERY_MAX_ROWS"
},
{
"description": "Interactive query command timeout in seconds (default 30).",
"format": "number",
"name": "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS"
},
{
"description": "Max rows for snapshot queries (default 10000; ceiling 50000).",
"format": "number",
"name": "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS"
},
{
"description": "Snapshot query timeout in seconds (default 120).",
"format": "number",
"name": "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS"
},
{
"description": "Execution plan analysis timeout in seconds (default 300).",
"format": "number",
"name": "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS"
},
{
"description": "Enable write commands (DDL/DML) via run_command on the default profile (default false). Soft guard only — prefer a db_datareader login for a hard read-only guarantee.",
"format": "boolean",
"name": "MCPMSSQL_ALLOW_WRITE"
},
{
"description": "Write command timeout in seconds (default 60; ceiling 600).",
"format": "number",
"name": "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS"
},
{
"description": "Set to Development to load dotnet user-secrets (local dev).",
"format": "string",
"name": "DOTNET_ENVIRONMENT"
}
]
}
]
}
mcp
model-context-protocol
nuget
Comments
Sign in to leave a comment