Snowflake MCP Server
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 identifierSNOWFLAKE_USER· Snowflake usernameSNOWFLAKE_PASSWORDsecret · Password (not required for key-pair / SSO)SNOWFLAKE_WAREHOUSE· Virtual warehouse to useSNOWFLAKE_DATABASE· Default databaseSNOWFLAKE_SCHEMA· Default schemaSNOWFLAKE_ROLE· Role to assumeSNOWFLAKE_AUTHENTICATOR· Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentialsSNOWFLAKE_PRIVATE_KEY_FILE· Absolute path to .p8 private key fileSNOWFLAKE_PRIVATE_KEY_FILE_PWDsecret · Passphrase for encrypted private keySNOWFLAKE_OAUTH_CLIENT_ID· OAuth 2.0 client ID (required for oauth_client_credentials authenticator)SNOWFLAKE_OAUTH_CLIENT_SECRETsecret · OAuth 2.0 client secret (required for oauth_client_credentials authenticator)
Related
-
OSS Snowflake MCP Server
MCP serversMCP Server for Snowflake from Snowflake Labs
snowflake-labs-mcp@1.3.5 -
orionbelt-analytics
MCP serversOntology-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.
git clone https://github.com/ralforion/orionbelt-analytics.git -
faucet
MCP serversFaucet 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.
git clone https://github.com/faucetdb/faucet.git -
mnemiq
MCP serversOpen-source text-to-SQL engine you tune and measure on your own database
git clone https://github.com/agenticfabriq/mnemiq.git -
mcp-server
MCP serversQuery BigQuery, Snowflake, Redshift & Azure Synapse with natural language
-
dbine
MCP serversDBine 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.
git clone https://github.com/addlayer-io/dbine.git