Snowflake MCP Server
A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI…
- 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-nspAdd 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 identifierSNOWFLAKE_USERSnowflake usernameSNOWFLAKE_PASSWORDPassword (not required for key-pair / SSO)SNOWFLAKE_WAREHOUSEVirtual warehouse to useSNOWFLAKE_DATABASEDefault databaseSNOWFLAKE_SCHEMADefault schemaSNOWFLAKE_ROLERole to assumeSNOWFLAKE_AUTHENTICATORAuthentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentialsSNOWFLAKE_PRIVATE_KEY_FILEAbsolute path to .p8 private key fileSNOWFLAKE_PRIVATE_KEY_FILE_PWDPassphrase for encrypted private keySNOWFLAKE_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 identifierSNOWFLAKE_USERSnowflake usernameSNOWFLAKE_PASSWORDPassword (not required for key-pair / SSO)SNOWFLAKE_WAREHOUSEVirtual warehouse to useSNOWFLAKE_DATABASEDefault databaseSNOWFLAKE_SCHEMADefault schemaSNOWFLAKE_ROLERole to assumeSNOWFLAKE_AUTHENTICATORAuthentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentialsSNOWFLAKE_PRIVATE_KEY_FILEAbsolute path to .p8 private key fileSNOWFLAKE_PRIVATE_KEY_FILE_PWDPassphrase for encrypted private keySNOWFLAKE_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

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

PlatypusDB
MCP serverGives MCP clients access to your PlatypusDB database connections, scoped per agent
Runs locally- Open source
- Databases

Lorebase
MCP serverLets agents read and change a governed, versioned Postgres knowledge graph
Runs locally- Open source
- Knowledge and memory
Sovaria
MCP serverManage a Sovaria backend (Postgres, auth, storage, functions) from an AI assistant
Not checked yet- 4 tools
- Remote
- Freemium
- Databases

model2data studio
MCP serverGenerate realistic connected test data, dbt projects and dashboards from a schema
- Remote
- Freemium
- Databases

semlayer
MCP serverInfers a semantic layer from your data warehouse and serves it to agents
Runs locally- Free
- Databases