HotStack

← Back to browse

Snowflake MCP Server

Indexed by io.github.nsphung
View source ↗

About

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

Use this server

Add it to your MCP client. The catalogue lists this config verbatim from its source — it does not run, download, or vouch for the server. Review the command before you run it.

Transportstdio (runs a local command)
Env varsSNOWFLAKE_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
Claude Code 
claude mcp add --env SNOWFLAKE_ACCOUNT= --env SNOWFLAKE_USER= --env SNOWFLAKE_PASSWORD= --env SNOWFLAKE_WAREHOUSE= --env SNOWFLAKE_DATABASE= --env SNOWFLAKE_SCHEMA= --env SNOWFLAKE_ROLE= --env SNOWFLAKE_AUTHENTICATOR= --env SNOWFLAKE_PRIVATE_KEY_FILE= --env SNOWFLAKE_PRIVATE_KEY_FILE_PWD= --env SNOWFLAKE_OAUTH_CLIENT_ID= --env SNOWFLAKE_OAUTH_CLIENT_SECRET= --env SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL= --env SNOWFLAKE_OAUTH_SCOPE= --env SNOWFLAKE_TOKEN= mcp-snowflake-server -- uvx mcp-snowflake-server-nsp
Cursor

Add to Cursor

If the button doesn't open Cursor, use the JSON below — Cursor accepts the same mcpServers config.

VS Code 
code --add-mcp '{"name":"mcp-snowflake-server","command":"uvx","args":["mcp-snowflake-server-nsp"],"env":{"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":""}}'
JSON 
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ],
      "env": {
        "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": ""
      }
    }
  }
}

Environment variables are listed by name only — fill in your own values. Entries never carry secrets.