A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants
To add Snowflake MCP Server to Claude, run the install command below or copy the ready-made config for Claude Code, Claude Desktop, Cursor and VS Code further down. Restart your client after adding it and its tools show up in your next conversation. It needs 15 environment variables, listed below.
Install
uvx mcp-snowflake-server-nsp@0.14.4Environment variables
SNOWFLAKE_ACCOUNTSet in your MCP configSNOWFLAKE_USERSet in your MCP configSNOWFLAKE_PASSWORDSet in your MCP configSNOWFLAKE_WAREHOUSESet in your MCP configSNOWFLAKE_DATABASESet in your MCP configSNOWFLAKE_SCHEMASet in your MCP configSNOWFLAKE_ROLESet in your MCP configSNOWFLAKE_AUTHENTICATORSet in your MCP configSNOWFLAKE_PRIVATE_KEY_FILESet in your MCP configSNOWFLAKE_PRIVATE_KEY_FILE_PWDSet in your MCP configSNOWFLAKE_OAUTH_CLIENT_IDSet in your MCP configSNOWFLAKE_OAUTH_CLIENT_SECRETSet in your MCP configSNOWFLAKE_OAUTH_TOKEN_REQUEST_URLSet in your MCP configSNOWFLAKE_OAUTH_SCOPESet in your MCP configSNOWFLAKE_TOKENSet in your MCP configInstall with your client
claude mcp add snowflake --env SNOWFLAKE_ACCOUNT=<YOUR_SNOWFLAKE_ACCOUNT> --env SNOWFLAKE_USER=<YOUR_SNOWFLAKE_USER> --env SNOWFLAKE_PASSWORD=<YOUR_SNOWFLAKE_PASSWORD> --env SNOWFLAKE_WAREHOUSE=<YOUR_SNOWFLAKE_WAREHOUSE> --env SNOWFLAKE_DATABASE=<YOUR_SNOWFLAKE_DATABASE> --env SNOWFLAKE_SCHEMA=<YOUR_SNOWFLAKE_SCHEMA> --env SNOWFLAKE_ROLE=<YOUR_SNOWFLAKE_ROLE> --env SNOWFLAKE_AUTHENTICATOR=<YOUR_SNOWFLAKE_AUTHENTICATOR> --env SNOWFLAKE_PRIVATE_KEY_FILE=<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE> --env SNOWFLAKE_PRIVATE_KEY_FILE_PWD=<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE_PWD> --env SNOWFLAKE_OAUTH_CLIENT_ID=<YOUR_SNOWFLAKE_OAUTH_CLIENT_ID> --env SNOWFLAKE_OAUTH_CLIENT_SECRET=<YOUR_SNOWFLAKE_OAUTH_CLIENT_SECRET> --env SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL=<YOUR_SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL> --env SNOWFLAKE_OAUTH_SCOPE=<YOUR_SNOWFLAKE_OAUTH_SCOPE> --env SNOWFLAKE_TOKEN=<YOUR_SNOWFLAKE_TOKEN> -- uvx mcp-snowflake-server-nsp@0.14.4
Run this in a terminal to add the server to Claude Code.
What this does
Snowflake MCP Server exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation.
Requirements
This server needs the following environment variables to be set before it can run:
SNOWFLAKE_ACCOUNT SNOWFLAKE_USER SNOWFLAKE_PASSWORD SNOWFLAKE_WAREHOUSE SNOWFLAKE_DATABASE SNOWFLAKE_SCHEMA SNOWFLAKE_ROLE SNOWFLAKE_AUTHENTICATOR SNOWFLAKE_PRIVATE_KEY_FILE SNOWFLAKE_PRIVATE_KEY_FILE_PWD SNOWFLAKE_OAUTH_CLIENT_ID SNOWFLAKE_OAUTH_CLIENT_SECRET SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL SNOWFLAKE_OAUTH_SCOPE SNOWFLAKE_TOKEN
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Frequently asked questions
How do I install Snowflake MCP Server?
Run the Claude Code command in the install section to add Snowflake MCP Server to Claude Code, or copy the ready-made config for your client from the install section on this page. Restart your client afterwards and the tools appear in your next conversation.
Which clients work with Snowflake MCP Server?
This page carries setup and config for Claude Code, Claude Desktop, Cursor and VS Code. Any other MCP client that accepts a standard server config can connect to Snowflake MCP Server as well.
Does Snowflake MCP Server need an API key?
Yes. Before it can run, set these environment variables: SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_ROLE, SNOWFLAKE_AUTHENTICATOR, SNOWFLAKE_PRIVATE_KEY_FILE, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_OAUTH_CLIENT_ID, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL, SNOWFLAKE_OAUTH_SCOPE, SNOWFLAKE_TOKEN. They go in the env block of your MCP config.
Imported from the Official MCP Registry. The details above come from the registry entry; the maker can claim this listing to correct them, add docs, and see its traffic.
Is this your MCP server?
Claim this listing to see its traffic, fix details yourself, and skip the review queue on future updates.
Add this badge to your README
Show visitors this server is listed in the ClaudeRules directory. The badge links straight to this listing.
[](https://clauderules.net/mcp/io-github-nsphung-mcp-snowflake-server)<a href="https://clauderules.net/mcp/io-github-nsphung-mcp-snowflake-server" target="_blank" rel="noopener noreferrer"><img src="https://clauderules.net/api/badge/io-github-nsphung-mcp-snowflake-server" alt="Listed on clauderules.net" /></a>More Database MCP servers
GitHub
Connect AI assistants to GitHub - manage repos, issues, PRs, and workflows through natural language.
Serena MCP: the IDE for your agent
A powerful toolkit for coding, providing semantic retrieval and editing capabilities.
MCP Toolbox for Databases
MCP Toolbox for Databases enables your agent to connect to your database.
Figma-Context-MCP
Give your coding agent access to your Figma data. Implement designs in any framework in one-shot.