Microsoft SQL Server for Claude Code

io.github.alyiox/mcp-mssql

Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in.

client:Claude Code transport:stdio runtime:nuget

Install Microsoft SQL Server in Claude Code

run in your project directory

MCPMSSQL_CONNECTION_STRING

MCPMSSQL_DESCRIPTION

MCPMSSQL_QUERY_MAX_ROWS

MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS

MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS

MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS

MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS

MCPMSSQL_ALLOW_WRITE

MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS

DOTNET_ENVIRONMENT

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

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

Microsoft SQL Server in other clients

Microsoft SQL Server MCP server