Microsoft SQL Server MCP
v1.6.1io.github.alyiox/mcp-mssql
Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in.
transport:stdio
runtime:nuget
Target client
run in your project directory
claude mcp add mcp-mssql -e MCPMSSQL_CONNECTION_STRING=<MCPMSSQL_CONNECTION_STRING> -e MCPMSSQL_DESCRIPTION=<MCPMSSQL_DESCRIPTION> -e MCPMSSQL_QUERY_MAX_ROWS=<MCPMSSQL_QUERY_MAX_ROWS> -e MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS=<MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS> -e MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS=<MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS> -e MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS=<MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS> -e MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS=<MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS> -e MCPMSSQL_ALLOW_WRITE=<MCPMSSQL_ALLOW_WRITE> -e MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS=<MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS> -e DOTNET_ENVIRONMENT=<DOTNET_ENVIRONMENT> -- dnx Alyio.McpMssql --yes
Adds it for this project only. Append --scope user to make it available everywhere. Claude Code docs
This listing does not declare its tools. Connect the server and your client will discover them on the handshake.