MCP Snowflake Server NSP - A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants
接入配置
选择客户端,复制配置,再按项目文档补齐环境变量。
claude mcp add snowflake-server-nsphung --env SNOWFLAKE_PASSWORD='<SNOWFLAKE_PASSWORD>' --env SNOWFLAKE_PRIVATE_KEY_FILE_PWD='<SNOWFLAKE_PRIVATE_KEY_FILE_PWD>' --env SNOWFLAKE_OAUTH_CLIENT_SECRET='<SNOWFLAKE_OAUTH_CLIENT_SECRET>' --env SNOWFLAKE_TOKEN='<SNOWFLAKE_TOKEN>' -- uvx mcp-snowflake-server-nsp~/.codex/config.toml
[mcp_servers.snowflake-server-nsphung]
command = "uvx"
args = ["mcp-snowflake-server-nsp"]
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>" }
# codex mcp add snowflake-server-nsphung --env SNOWFLAKE_PASSWORD='<SNOWFLAKE_PASSWORD>' --env SNOWFLAKE_PRIVATE_KEY_FILE_PWD='<SNOWFLAKE_PRIVATE_KEY_FILE_PWD>' --env SNOWFLAKE_OAUTH_CLIENT_SECRET='<SNOWFLAKE_OAUTH_CLIENT_SECRET>' --env SNOWFLAKE_TOKEN='<SNOWFLAKE_TOKEN>' -- uvx mcp-snowflake-server-nsp~/.cursor/mcp.json
{
"mcpServers": {
"snowflake-server-nsphung": {
"command": "uvx",
"args": [
"mcp-snowflake-server-nsp"
],
"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>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"snowflake-server-nsphung": {
"type": "stdio",
"command": "uvx",
"args": [
"mcp-snowflake-server-nsp"
],
"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>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"snowflake-server-nsphung": {
"command": "uvx",
"args": [
"mcp-snowflake-server-nsp"
],
"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>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"snowflake-server-nsphung": {
"command": "uvx",
"args": [
"mcp-snowflake-server-nsp"
],
"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>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"snowflake-server-nsphung": {
"command": "uvx",
"args": [
"mcp-snowflake-server-nsp"
],
"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>"
}
}
}
}需要的环境变量
SNOWFLAKE_PASSWORDSNOWFLAKE_PRIVATE_KEY_FILE_PWDSNOWFLAKE_OAUTH_CLIENT_SECRETSNOWFLAKE_TOKEN
把占位值换成你自己的密钥;不要把密钥提交到代码仓库。