Skip to content
mcp/harbor
Cline

Microsoft SQL Server for Cline

io.github.alyiox/mcp-mssql

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

client:Cline transport:stdio runtime:nuget

Install Microsoft SQL Server in Cline

~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json · windows: %APPDATA%\Code\User\globalStorage\saoudrizwan.claude-dev\settings\cline_mcp_settings.json

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

{
  "mcpServers": {
    "mcp-mssql": {
      "command": "dnx",
      "args": [
        "Alyio.McpMssql",
        "--yes"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "<MCPMSSQL_CONNECTION_STRING>",
        "MCPMSSQL_DESCRIPTION": "<MCPMSSQL_DESCRIPTION>",
        "MCPMSSQL_QUERY_MAX_ROWS": "<MCPMSSQL_QUERY_MAX_ROWS>",
        "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "<MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "<MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS>",
        "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "<MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "<MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ALLOW_WRITE": "<MCPMSSQL_ALLOW_WRITE>",
        "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS": "<MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS>",
        "DOTNET_ENVIRONMENT": "<DOTNET_ENVIRONMENT>"
      }
    }
  }
}

Cline's MCP Servers pane edits this file for you if you would rather not find it. Cline docs

Microsoft SQL Server in other clients

Microsoft SQL Server MCP server