Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.
{
"MCPMSSQL_CONNECTION_STRING": "YOUR_SECRET_VALUE",
"MCPMSSQL_DESCRIPTION": "YOUR_VALUE_HERE",
"MCPMSSQL_QUERY_MAX_ROWS": "YOUR_VALUE_HERE",
"MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "YOUR_VALUE_HERE",
"MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "YOUR_VALUE_HERE",
"MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "YOUR_VALUE_HERE",
"MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "YOUR_VALUE_HERE",
"DOTNET_ENVIRONMENT": "YOUR_VALUE_HERE"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-alyiox-mcp-mssql": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-io-github-alyiox-mcp-mssql"
],
"env": {
"MCPMSSQL_CONNECTION_STRING": "YOUR_SECRET_VALUE",
"MCPMSSQL_DESCRIPTION": "YOUR_VALUE_HERE",
"MCPMSSQL_QUERY_MAX_ROWS": "YOUR_VALUE_HERE",
"MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "YOUR_VALUE_HERE",
"MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "YOUR_VALUE_HERE",
"MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "YOUR_VALUE_HERE",
"MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "YOUR_VALUE_HERE",
"DOTNET_ENVIRONMENT": "YOUR_VALUE_HERE"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
Microsoft SQL Server is an MCP server for Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.. It supports STDIO transport.
Use the client-specific config in Install and add it to your MCP-compatible client.
Choose the Claude Desktop tab in Install and copy the config into Claude Desktop's MCP server settings.
Choose the Claude Code tab in Install and copy the config into Claude Code's MCP server settings.
Choose the Codex tab in Install and copy the config into Codex's MCP server settings.
Choose the Cursor or VS Code tab in Install and copy the config into Cursor or VS Code's MCP server settings.
Microsoft SQL Server uses STDIO transport. Use the package or command config in Install.
Microsoft SQL Server inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
Microsoft SQL Server does not advertise a verified auth requirement. If discovery fails, it may still need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
Alyio.McpMssqlstdio | nuget | 1.0.0 | Env: MCPMSSQL_CONNECTION_STRING secret Env: MCPMSSQL_DESCRIPTION Env: MCPMSSQL_QUERY_MAX_ROWS Env: MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS Env: MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS Env: MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS Env: MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS Env: DOTNET_ENVIRONMENT |