x=hub

your toolset

    build deployment
    sign in

    OSS Snowflake MCP Server

    mcpkey · package official
    io.github.Snowflake-Labs/mcp · v1.3.5
    deploy just this

    MCP Server for Snowflake from Snowflake Labs

    run it

    on your own machines, one way per deploy method
    generated from the record, not tested yet
    #!/usr/bin/env bash
# snowflake-labs (io.github.Snowflake-Labs/mcp), recipe baremetal (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-snowflake-labs.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec uvx mcp-proxy --host 127.0.0.1 --port 8101 --pass-environment -- uvx snowflake-labs-mcp==1.3.5

[Unit]
Description=MCP server snowflake-labs (toolset my-agent), generated by Hub
After=network-online.target
Wants=network-online.target

[Service]
Type=simple
User=mcp
Group=mcp
EnvironmentFile=/etc/mcp/my-agent.env
Environment=HOME=/var/lib/mcp/snowflake-labs
WorkingDirectory=/var/lib/mcp/snowflake-labs
ExecStart=/opt/mcp/my-agent/bin/snowflake-labs.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/snowflake-labs

[Install]
WantedBy=multi-user.target
    generated from the record, not tested yet
    docker run --rm -p 127.0.0.1:8101:8000 -e SNOWFLAKE_ACCOUNT -e SNOWFLAKE_HOST -e SNOWFLAKE_USER -e SNOWFLAKE_PASSWORD -e SNOWFLAKE_ROLE -e SNOWFLAKE_WAREHOUSE -e SNOWFLAKE_PASSCODE -e SNOWFLAKE_PRIVATE_KEY -e SNOWFLAKE_PRIVATE_KEY_FILE -e SNOWFLAKE_PRIVATE_KEY_FILE_PWD -e SNOWFLAKE_MCP_HOST -e SNOWFLAKE_MCP_PORT -e SNOWFLAKE_MCP_ENDPOINT ghcr.io/astral-sh/uv:python3.12-bookworm-slim sh -c 'uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx snowflake-labs-mcp==1.3.5'
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-17T22:03:47+00:00).
# Each package server runs behind a stdio->HTTP bridge and listens on localhost only.
#   cp .env.example .env    # fill the ${VAR}s
#   docker compose up -d && bash smoke.sh
# Remote servers are not here: clients reach them directly (see clients/).
name: mcp-my-agent
services:
  snowflake-labs:
    image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
    command:
    - sh
    - -c
    - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx snowflake-labs-mcp==1.3.5
    ports:
    - 127.0.0.1:8101:8000
    volumes:
    - uv-cache:/root/.cache/uv
    healthcheck:
      test:
      - CMD
      - python3
      - -c
      - import urllib.request; urllib.request.urlopen('http://127.0.0.1:8000/status')
      interval: 30s
      timeout: 5s
      retries: 5
      start_period: 2m
    restart: unless-stopped
    environment:
      SNOWFLAKE_ACCOUNT: ${SNOWFLAKE_ACCOUNT}
      SNOWFLAKE_HOST: ${SNOWFLAKE_HOST}
      SNOWFLAKE_USER: ${SNOWFLAKE_USER}
      SNOWFLAKE_PASSWORD: ${SNOWFLAKE_PASSWORD}
      SNOWFLAKE_ROLE: ${SNOWFLAKE_ROLE}
      SNOWFLAKE_WAREHOUSE: ${SNOWFLAKE_WAREHOUSE}
      SNOWFLAKE_PASSCODE: ${SNOWFLAKE_PASSCODE}
      SNOWFLAKE_PRIVATE_KEY: ${SNOWFLAKE_PRIVATE_KEY}
      SNOWFLAKE_PRIVATE_KEY_FILE: ${SNOWFLAKE_PRIVATE_KEY_FILE}
      SNOWFLAKE_PRIVATE_KEY_FILE_PWD: ${SNOWFLAKE_PRIVATE_KEY_FILE_PWD}
      SNOWFLAKE_MCP_HOST: ${SNOWFLAKE_MCP_HOST}
      SNOWFLAKE_MCP_PORT: ${SNOWFLAKE_MCP_PORT}
      SNOWFLAKE_MCP_ENDPOINT: ${SNOWFLAKE_MCP_ENDPOINT}
volumes:
  npm-cache: {}
  uv-cache: {}
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-17T22:03:47+00:00).
#   kubectl create namespace mcp
#   kubectl -n mcp create secret generic mcp-credentials --from-env-file=.env
#   kubectl apply -f kubernetes.yaml
# Services are cluster-internal: <name>.mcp.svc.cluster.local:8000/mcp. Put an ingress
# with auth in front before exposing any of them.
apiVersion: v1
kind: Namespace
metadata:
  name: mcp
---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: snowflake-labs
  namespace: mcp
  labels: &id001
    app: snowflake-labs
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: snowflake-labs
        image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: SNOWFLAKE_ACCOUNT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_ACCOUNT
        - name: SNOWFLAKE_HOST
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_HOST
        - name: SNOWFLAKE_USER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_USER
        - name: SNOWFLAKE_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_PASSWORD
        - name: SNOWFLAKE_ROLE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_ROLE
        - name: SNOWFLAKE_WAREHOUSE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_WAREHOUSE
        - name: SNOWFLAKE_PASSCODE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_PASSCODE
        - name: SNOWFLAKE_PRIVATE_KEY
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_PRIVATE_KEY
        - name: SNOWFLAKE_PRIVATE_KEY_FILE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_PRIVATE_KEY_FILE
        - name: SNOWFLAKE_PRIVATE_KEY_FILE_PWD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_PRIVATE_KEY_FILE_PWD
        - name: SNOWFLAKE_MCP_HOST
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_MCP_HOST
        - name: SNOWFLAKE_MCP_PORT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_MCP_PORT
        - name: SNOWFLAKE_MCP_ENDPOINT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_MCP_ENDPOINT
        command:
        - sh
        - -c
        - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx snowflake-labs-mcp==1.3.5
        readinessProbe:
          httpGet:
            path: /status
            port: http
          initialDelaySeconds: 10
---
apiVersion: v1
kind: Service
metadata:
  name: snowflake-labs
  namespace: mcp
spec:
  selector:
    app: snowflake-labs
  ports:
  - port: 8000
    targetPort: http
    name: http
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-17T22:03:47+00:00).
# Credentials come from the Secret 'mcp-credentials' (kubectl create secret generic ... --from-env-file=.env).
# Each server under `servers` is one Deployment + Service; the keys after it configure
# upstream charts a worker verified.
servers:
  snowflake-labs:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: snowflake-labs
      image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: SNOWFLAKE_ACCOUNT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_ACCOUNT
      - name: SNOWFLAKE_HOST
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_HOST
      - name: SNOWFLAKE_USER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_USER
      - name: SNOWFLAKE_PASSWORD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_PASSWORD
      - name: SNOWFLAKE_ROLE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_ROLE
      - name: SNOWFLAKE_WAREHOUSE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_WAREHOUSE
      - name: SNOWFLAKE_PASSCODE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_PASSCODE
      - name: SNOWFLAKE_PRIVATE_KEY
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_PRIVATE_KEY
      - name: SNOWFLAKE_PRIVATE_KEY_FILE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_PRIVATE_KEY_FILE
      - name: SNOWFLAKE_PRIVATE_KEY_FILE_PWD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_PRIVATE_KEY_FILE_PWD
      - name: SNOWFLAKE_MCP_HOST
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_MCP_HOST
      - name: SNOWFLAKE_MCP_PORT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_MCP_PORT
      - name: SNOWFLAKE_MCP_ENDPOINT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_MCP_ENDPOINT
      command:
      - sh
      - -c
      - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx snowflake-labs-mcp==1.3.5
      readinessProbe:
        httpGet:
          path: /status
          port: http
        initialDelaySeconds: 10

# helm install my-agent helm/my-agent -n mcp

    in the cloud

    one click: the provider's deploy form opens filled in, in your own account
    koyeb
    deploy to koyeb

    The form opens with CHANGE_ME for each value you supply: SNOWFLAKE_ACCOUNT, SNOWFLAKE_HOST, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_ROLE, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_PASSCODE, SNOWFLAKE_PRIVATE_KEY, SNOWFLAKE_PRIVATE_KEY_FILE, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_MCP_HOST, SNOWFLAKE_MCP_PORT, SNOWFLAKE_MCP_ENDPOINT. Fill them in before you deploy.

    Clients connect to the service's https://…koyeb.app address plus /mcp.

    azure
    deploy to azuretemplate

    A Container Apps environment with one app per server, each with HTTPS ingress and one replica. The portal asks for each value you supply as a secure parameter; the deployment's outputs list the endpoints.

    connect to it

    copy what your client needs
    uvx snowflake-labs-mcp==1.3.5
# env: SNOWFLAKE_ACCOUNT, SNOWFLAKE_HOST, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_ROLE, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_PASSCODE, SNOWFLAKE_PRIVATE_KEY, SNOWFLAKE_PRIVATE_KEY_FILE, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_MCP_HOST, SNOWFLAKE_MCP_PORT, SNOWFLAKE_MCP_ENDPOINT
    {
  "mcpServers": {
    "snowflake-labs": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp==1.3.5"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "${SNOWFLAKE_ACCOUNT}",
        "SNOWFLAKE_HOST": "${SNOWFLAKE_HOST}",
        "SNOWFLAKE_USER": "${SNOWFLAKE_USER}",
        "SNOWFLAKE_PASSWORD": "${SNOWFLAKE_PASSWORD}",
        "SNOWFLAKE_ROLE": "${SNOWFLAKE_ROLE}",
        "SNOWFLAKE_WAREHOUSE": "${SNOWFLAKE_WAREHOUSE}",
        "SNOWFLAKE_PASSCODE": "${SNOWFLAKE_PASSCODE}",
        "SNOWFLAKE_PRIVATE_KEY": "${SNOWFLAKE_PRIVATE_KEY}",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "${SNOWFLAKE_PRIVATE_KEY_FILE}",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "${SNOWFLAKE_PRIVATE_KEY_FILE_PWD}",
        "SNOWFLAKE_MCP_HOST": "${SNOWFLAKE_MCP_HOST}",
        "SNOWFLAKE_MCP_PORT": "${SNOWFLAKE_MCP_PORT}",
        "SNOWFLAKE_MCP_ENDPOINT": "${SNOWFLAKE_MCP_ENDPOINT}"
      }
    }
  }
}
    #!/usr/bin/env bash
# Registers every server with Claude Code (run once; `claude mcp list` to check).
set -euo pipefail
set -a; [ -f .env ] && source .env; set +a
claude mcp add snowflake-labs -e "SNOWFLAKE_ACCOUNT=${SNOWFLAKE_ACCOUNT}" -e "SNOWFLAKE_HOST=${SNOWFLAKE_HOST}" -e "SNOWFLAKE_USER=${SNOWFLAKE_USER}" -e "SNOWFLAKE_PASSWORD=${SNOWFLAKE_PASSWORD}" -e "SNOWFLAKE_ROLE=${SNOWFLAKE_ROLE}" -e "SNOWFLAKE_WAREHOUSE=${SNOWFLAKE_WAREHOUSE}" -e "SNOWFLAKE_PASSCODE=${SNOWFLAKE_PASSCODE}" -e "SNOWFLAKE_PRIVATE_KEY=${SNOWFLAKE_PRIVATE_KEY}" -e "SNOWFLAKE_PRIVATE_KEY_FILE=${SNOWFLAKE_PRIVATE_KEY_FILE}" -e "SNOWFLAKE_PRIVATE_KEY_FILE_PWD=${SNOWFLAKE_PRIVATE_KEY_FILE_PWD}" -e "SNOWFLAKE_MCP_HOST=${SNOWFLAKE_MCP_HOST}" -e "SNOWFLAKE_MCP_PORT=${SNOWFLAKE_MCP_PORT}" -e "SNOWFLAKE_MCP_ENDPOINT=${SNOWFLAKE_MCP_ENDPOINT}" -- uvx snowflake-labs-mcp==1.3.5

    {
  "mcpServers": {
    "snowflake-labs": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp==1.3.5"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "${SNOWFLAKE_ACCOUNT}",
        "SNOWFLAKE_HOST": "${SNOWFLAKE_HOST}",
        "SNOWFLAKE_USER": "${SNOWFLAKE_USER}",
        "SNOWFLAKE_PASSWORD": "${SNOWFLAKE_PASSWORD}",
        "SNOWFLAKE_ROLE": "${SNOWFLAKE_ROLE}",
        "SNOWFLAKE_WAREHOUSE": "${SNOWFLAKE_WAREHOUSE}",
        "SNOWFLAKE_PASSCODE": "${SNOWFLAKE_PASSCODE}",
        "SNOWFLAKE_PRIVATE_KEY": "${SNOWFLAKE_PRIVATE_KEY}",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "${SNOWFLAKE_PRIVATE_KEY_FILE}",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "${SNOWFLAKE_PRIVATE_KEY_FILE_PWD}",
        "SNOWFLAKE_MCP_HOST": "${SNOWFLAKE_MCP_HOST}",
        "SNOWFLAKE_MCP_PORT": "${SNOWFLAKE_MCP_PORT}",
        "SNOWFLAKE_MCP_ENDPOINT": "${SNOWFLAKE_MCP_ENDPOINT}"
      }
    }
  }
}
    {
  "servers": {
    "snowflake-labs": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp==1.3.5"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "${SNOWFLAKE_ACCOUNT}",
        "SNOWFLAKE_HOST": "${SNOWFLAKE_HOST}",
        "SNOWFLAKE_USER": "${SNOWFLAKE_USER}",
        "SNOWFLAKE_PASSWORD": "${SNOWFLAKE_PASSWORD}",
        "SNOWFLAKE_ROLE": "${SNOWFLAKE_ROLE}",
        "SNOWFLAKE_WAREHOUSE": "${SNOWFLAKE_WAREHOUSE}",
        "SNOWFLAKE_PASSCODE": "${SNOWFLAKE_PASSCODE}",
        "SNOWFLAKE_PRIVATE_KEY": "${SNOWFLAKE_PRIVATE_KEY}",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "${SNOWFLAKE_PRIVATE_KEY_FILE}",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "${SNOWFLAKE_PRIVATE_KEY_FILE_PWD}",
        "SNOWFLAKE_MCP_HOST": "${SNOWFLAKE_MCP_HOST}",
        "SNOWFLAKE_MCP_PORT": "${SNOWFLAKE_MCP_PORT}",
        "SNOWFLAKE_MCP_ENDPOINT": "${SNOWFLAKE_MCP_ENDPOINT}"
      }
    }
  }
}
    name: my-agent
target: local
servers:
- hub: io.github.Snowflake-Labs/mcp
    • not probed yet: tools unpinned, ingest lists them

    tools

    Probe result: faileddocker: the container exited: ^ | File "<path>", line 306, in send_request | raise McpError(response_or_error.error) | mcp.shared.exceptions.McpError: Connection closed +------------------------------------; baremetal: MCPError: Connection closed; server stderr: …line 210, in __aenter__ return await anext(self.gen) ^^^^^^^^^^^^^^^^^^^^^ File "<path>", line 533, in create_snowflake_service snowflake_service = SnowflakeService( ^^^^^^^^^^^^^^^^^ File "<path>", line 112, in __init__ raise ValueErr…

    runs · 1

    the latest tests of this entry by the hub and its workers, newest first
    dateworkermethodstatussandboxreason
    2026-10-17 12:30 local-mac-vm docker failed gvisor docker: the container exited: ^ | File "<path>", line 306, in send_request | raise McpError(response_or_error.error) | mcp.shared.exceptions.McpError: Connectio…