Snowflake MCP Server MCP Server
io.github.nsphung/mcp-snowflake-server
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.
SNOWFLAKE_ACCOUNTSnowflake account identifier
SNOWFLAKE_USERSnowflake username
SNOWFLAKE_PASSWORDsecretPassword (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_PWDsecretPassphrase for encrypted private key
SNOWFLAKE_OAUTH_CLIENT_IDOAuth 2.0 client ID (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_CLIENT_SECRETsecretOAuth 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_TOKENsecretPre-fetched OAuth bearer token (required for oauth authenticator)
{
"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

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

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

NVEIL
Data processing and visualization toolkit — 50+ chart types, raw data stays local.
Read Sudhanva Narayana's public profile, production ML case studies, and technical writing.
View repository →
Semiotic
AI-first React chart library with network graphs, streaming data, and MCP server for verified visualization generation.
