AgentHubAgentHub

sql-server-analyst-mcp

MCP ServerMCP Registry官方收录

io.github.coregentdevspace/sql-server-analyst-mcp · v0.1.1

Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.

源仓库 ↗

概览

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

安装

选择你的平台查看安装方式

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "<MSSQL_SERVER>",
        "MSSQL_USER": "<MSSQL_USER>",
        "MSSQL_PASSWORD": "<MSSQL_PASSWORD>"
      }
    }
  }
}

环境变量

MSSQL_SERVER必填

SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).

MSSQL_PORT可选

TCP port (default 1433; set 0 for named instance with dynamic port).

MSSQL_DATABASE可选

Default database to connect to. Most tools also accept an override argument.

MSSQL_USER必填

SQL authentication login name.

MSSQL_PASSWORD必填secret

SQL authentication password. Quote values containing '#' in .env files.

MSSQL_ENCRYPT可选

Encrypt the connection (true|false). Required true for Azure SQL.

MSSQL_TRUST_SERVER_CERT可选

Trust self-signed certificates (true|false). Use true only for local dev.

ALLOWED_DATABASES可选

Comma-separated allowlist of databases the server may access. Empty = unrestricted.

ALLOWED_SCHEMAS可选

Comma-separated allowlist of schemas for schema tools. Empty = unrestricted.

MAX_ROWS可选

Default row limit per safe query (default 100).

MAX_ROWS_LIMIT可选

Hard cap on query rows (default 1000).

QUERY_TIMEOUT_MS可选

Query execution timeout in milliseconds (default 30000).

LOG_LEVEL可选

error | warn | info | debug (default info).

相关资源

统一 Manifest

{
  "id": "io.github.coregentdevspace/sql-server-analyst-mcp",
  "type": "mcp-server",
  "version": "0.1.1",
  "displayName": "sql-server-analyst-mcp",
  "description": "Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.",
  "repository": {
    "url": "https://github.com/coregentdevspace/sql-server-analyst-mcp",
    "source": "github"
  },
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "sql-server-analyst-mcp",
        "version": "0.1.1",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "MSSQL_SERVER",
            "description": "SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).",
            "isRequired": true
          },
          {
            "name": "MSSQL_PORT",
            "description": "TCP port (default 1433; set 0 for named instance with dynamic port)."
          },
          {
            "name": "MSSQL_DATABASE",
            "description": "Default database to connect to. Most tools also accept an override argument."
          },
          {
            "name": "MSSQL_USER",
            "description": "SQL authentication login name.",
            "isRequired": true
          },
          {
            "name": "MSSQL_PASSWORD",
            "description": "SQL authentication password. Quote values containing '#' in .env files.",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "MSSQL_ENCRYPT",
            "description": "Encrypt the connection (true|false). Required true for Azure SQL."
          },
          {
            "name": "MSSQL_TRUST_SERVER_CERT",
            "description": "Trust self-signed certificates (true|false). Use true only for local dev."
          },
          {
            "name": "ALLOWED_DATABASES",
            "description": "Comma-separated allowlist of databases the server may access. Empty = unrestricted."
          },
          {
            "name": "ALLOWED_SCHEMAS",
            "description": "Comma-separated allowlist of schemas for schema tools. Empty = unrestricted."
          },
          {
            "name": "MAX_ROWS",
            "description": "Default row limit per safe query (default 100)."
          },
          {
            "name": "MAX_ROWS_LIMIT",
            "description": "Hard cap on query rows (default 1000)."
          },
          {
            "name": "QUERY_TIMEOUT_MS",
            "description": "Query execution timeout in milliseconds (default 30000)."
          },
          {
            "name": "LOG_LEVEL",
            "description": "error | warn | info | debug (default info)."
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.coregentdevspace/sql-server-analyst-mcp",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.coregentdevspace%2Fsql-server-analyst-mcp/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}
sql-server-analyst-mcp — MCP Server 安装与配置 · AgentHub