Snowflake MCP Server

Name: Snowflake MCP Server
Author: Snowflake Labs

Snowflake Labs官方

Snowflake server for Cortex Agents, structured and unstructured data queries, SQL execution, object management and semantic views.

接入配置

选择客户端，复制配置，再按项目文档补齐环境变量。

一键添加到 Cursor 一键添加到 VS Code

claude mcp add snowflake --env SNOWFLAKE_PASSWORD='<SNOWFLAKE_PASSWORD>' --env SNOWFLAKE_PRIVATE_KEY='<SNOWFLAKE_PRIVATE_KEY>' --env SNOWFLAKE_PAT='<SNOWFLAKE_PAT>' --env SNOWFLAKE_ACCOUNT='<SNOWFLAKE_ACCOUNT>' --env SNOWFLAKE_USER='<SNOWFLAKE_USER>' --env SERVICE_CONFIG_FILE='<SERVICE_CONFIG_FILE>' -- uvx snowflake-labs-mcp --service-config-file '<SERVICE_CONFIG_FILE>'

~/.codex/config.toml

[mcp_servers.snowflake]
command = "uvx"
args = ["snowflake-labs-mcp", "--service-config-file", "<SERVICE_CONFIG_FILE>"]
env = { SNOWFLAKE_PASSWORD = "<SNOWFLAKE_PASSWORD>", SNOWFLAKE_PRIVATE_KEY = "<SNOWFLAKE_PRIVATE_KEY>", SNOWFLAKE_PAT = "<SNOWFLAKE_PAT>", SNOWFLAKE_ACCOUNT = "<SNOWFLAKE_ACCOUNT>", SNOWFLAKE_USER = "<SNOWFLAKE_USER>", SERVICE_CONFIG_FILE = "<SERVICE_CONFIG_FILE>" }

# codex mcp add snowflake --env SNOWFLAKE_PASSWORD='<SNOWFLAKE_PASSWORD>' --env SNOWFLAKE_PRIVATE_KEY='<SNOWFLAKE_PRIVATE_KEY>' --env SNOWFLAKE_PAT='<SNOWFLAKE_PAT>' --env SNOWFLAKE_ACCOUNT='<SNOWFLAKE_ACCOUNT>' --env SNOWFLAKE_USER='<SNOWFLAKE_USER>' --env SERVICE_CONFIG_FILE='<SERVICE_CONFIG_FILE>' -- uvx snowflake-labs-mcp --service-config-file '<SERVICE_CONFIG_FILE>'

~/.cursor/mcp.json

{
  "mcpServers": {
    "snowflake": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<SERVICE_CONFIG_FILE>"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_PRIVATE_KEY": "<SNOWFLAKE_PRIVATE_KEY>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SERVICE_CONFIG_FILE": "<SERVICE_CONFIG_FILE>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "snowflake": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<SERVICE_CONFIG_FILE>"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_PRIVATE_KEY": "<SNOWFLAKE_PRIVATE_KEY>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SERVICE_CONFIG_FILE": "<SERVICE_CONFIG_FILE>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "snowflake": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<SERVICE_CONFIG_FILE>"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_PRIVATE_KEY": "<SNOWFLAKE_PRIVATE_KEY>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SERVICE_CONFIG_FILE": "<SERVICE_CONFIG_FILE>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "snowflake": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<SERVICE_CONFIG_FILE>"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_PRIVATE_KEY": "<SNOWFLAKE_PRIVATE_KEY>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SERVICE_CONFIG_FILE": "<SERVICE_CONFIG_FILE>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "snowflake": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<SERVICE_CONFIG_FILE>"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_PRIVATE_KEY": "<SNOWFLAKE_PRIVATE_KEY>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SERVICE_CONFIG_FILE": "<SERVICE_CONFIG_FILE>"
      }
    }
  }
}

需要的环境变量

SNOWFLAKE_PASSWORD
SNOWFLAKE_PRIVATE_KEY
SNOWFLAKE_PAT
SNOWFLAKE_ACCOUNT
SNOWFLAKE_USER
SERVICE_CONFIG_FILE

把占位值换成你自己的密钥；不要把密钥提交到代码仓库。

接入配置

需要的环境变量

相关推荐