AgentHubAgentHub

Snowflake MCP Server

MCP ServerMCP Registry官方收录

io.github.nsphung/mcp-snowflake-server · v0.13.0

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

概览

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

安装

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

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ]
    }
  }
}

环境变量

SNOWFLAKE_ACCOUNT可选

Snowflake account identifier

SNOWFLAKE_USER可选

Snowflake username

SNOWFLAKE_PASSWORD可选secret

Password (not required for key-pair / SSO)

SNOWFLAKE_WAREHOUSE可选

Virtual warehouse to use

SNOWFLAKE_DATABASE可选

Default database

SNOWFLAKE_SCHEMA可选

Default schema

SNOWFLAKE_ROLE可选

Role to assume

SNOWFLAKE_AUTHENTICATOR可选

Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials

SNOWFLAKE_PRIVATE_KEY_FILE可选

Absolute path to .p8 private key file

SNOWFLAKE_PRIVATE_KEY_FILE_PWD可选secret

Passphrase for encrypted private key

SNOWFLAKE_OAUTH_CLIENT_ID可选

OAuth 2.0 client ID (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_CLIENT_SECRET可选secret

OAuth 2.0 client secret (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL可选

OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_SCOPE可选

OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)

SNOWFLAKE_TOKEN可选secret

Pre-fetched OAuth bearer token (required for oauth authenticator)

SNOWFLAKE_ACCOUNT可选

Snowflake account identifier

SNOWFLAKE_USER可选

Snowflake username

SNOWFLAKE_PASSWORD可选secret

Password (not required for key-pair / SSO)

SNOWFLAKE_WAREHOUSE可选

Virtual warehouse to use

SNOWFLAKE_DATABASE可选

Default database

SNOWFLAKE_SCHEMA可选

Default schema

SNOWFLAKE_ROLE可选

Role to assume

SNOWFLAKE_AUTHENTICATOR可选

Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials

SNOWFLAKE_PRIVATE_KEY_FILE可选

Absolute path to .p8 private key file

SNOWFLAKE_PRIVATE_KEY_FILE_PWD可选secret

Passphrase for encrypted private key

SNOWFLAKE_OAUTH_CLIENT_ID可选

OAuth 2.0 client ID (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_CLIENT_SECRET可选secret

OAuth 2.0 client secret (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL可选

OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_SCOPE可选

OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)

SNOWFLAKE_TOKEN可选secret

Pre-fetched OAuth bearer token (required for oauth authenticator)

相关资源

统一 Manifest

{
  "id": "io.github.nsphung/mcp-snowflake-server",
  "type": "mcp-server",
  "version": "0.13.0",
  "displayName": "Snowflake MCP Server",
  "description": "A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants",
  "repository": {
    "url": "https://github.com/nsphung/mcp-snowflake-server",
    "source": "github"
  },
  "distribution": {
    "packages": [
      {
        "registryType": "pypi",
        "identifier": "mcp-snowflake-server-nsp",
        "version": "0.13.0",
        "runtimeHint": "uvx",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "SNOWFLAKE_ACCOUNT",
            "description": "Snowflake account identifier"
          },
          {
            "name": "SNOWFLAKE_USER",
            "description": "Snowflake username"
          },
          {
            "name": "SNOWFLAKE_PASSWORD",
            "description": "Password (not required for key-pair / SSO)",
            "isSecret": true
          },
          {
            "name": "SNOWFLAKE_WAREHOUSE",
            "description": "Virtual warehouse to use"
          },
          {
            "name": "SNOWFLAKE_DATABASE",
            "description": "Default database"
          },
          {
            "name": "SNOWFLAKE_SCHEMA",
            "description": "Default schema"
          },
          {
            "name": "SNOWFLAKE_ROLE",
            "description": "Role to assume"
          },
          {
            "name": "SNOWFLAKE_AUTHENTICATOR",
            "description": "Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials"
          },
          {
            "name": "SNOWFLAKE_PRIVATE_KEY_FILE",
            "description": "Absolute path to .p8 private key file"
          },
          {
            "name": "SNOWFLAKE_PRIVATE_KEY_FILE_PWD",
            "description": "Passphrase for encrypted private key",
            "isSecret": true
          },
          {
            "name": "SNOWFLAKE_OAUTH_CLIENT_ID",
            "description": "OAuth 2.0 client ID (required for oauth_client_credentials authenticator)"
          },
          {
            "name": "SNOWFLAKE_OAUTH_CLIENT_SECRET",
            "description": "OAuth 2.0 client secret (required for oauth_client_credentials authenticator)",
            "isSecret": true
          },
          {
            "name": "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL",
            "description": "OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)"
          },
          {
            "name": "SNOWFLAKE_OAUTH_SCOPE",
            "description": "OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)"
          },
          {
            "name": "SNOWFLAKE_TOKEN",
            "description": "Pre-fetched OAuth bearer token (required for oauth authenticator)",
            "isSecret": true
          }
        ]
      },
      {
        "registryType": "oci",
        "identifier": "docker.io/nsphung/mcp-snowflake-server-nsp:0.13.0",
        "runtimeHint": "docker",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "SNOWFLAKE_ACCOUNT",
            "description": "Snowflake account identifier"
          },
          {
            "name": "SNOWFLAKE_USER",
            "description": "Snowflake username"
          },
          {
            "name": "SNOWFLAKE_PASSWORD",
            "description": "Password (not required for key-pair / SSO)",
            "isSecret": true
          },
          {
            "name": "SNOWFLAKE_WAREHOUSE",
            "description": "Virtual warehouse to use"
          },
          {
            "name": "SNOWFLAKE_DATABASE",
            "description": "Default database"
          },
          {
            "name": "SNOWFLAKE_SCHEMA",
            "description": "Default schema"
          },
          {
            "name": "SNOWFLAKE_ROLE",
            "description": "Role to assume"
          },
          {
            "name": "SNOWFLAKE_AUTHENTICATOR",
            "description": "Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials"
          },
          {
            "name": "SNOWFLAKE_PRIVATE_KEY_FILE",
            "description": "Absolute path to .p8 private key file"
          },
          {
            "name": "SNOWFLAKE_PRIVATE_KEY_FILE_PWD",
            "description": "Passphrase for encrypted private key",
            "isSecret": true
          },
          {
            "name": "SNOWFLAKE_OAUTH_CLIENT_ID",
            "description": "OAuth 2.0 client ID (required for oauth_client_credentials authenticator)"
          },
          {
            "name": "SNOWFLAKE_OAUTH_CLIENT_SECRET",
            "description": "OAuth 2.0 client secret (required for oauth_client_credentials authenticator)",
            "isSecret": true
          },
          {
            "name": "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL",
            "description": "OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)"
          },
          {
            "name": "SNOWFLAKE_OAUTH_SCOPE",
            "description": "OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)"
          },
          {
            "name": "SNOWFLAKE_TOKEN",
            "description": "Pre-fetched OAuth bearer token (required for oauth authenticator)",
            "isSecret": true
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.nsphung/mcp-snowflake-server",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.nsphung%2Fmcp-snowflake-server/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}
Snowflake MCP Server — MCP Server 安装与配置 · AgentHub