# 安装 Snowflake MCP Server

- 类型: MCP 工具
- 说明: 让 AI 助手连接 Snowflake，执行 SQL、浏览结构并提炼数据洞察。
- 仓库: https://github.com/nsphung/mcp-snowflake-server

## 方式一 · 一键代装（复制提示词让 AI 代劳）

### Claude Code
```
请帮我安装 askskill 上的 "Snowflake MCP Server" MCP 服务：
执行：claude mcp add 'io-github-nsphung-mcp-snowflake-server' -- uvx mcp-snowflake-server-nsp
```

### Codex
```
请帮我安装 askskill 上的 "Snowflake MCP Server" MCP 服务：
在 ~/.codex/config.toml 中添加：
[mcp_servers.io-github-nsphung-mcp-snowflake-server]
command = "uvx"
args = ["mcp-snowflake-server-nsp"]
然后重启 Codex 生效
```

### Cursor
```
请帮我安装 askskill 上的 "Snowflake MCP Server" MCP 服务：
在 .cursor/mcp.json 的 "mcpServers" 中添加：
"io-github-nsphung-mcp-snowflake-server": { "command": "uvx", "args": ["mcp-snowflake-server-nsp"] }
然后在 Cursor 设置 > MCP 中启用
```

## 方式二 · 命令行安装（原生命令与配置）

### Claude Code
```bash
claude mcp add --env SNOWFLAKE_ACCOUNT=YOUR_VALUE --env SNOWFLAKE_USER=YOUR_VALUE --env SNOWFLAKE_PASSWORD=YOUR_VALUE --env SNOWFLAKE_WAREHOUSE=YOUR_VALUE --env SNOWFLAKE_DATABASE=YOUR_VALUE --env SNOWFLAKE_SCHEMA=YOUR_VALUE --env SNOWFLAKE_ROLE=YOUR_VALUE --env SNOWFLAKE_AUTHENTICATOR=YOUR_VALUE --env SNOWFLAKE_PRIVATE_KEY_FILE=YOUR_VALUE --env SNOWFLAKE_PRIVATE_KEY_FILE_PWD=YOUR_VALUE --env SNOWFLAKE_OAUTH_CLIENT_ID=YOUR_VALUE --env SNOWFLAKE_OAUTH_CLIENT_SECRET=YOUR_VALUE --env SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL=YOUR_VALUE --env SNOWFLAKE_OAUTH_SCOPE=YOUR_VALUE --env SNOWFLAKE_TOKEN=YOUR_VALUE --transport stdio io-github-nsphung-mcp-snowflake-server -- uvx mcp-snowflake-server-nsp
```
需要环境变量：SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_ROLE, SNOWFLAKE_AUTHENTICATOR, SNOWFLAKE_PRIVATE_KEY_FILE, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_OAUTH_CLIENT_ID, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL, SNOWFLAKE_OAUTH_SCOPE, SNOWFLAKE_TOKEN

### Codex
```bash
codex mcp add --env SNOWFLAKE_ACCOUNT=YOUR_VALUE --env SNOWFLAKE_USER=YOUR_VALUE --env SNOWFLAKE_PASSWORD=YOUR_VALUE --env SNOWFLAKE_WAREHOUSE=YOUR_VALUE --env SNOWFLAKE_DATABASE=YOUR_VALUE --env SNOWFLAKE_SCHEMA=YOUR_VALUE --env SNOWFLAKE_ROLE=YOUR_VALUE --env SNOWFLAKE_AUTHENTICATOR=YOUR_VALUE --env SNOWFLAKE_PRIVATE_KEY_FILE=YOUR_VALUE --env SNOWFLAKE_PRIVATE_KEY_FILE_PWD=YOUR_VALUE --env SNOWFLAKE_OAUTH_CLIENT_ID=YOUR_VALUE --env SNOWFLAKE_OAUTH_CLIENT_SECRET=YOUR_VALUE --env SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL=YOUR_VALUE --env SNOWFLAKE_OAUTH_SCOPE=YOUR_VALUE --env SNOWFLAKE_TOKEN=YOUR_VALUE io-github-nsphung-mcp-snowflake-server -- uvx mcp-snowflake-server-nsp
```
配置文件 ~/.codex/config.toml：
```toml
[mcp_servers.io-github-nsphung-mcp-snowflake-server]
command = "uvx"
args = ["mcp-snowflake-server-nsp"]

[mcp_servers.io-github-nsphung-mcp-snowflake-server.env]
SNOWFLAKE_ACCOUNT = "YOUR_VALUE"
SNOWFLAKE_USER = "YOUR_VALUE"
SNOWFLAKE_PASSWORD = "YOUR_VALUE"
SNOWFLAKE_WAREHOUSE = "YOUR_VALUE"
SNOWFLAKE_DATABASE = "YOUR_VALUE"
SNOWFLAKE_SCHEMA = "YOUR_VALUE"
SNOWFLAKE_ROLE = "YOUR_VALUE"
SNOWFLAKE_AUTHENTICATOR = "YOUR_VALUE"
SNOWFLAKE_PRIVATE_KEY_FILE = "YOUR_VALUE"
SNOWFLAKE_PRIVATE_KEY_FILE_PWD = "YOUR_VALUE"
SNOWFLAKE_OAUTH_CLIENT_ID = "YOUR_VALUE"
SNOWFLAKE_OAUTH_CLIENT_SECRET = "YOUR_VALUE"
SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL = "YOUR_VALUE"
SNOWFLAKE_OAUTH_SCOPE = "YOUR_VALUE"
SNOWFLAKE_TOKEN = "YOUR_VALUE"
```
需要环境变量：SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_ROLE, SNOWFLAKE_AUTHENTICATOR, SNOWFLAKE_PRIVATE_KEY_FILE, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_OAUTH_CLIENT_ID, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL, SNOWFLAKE_OAUTH_SCOPE, SNOWFLAKE_TOKEN

### Cursor
配置文件 .cursor/mcp.json：
```json
{
  "mcpServers": {
    "io-github-nsphung-mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "YOUR_VALUE",
        "SNOWFLAKE_USER": "YOUR_VALUE",
        "SNOWFLAKE_PASSWORD": "YOUR_VALUE",
        "SNOWFLAKE_WAREHOUSE": "YOUR_VALUE",
        "SNOWFLAKE_DATABASE": "YOUR_VALUE",
        "SNOWFLAKE_SCHEMA": "YOUR_VALUE",
        "SNOWFLAKE_ROLE": "YOUR_VALUE",
        "SNOWFLAKE_AUTHENTICATOR": "YOUR_VALUE",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "YOUR_VALUE",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "YOUR_VALUE",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "YOUR_VALUE",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "YOUR_VALUE",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "YOUR_VALUE",
        "SNOWFLAKE_OAUTH_SCOPE": "YOUR_VALUE",
        "SNOWFLAKE_TOKEN": "YOUR_VALUE"
      }
    }
  }
}
```
一键安装：cursor://anysphere.cursor-deeplink/mcp/install?name=io-github-nsphung-mcp-snowflake-server&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJtY3Atc25vd2ZsYWtlLXNlcnZlci1uc3AiXSwiZW52Ijp7IlNOT1dGTEFLRV9BQ0NPVU5UIjoiWU9VUl9WQUxVRSIsIlNOT1dGTEFLRV9VU0VSIjoiWU9VUl9WQUxVRSIsIlNOT1dGTEFLRV9QQVNTV09SRCI6IllPVVJfVkFMVUUiLCJTTk9XRkxBS0VfV0FSRUhPVVNFIjoiWU9VUl9WQUxVRSIsIlNOT1dGTEFLRV9EQVRBQkFTRSI6IllPVVJfVkFMVUUiLCJTTk9XRkxBS0VfU0NIRU1BIjoiWU9VUl9WQUxVRSIsIlNOT1dGTEFLRV9ST0xFIjoiWU9VUl9WQUxVRSIsIlNOT1dGTEFLRV9BVVRIRU5USUNBVE9SIjoiWU9VUl9WQUxVRSIsIlNOT1dGTEFLRV9QUklWQVRFX0tFWV9GSUxFIjoiWU9VUl9WQUxVRSIsIlNOT1dGTEFLRV9QUklWQVRFX0tFWV9GSUxFX1BXRCI6IllPVVJfVkFMVUUiLCJTTk9XRkxBS0VfT0FVVEhfQ0xJRU5UX0lEIjoiWU9VUl9WQUxVRSIsIlNOT1dGTEFLRV9PQVVUSF9DTElFTlRfU0VDUkVUIjoiWU9VUl9WQUxVRSIsIlNOT1dGTEFLRV9PQVVUSF9UT0tFTl9SRVFVRVNUX1VSTCI6IllPVVJfVkFMVUUiLCJTTk9XRkxBS0VfT0FVVEhfU0NPUEUiOiJZT1VSX1ZBTFVFIiwiU05PV0ZMQUtFX1RPS0VOIjoiWU9VUl9WQUxVRSJ9fQ
需要环境变量：SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_ROLE, SNOWFLAKE_AUTHENTICATOR, SNOWFLAKE_PRIVATE_KEY_FILE, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_OAUTH_CLIENT_ID, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL, SNOWFLAKE_OAUTH_SCOPE, SNOWFLAKE_TOKEN