sql-server-analyst-mcp — MCP Server 安装配置（官方 MCP Registry）

{
  "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"
  }
}