Skip to content
MCP server

Snowflake MCP Server

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

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
0.14.5
Listing updated
4 days ago

About Snowflake MCP Server

Snowflake MCP Server is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

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

Install

Run in a terminal

claude mcp add mcp-snowflake-server --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

Add to claude_desktop_config.json

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "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>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "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>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "mcp-snowflake-server": {
      "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>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "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>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "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>"
      }
    }
  }
}

Configuration

  • SNOWFLAKE_ACCOUNTSnowflake account identifier
  • SNOWFLAKE_USERSnowflake username
  • SNOWFLAKE_PASSWORDPassword (not required for key-pair / SSO)
  • SNOWFLAKE_WAREHOUSEVirtual warehouse to use
  • SNOWFLAKE_DATABASEDefault database
  • SNOWFLAKE_SCHEMADefault schema
  • SNOWFLAKE_ROLERole to assume
  • SNOWFLAKE_AUTHENTICATORAuthentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials
  • SNOWFLAKE_PRIVATE_KEY_FILEAbsolute path to .p8 private key file
  • SNOWFLAKE_PRIVATE_KEY_FILE_PWDPassphrase for encrypted private key
  • SNOWFLAKE_OAUTH_CLIENT_IDOAuth 2.0 client ID (required for oauth_client_credentials authenticator)
  • SNOWFLAKE_OAUTH_CLIENT_SECRETOAuth 2.0 client secret (required for oauth_client_credentials authenticator)
  • SNOWFLAKE_OAUTH_TOKEN_REQUEST_URLOAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)
  • SNOWFLAKE_OAUTH_SCOPEOAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)
  • SNOWFLAKE_TOKENPre-fetched OAuth bearer token (required for oauth authenticator)
  • SNOWFLAKE_ACCOUNTSnowflake account identifier
  • SNOWFLAKE_USERSnowflake username
  • SNOWFLAKE_PASSWORDPassword (not required for key-pair / SSO)
  • SNOWFLAKE_WAREHOUSEVirtual warehouse to use
  • SNOWFLAKE_DATABASEDefault database
  • SNOWFLAKE_SCHEMADefault schema
  • SNOWFLAKE_ROLERole to assume
  • SNOWFLAKE_AUTHENTICATORAuthentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials
  • SNOWFLAKE_PRIVATE_KEY_FILEAbsolute path to .p8 private key file
  • SNOWFLAKE_PRIVATE_KEY_FILE_PWDPassphrase for encrypted private key
  • SNOWFLAKE_OAUTH_CLIENT_IDOAuth 2.0 client ID (required for oauth_client_credentials authenticator)
  • SNOWFLAKE_OAUTH_CLIENT_SECRETOAuth 2.0 client secret (required for oauth_client_credentials authenticator)
  • SNOWFLAKE_OAUTH_TOKEN_REQUEST_URLOAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)
  • SNOWFLAKE_OAUTH_SCOPEOAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)
  • SNOWFLAKE_TOKENPre-fetched OAuth bearer token (required for oauth authenticator)

Pricing

Open source

Snowflake MCP Server FAQ

Is Snowflake MCP Server free?

Yes. Snowflake MCP Server is open source, so you can use and self-host it for free.

How do I add Snowflake MCP Server to Claude Code?

Run this command in your terminal: claude mcp add mcp-snowflake-server --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

What are the best alternatives to Snowflake MCP Server?

The closest alternatives to Snowflake MCP Server are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.

Alternatives to Snowflake MCP Server

  1. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  2. PlatypusDB

    MCP server

    Gives MCP clients access to your PlatypusDB database connections, scoped per agent

    Runs locally
    • Open source
    • Databases
  3. Lorebase

    MCP server

    Lets agents read and change a governed, versioned Postgres knowledge graph

    Runs locally
    • Open source
    • Knowledge and memory
  4. Sovaria

    MCP server

    Manage a Sovaria backend (Postgres, auth, storage, functions) from an AI assistant

    Not checked yet
    • 4 tools
    • Remote
    • Freemium
    • Databases
  5. Generate realistic connected test data, dbt projects and dashboards from a schema

    • Remote
    • Freemium
    • Databases
  6. semlayer

    MCP server

    Infers a semantic layer from your data warehouse and serves it to agents

    Runs locally
    • Free
    • Databases