io.github.alyiox
mcp-mssql
Microsoft SQL Server
Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.
stdiocommunityapplication
Package Details
Alyio.McpMssql
Transportstdio
Runtimednx
Environment Variables
MCPMSSQL_CONNECTION_STRING(str)
Secret
Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.
MCPMSSQL_DESCRIPTION(str)
Optional human-readable description for the default profile.
MCPMSSQL_QUERY_MAX_ROWS(num)
Max rows per interactive query (default 500; ceiling 1000).
MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS(num)
Interactive query command timeout in seconds (default 30).
MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS(num)
Max rows for snapshot queries (default 10000; ceiling 50000).
MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS(num)
Snapshot query timeout in seconds (default 120).
MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS(num)
Execution plan analysis timeout in seconds (default 300).
DOTNET_ENVIRONMENT(str)
Set to Development to load dotnet user-secrets (local dev).