# Snowflake MCP Server

> A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants

- name: io.github.nsphung/mcp-snowflake-server
- version: 0.14.4
- connection class: L0 (run_local_package)
- trust: 90/100
- quality: –/100 (not scored)
- owner: not claimed
- descriptor: https://api.protogrid.dev/v1/servers/io.github.nsphung%2Fmcp-snowflake-server
- tools: https://api.protogrid.dev/v1/servers/io.github.nsphung%2Fmcp-snowflake-server/tools

**Runs on your machine: something must execute the package.** Only local packages are published (npm, PyPI, OCI, …). The registry never executes them, so tools are unknown until you run it.

## Connection (mcpServers)

```json
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp==0.14.4",
        "--account",
        "--user",
        "--password",
        "--warehouse",
        "--database",
        "--schema",
        "--role",
        "--authenticator",
        "--private_key_file",
        "--private_key_file_pwd",
        "--connections-file",
        "--connection-name",
        "--allow_write",
        "--prefetch",
        "--exclude_tools",
        "--exclude-json-results",
        "--log_dir",
        "--log_level",
        "INFO"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "${SNOWFLAKE_PASSWORD}",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "${SNOWFLAKE_PRIVATE_KEY_FILE_PWD}",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "${SNOWFLAKE_OAUTH_CLIENT_SECRET}",
        "SNOWFLAKE_TOKEN": "${SNOWFLAKE_TOKEN}"
      }
    }
  }
}
```

Placeholders to fill: `${SNOWFLAKE_PASSWORD}`, `${SNOWFLAKE_PRIVATE_KEY_FILE_PWD}`, `${SNOWFLAKE_OAUTH_CLIENT_SECRET}`, `${SNOWFLAKE_TOKEN}`.

## Trust

- hygiene: 95
- liveness: n/a
- freshness: 100
- provenance: 80
- drivers: +repository +namespace-matches-repo ~liveness-unmeasured +updated-26d-ago -unpinned-packages(1)
- Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed.

## Quality –/100 (not scored)

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

### protocol: n/a (weight 25)

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

### authorization: n/a (weight 15)

- n/a `auth.prm`, `auth.as_metadata`, `auth.cimd`: no remote uses OAuth
- n/a `auth.secret_in_url`: no templated URL

### tool hygiene: n/a (weight 30)

- n/a `tools.descriptions`, `tools.description_length`, `tools.schemas`, `tools.annotations`, `tools.directory_hints`, `tools.token_cost`, `tools.api_dump`: tool list unknown (behind auth, not probed, or empty)

### stability: n/a (weight 15)

- n/a `stability.changes`, `stability.rug_pull`: tool list unknown

### dependencies: 67 (weight 15)

- warn `deps.known_vulns`: 1 advisory of lower severity or without a published fix: GHSA-qqj6-54q6-cxv6 in snowflake-connector-python@4.7.2 (direct, fixed in 4.7.3)
- warn `deps.mcp_sdk_version`: mcp 1.28.1 has 1 known advisory of lower severity or without a fix (GHSA-84m7-p3x7-pcfv)
- pass `deps.resolvable`: mcp-snowflake-server-nsp@0.14.4 resolved: 60 packages

- tools: unknown
- badge: [![protogrid quality](https://protogrid.dev/badge/io.github.nsphung/mcp-snowflake-server.svg)](https://protogrid.dev/servers/io.github.nsphung/mcp-snowflake-server)
- Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed.

### Tool changes

_No tool definition changes recorded._

## Dependencies

- pypi mcp-snowflake-server-nsp@0.14.4: resolved, 59 dependencies, MCP SDK mcp 1.28.1
  - GHSA-84m7-p3x7-pcfv (moderate) in `` mcp@1.28.1 ``, direct, fixed in `` 1.30.0 ``, advisory summary: "MCP Python SDK: Unbounded Session Accumulation in StreamableHTTP Transport Enables Resource Exhaustion" https://osv.dev/vulnerability/GHSA-84m7-p3x7-pcfv
  - GHSA-qqj6-54q6-cxv6 (moderate) in `` snowflake-connector-python@4.7.2 ``, direct, fixed in `` 4.7.3 ``, advisory summary: "Snowflake drivers writes sensitive information to logs" https://osv.dev/vulnerability/GHSA-qqj6-54q6-cxv6

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0.

## Remotes

_none_

## Packages

- pypi mcp-snowflake-server-nsp@0.14.4 secrets: SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_TOKEN
- oci docker.io/nsphung/mcp-snowflake-server-nsp:0.14.4 secrets: SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_TOKEN

## Tools (0)

_none observed_