Connect

8 clients · secrets stay placeholders

JSON (mcpServers)Claude CodeCodexOpenCodeCursorVS CodeGemini CLIGoose

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

claude mcp add sql-server-analyst-mcp -e "MSSQL_SERVER=${MSSQL_SERVER}" -e "MSSQL_USER=${MSSQL_USER}" -e "MSSQL_PASSWORD=${MSSQL_PASSWORD}" -- npx -y [email protected]

[mcp_servers.sql-server-analyst-mcp]
command = "npx"
args = ["-y", "[email protected]"]
env = { "MSSQL_SERVER" = "${MSSQL_SERVER}", "MSSQL_USER" = "${MSSQL_USER}", "MSSQL_PASSWORD" = "${MSSQL_PASSWORD}" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "sql-server-analyst-mcp": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "[email protected]"
      ],
      "enabled": true,
      "environment": {
        "MSSQL_SERVER": "{env:MSSQL_SERVER}",
        "MSSQL_USER": "{env:MSSQL_USER}",
        "MSSQL_PASSWORD": "{env:MSSQL_PASSWORD}"
      }
    }
  }
}

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MSSQL_SERVER": "${MSSQL_SERVER}",
        "MSSQL_USER": "${MSSQL_USER}",
        "MSSQL_PASSWORD": "${MSSQL_PASSWORD}"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=sql-server-analyst-mcp&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsInNxbC1zZXJ2ZXItYW5hbHlzdC1tY3BAMC4xLjEiXSwiZW52Ijp7Ik1TU1FMX1NFUlZFUiI6IiR7TVNTUUxfU0VSVkVSfSIsIk1TU1FMX1VTRVIiOiIke01TU1FMX1VTRVJ9IiwiTVNTUUxfUEFTU1dPUkQiOiIke01TU1FMX1BBU1NXT1JEfSJ9fQ%3D%3D"
}

{
  "servers": {
    "sql-server-analyst-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MSSQL_SERVER": "${MSSQL_SERVER}",
        "MSSQL_USER": "${MSSQL_USER}",
        "MSSQL_PASSWORD": "${MSSQL_PASSWORD}"
      }
    }
  }
}

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

extensions:
  "sql-server-analyst-mcp":
    enabled: true
    name: "sql-server-analyst-mcp"
    type: stdio
    cmd: "npx"
    args:
      - "-y"
      - "[email protected]"
    envs:
      "MSSQL_SERVER": "${MSSQL_SERVER}"
      "MSSQL_USER": "${MSSQL_USER}"
      "MSSQL_PASSWORD": "${MSSQL_PASSWORD}"
    timeout: 300

Placeholders to fill from your own secret store: ${MSSQL_PASSWORD}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25

n/a
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)

authorizationn/a · weight 15

n/a
auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
n/a
auth.secret_in_urlno templated URL

tool hygienen/a · weight 30

n/a
tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)

stabilityn/a · weight 15

n/a
stability.changes, stability.rug_pulltool list unknown

dependencies50 · weight 15

warn
deps.known_vulns1 advisory of lower severity or without a published fix: GHSA-hp3w-g68c-fv3c in [email protected] (indirect, no fix yet)
fail
deps.mcp_sdk_version@modelcontextprotocol/sdk 1.30.1 has 1 known advisory (GHSA-6qxp-vccf-f47h); update @modelcontextprotocol/sdk to 1.31.0 or later
pass
deps.resolvable[email protected] resolved: 195 packages

Tool list unknown · checked 2026-10-20 13:49 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 76 / 100

provenance80

livenessn/a

freshness45

hygiene100

+repository +namespace-matches-repo ~liveness-unmeasured -stale-181d

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Dependencies

[email protected] npm194 dependencies, resolved · MCP SDK @modelcontextprotocol/sdk 1.30.1 · advisories checked 2026-10-19

advisory	severity	package	fixed in
GHSA-6qxp-vccf-f47hMCP TypeScript SDK: OAuth client could send credentials to an authorization server chosen by the MCP server	high	`@modelcontextprotocol/[email protected]`MCP SDK, direct	fixed in `1.31.0`
GHSA-hp3w-g68c-fv3csprintf-js vulnerable to denial of service through unbounded precision specifiers	moderate	`[email protected]`indirect	no fix yet

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.

Endpoints

package	registry	version	runtime	secrets
`sql-server-analyst-mcp`	npm	0.1.1	–	`MSSQL_PASSWORD`

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Similar MCP servers

Official server.json

{
  "name": "io.github.coregentdevspace/sql-server-analyst-mcp",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "0.1.1",
  "packages": [
    {
      "version": "0.1.1",
      "transport": {
        "type": "stdio"
      },
      "identifier": "sql-server-analyst-mcp",
      "registryType": "npm",
      "environmentVariables": [
        {
          "name": "MSSQL_SERVER",
          "format": "string",
          "isRequired": true,
          "description": "SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL)."
        },
        {
          "name": "MSSQL_PORT",
          "format": "string",
          "description": "TCP port (default 1433; set 0 for named instance with dynamic port)."
        },
        {
          "name": "MSSQL_DATABASE",
          "format": "string",
          "description": "Default database to connect to. Most tools also accept an override argument."
        },
        {
          "name": "MSSQL_USER",
          "format": "string",
          "isRequired": true,
          "description": "SQL authentication login name."
        },
        {
          "name": "MSSQL_PASSWORD",
          "format": "string",
          "isSecret": true,
          "isRequired": true,
          "description": "SQL authentication password. Quote values containing '#' in .env files."
        },
        {
          "name": "MSSQL_ENCRYPT",
          "format": "string",
          "description": "Encrypt the connection (true|false). Required true for Azure SQL."
        },
        {
          "name": "MSSQL_TRUST_SERVER_CERT",
          "format": "string",
          "description": "Trust self-signed certificates (true|false). Use true only for local dev."
        },
        {
          "name": "ALLOWED_DATABASES",
          "format": "string",
          "description": "Comma-separated allowlist of databases the server may access. Empty = unrestricted."
        },
        {
          "name": "ALLOWED_SCHEMAS",
          "format": "string",
          "description": "Comma-separated allowlist of schemas for schema tools. Empty = unrestricted."
        },
        {
          "name": "MAX_ROWS",
          "format": "string",
          "description": "Default row limit per safe query (default 100)."
        },
        {
          "name": "MAX_ROWS_LIMIT",
          "format": "string",
          "description": "Hard cap on query rows (default 1000)."
        },
        {
          "name": "QUERY_TIMEOUT_MS",
          "format": "string",
          "description": "Query execution timeout in milliseconds (default 30000)."
        },
        {
          "name": "LOG_LEVEL",
          "format": "string",
          "description": "error | warn | info | debug (default info)."
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/coregentdevspace/sql-server-analyst-mcp",
    "source": "github"
  },
  "description": "Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis."
}