Microsoft SQL Server

Indexed by io.github.alyiox

About

Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.

Use this server

Add it to your MCP client. The catalogue lists this config verbatim from its source — it does not run, download, or vouch for the server. Review the command before you run it.

Transportstdio (runs a local command)

Env varsMCPMSSQL_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

Claude Code

claude mcp add --env MCPMSSQL_CONNECTION_STRING= --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 MCPMSSQL_ALLOW_WRITE= --env MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS= --env DOTNET_ENVIRONMENT= mcp-mssql -- dnx Alyio.McpMssql

Cursor

Add to Cursor

If the button doesn't open Cursor, use the JSON below — Cursor accepts the same mcpServers config.

VS Code

code --add-mcp '{"name":"mcp-mssql","command":"dnx","args":["Alyio.McpMssql"],"env":{"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":""}}'

JSON

{
  "mcpServers": {
    "mcp-mssql": {
      "command": "dnx",
      "args": [
        "Alyio.McpMssql"
      ],
      "env": {
        "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": ""
      }
    }
  }
}

Environment variables are listed by name only — fill in your own values. Entries never carry secrets.