AgentHubAgentHub

Microsoft SQL Server

MCP ServerMCP Registry官方收录

io.github.alyiox/mcp-mssql · v1.0.0

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

概览

Microsoft SQL Server 是一个MCP Server,收录自 官方 MCP Registry。支持 stdio 传输。本页提供 Cursor、Claude Code 等客户端的安装配置片段。

暂无自动生成的安装指引,请查看源仓库 README。

相关资源

统一 Manifest

{
  "id": "io.github.alyiox/mcp-mssql",
  "type": "mcp-server",
  "version": "1.0.0",
  "displayName": "Microsoft SQL Server",
  "description": "Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.",
  "repository": {
    "url": "https://github.com/alyiox/mcp-mssql",
    "source": "github",
    "subfolder": "src/Alyio.McpMssql"
  },
  "homepage": "https://github.com/alyiox/mcp-mssql",
  "distribution": {
    "packages": [
      {
        "registryType": "nuget",
        "identifier": "Alyio.McpMssql",
        "version": "1.0.0",
        "runtimeHint": "dnx",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "MCPMSSQL_CONNECTION_STRING",
            "description": "Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.",
            "isSecret": true
          },
          {
            "name": "MCPMSSQL_DESCRIPTION",
            "description": "Optional human-readable description for the default profile."
          },
          {
            "name": "MCPMSSQL_QUERY_MAX_ROWS",
            "description": "Max rows per interactive query (default 500; ceiling 1000)."
          },
          {
            "name": "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS",
            "description": "Interactive query command timeout in seconds (default 30)."
          },
          {
            "name": "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS",
            "description": "Max rows for snapshot queries (default 10000; ceiling 50000)."
          },
          {
            "name": "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS",
            "description": "Snapshot query timeout in seconds (default 120)."
          },
          {
            "name": "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS",
            "description": "Execution plan analysis timeout in seconds (default 300)."
          },
          {
            "name": "DOTNET_ENVIRONMENT",
            "description": "Set to Development to load dotnet user-secrets (local dev)."
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.alyiox/mcp-mssql",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.alyiox%2Fmcp-mssql/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}
Microsoft SQL Server — MCP Server 安装与配置 · AgentHub