PluginBench
MCP Server
Active
MIT

Snowflake MCP Server MCP Server

io.github.nsphung/mcp-snowflake-server

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

What is the Snowflake MCP Server MCP server?

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

How to install Snowflake MCP Server

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • SNOWFLAKE_ACCOUNT

    Snowflake account identifier

  • SNOWFLAKE_USER

    Snowflake username

  • SNOWFLAKE_PASSWORD
    secret

    Password (not required for key-pair / SSO)

  • SNOWFLAKE_WAREHOUSE

    Virtual warehouse to use

  • SNOWFLAKE_DATABASE

    Default database

  • SNOWFLAKE_SCHEMA

    Default schema

  • SNOWFLAKE_ROLE

    Role to assume

  • SNOWFLAKE_AUTHENTICATOR

    Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials

  • SNOWFLAKE_PRIVATE_KEY_FILE

    Absolute path to .p8 private key file

  • SNOWFLAKE_PRIVATE_KEY_FILE_PWD
    secret

    Passphrase for encrypted private key

  • SNOWFLAKE_OAUTH_CLIENT_ID

    OAuth 2.0 client ID (required for oauth_client_credentials authenticator)

  • SNOWFLAKE_OAUTH_CLIENT_SECRET
    secret

    OAuth 2.0 client secret (required for oauth_client_credentials authenticator)

  • SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL

    OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)

  • SNOWFLAKE_OAUTH_SCOPE

    OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)

  • SNOWFLAKE_TOKEN
    secret

    Pre-fetched OAuth bearer token (required for oauth authenticator)

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp",
        "--account",
        "--user",
        "--password",
        "--warehouse",
        "--database",
        "--schema",
        "--role",
        "--authenticator",
        "--private_key_file",
        "--private_key_file_pwd",
        "--connections-file",
        "--connection-name",
        "--allow_write",
        "--prefetch",
        "--exclude_tools",
        "--exclude-json-results",
        "--log_dir",
        "--log_level"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<YOUR_SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<YOUR_SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_DATABASE": "<YOUR_SNOWFLAKE_DATABASE>",
        "SNOWFLAKE_SCHEMA": "<YOUR_SNOWFLAKE_SCHEMA>",
        "SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>",
        "SNOWFLAKE_AUTHENTICATOR": "<YOUR_SNOWFLAKE_AUTHENTICATOR>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE_PWD>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_ID>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_SECRET>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<YOUR_SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL>",
        "SNOWFLAKE_OAUTH_SCOPE": "<YOUR_SNOWFLAKE_OAUTH_SCOPE>",
        "SNOWFLAKE_TOKEN": "<YOUR_SNOWFLAKE_TOKEN>"
      }
    }
  }
}

Related MCP servers

Quipu API integration with 18 MCP tools for invoices, expenses, contacts and Spanish VAT reporting

0
TypeScript
MIT
View repository →
DYDynoxide logo

Dynoxide

Active

Fast DynamoDB emulator with 35 MCP tools for testing and local development without JVM overhead.

83
Rust
Apache-2.0
View repository →

Bulgarian pension fund analytics — NAV data, metrics, rankings, and benchmarks.

0
MIT
View repository →
NVNVEIL logo

NVEIL

Maintained

Data processing and visualization toolkit — 50+ chart types, raw data stays local.

2
Python
AGPL-3.0
View repository →

Read Sudhanva Narayana's public profile, production ML case studies, and technical writing.

View repository →
SESemiotic logo

Semiotic

Active

AI-first React chart library with network graphs, streaming data, and MCP server for verified visualization generation.

2.7k
TypeScript
Apache-2.0
View repository →