Microsoft SQL Server

{
  "_meta": {
    "io.modelcontextprotocol.registry/official": {
      "status": "active",
      "isLatest": true,
      "updatedAt": "2026-10-26T03:41:49.974364Z",
      "publishedAt": "2026-10-26T03:41:49.974364Z",
      "statusChangedAt": "2026-10-26T03:41:49.974364Z"
    }
  },
  "server": {
    "name": "io.github.alyiox/mcp-mssql",
    "title": "Microsoft SQL Server",
    "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
    "version": "1.8.0",
    "packages": [
      {
        "version": "1.8.0",
        "transport": {
          "type": "stdio"
        },
        "identifier": "Alyio.McpMssql",
        "runtimeHint": "dnx",
        "registryType": "nuget",
        "registryBaseUrl": "https://api.nuget.org/v3/index.json",
        "environmentVariables": [
          {
            "name": "MCPMSSQL_CONNECTION_STRING",
            "format": "string",
            "isSecret": true,
            "description": "Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings."
          },
          {
            "name": "MCPMSSQL_DESCRIPTION",
            "format": "string",
            "description": "Optional human-readable description for the default profile."
          },
          {
            "name": "MCPMSSQL_QUERY_MAX_ROWS",
            "format": "number",
            "description": "Max rows per interactive query (default 500; ceiling 1000)."
          },
          {
            "name": "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS",
            "format": "number",
            "description": "Interactive query command timeout in seconds (default 30)."
          },
          {
            "name": "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS",
            "format": "number",
            "description": "Max rows for snapshot queries (default 10000; ceiling 50000)."
          },
          {
            "name": "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS",
            "format": "number",
            "description": "Snapshot query timeout in seconds (default 120)."
          },
          {
            "name": "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS",
            "format": "number",
            "description": "Execution plan analysis timeout in seconds (default 300; ceiling 600)."
          },
          {
            "name": "MCPMSSQL_ALLOW_WRITE",
            "format": "boolean",
            "description": "Enable write commands (DDL/DML) via run_command on the default profile (default false). With no write-enabled profile the tool is not advertised at all. Soft guard only — prefer a db_datareader login for a hard read-only guarantee."
          },
          {
            "name": "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS",
            "format": "number",
            "description": "Write command timeout in seconds (default 60; ceiling 600)."
          },
          {
            "name": "DOTNET_ENVIRONMENT",
            "format": "string",
            "description": "Set to Development to load dotnet user-secrets (local dev)."
          }
        ]
      }
    ],
    "repository": {
      "url": "https://github.com/alyiox/mcp-mssql",
      "source": "github",
      "subfolder": "src/Alyio.McpMssql"
    },
    "websiteUrl": "https://github.com/alyiox/mcp-mssql",
    "description": "MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in."
  }
}