Skip to main content
On this page

adk-mcp-snowflake

Snowflake MCP via uvx (Snowflake-Labs/mcp). Read-only by default (per shared/constitution.md §I.6). Config: account/user/warehouse/role live in Snowflake’s native connections.toml under SNOWFLAKE_SERVICE_CONFIG_FILE points at the snowflake-labs-mcp service YAML (tool allow-list, Cortex services). Auth: Programmatic Access Token in $SNOWFLAKE_ACCESS_TOKEN_CRED (shell env only, never on disk) — passed via —password, overrides any password in connections.toml. See SETUP.md.

Source

mcp/adk-mcp-snowflake.json

Environment variables referenced

  • SNOWFLAKE_ACCESS_TOKEN_CRED
  • SNOWFLAKE_CONNECTION_NAME
  • SNOWFLAKE_HOME
  • SNOWFLAKE_SERVICE_CONFIG_FILE

Configuration

JSON
{  "name": "adk-mcp-snowflake",  "command": "sh",  "args": [    "-c",    "exec uvx snowflake-labs-mcp@latest --connection-name \"${SNOWFLAKE_CONNECTION_NAME:-adk}\" --password \"$SNOWFLAKE_ACCESS_TOKEN_CRED\" --service-config-file \"$SNOWFLAKE_SERVICE_CONFIG_FILE\""  ],  "env": {    "SNOWFLAKE_HOME": "${SNOWFLAKE_HOME}",    "SNOWFLAKE_CONNECTION_NAME": "${SNOWFLAKE_CONNECTION_NAME:-adk}",    "SNOWFLAKE_SERVICE_CONFIG_FILE": "${SNOWFLAKE_SERVICE_CONFIG_FILE}",    "SNOWFLAKE_ACCESS_TOKEN_CRED": "${SNOWFLAKE_ACCESS_TOKEN_CRED}"  },  "description": "Snowflake MCP via uvx (Snowflake-Labs/mcp). Read-only by default (per shared/constitution.md §I.6). Config: account/user/warehouse/role live in Snowflake's native connections.toml under $SNOWFLAKE_HOME (default ~/.snowflake), selected by --connection-name. $SNOWFLAKE_SERVICE_CONFIG_FILE points at the snowflake-labs-mcp service YAML (tool allow-list, Cortex services). Auth: Programmatic Access Token in $SNOWFLAKE_ACCESS_TOKEN_CRED (shell env only, never on disk) — passed via --password, overrides any password in connections.toml. See SETUP.md."}