InnerVault

Snowflake MCP Server

IndexedOfficial MCP Registry, io.github.nsphung

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

Open the source (opens github.com) https://github.com/nsphung/mcp-snowflake-server

Before you use it

  • Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
  • Needs credentials: SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_TOKEN. Use a key with the least access you can.

What it is

MCP servers from io.github.nsphung.

The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.

How to get it

pypi package (stdio)

mcp-snowflake-server-nsp@0.14.5

From the server's entry in the official MCP Registry

oci package (stdio)

docker.io/nsphung/mcp-snowflake-server-nsp:0.14.5

From the server's entry in the official MCP Registry

Settings it asks for

  • 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)

Related

  1. MCP Server for Snowflake from Snowflake Labs

    Stale Official MCP Registry, io.github.Snowflake-Labs Updated 12 months ago 2 notes

    snowflake-labs-mcp@1.3.5
  2. orionbelt-analytics

    MCP servers

    Ontology-based MCP server that analyzes database schemas (PostgreSQL, Snowflake, ClickHouse, Dremio) and generates RDF/OWL ontologies with SQL mappings for fan-trap-free Text-to-SQL.

    Indexed GitHub, ralforion 58 ★Custom licence (see repository)Updated today

    git clone https://github.com/ralforion/orionbelt-analytics.git
  3. faucet

    MCP servers

    Faucet is an open-source, single-binary server that turns any SQL database into a secure, governed REST API with role-based access control and native MCP support for applications and AI agents.

    Stale GitHub, faucetdb 162 ★MITUpdated 29 days ago

    git clone https://github.com/faucetdb/faucet.git
  4. mnemiq

    MCP servers

    Open-source text-to-SQL engine you tune and measure on your own database

    Indexed GitHub, agenticfabriq 81 ★Apache-2.0Updated today

    git clone https://github.com/agenticfabriq/mnemiq.git
  5. mcp-server

    MCP servers

    Query BigQuery, Snowflake, Redshift & Azure Synapse with natural language

    Stale Official MCP Registry, io.quanti Updated 10 months ago 1 note

  6. dbine

    MCP servers

    DBine database manager: a free desktop app for 130+ SQL and NoSQL databases and cloud services, with notebooks, schema & data compare, cross-engine migration, a local AI assistant, an MCP server and encrypted cloud sync. Rust + Tauri.

    Indexed GitHub, addlayer-io 38 ★Apache-2.0Updated 3 days ago

    git clone https://github.com/addlayer-io/dbine.git