OSS Snowflake MCP Server — Claude Code MCP server: setup guide
Connects your assistant to Snowflake Cortex AI services, semantic models, and SQL execution. The repository is deprecated by Snowflake-Labs.
claude mcp add --env SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT> --env SNOWFLAKE_HOST=<SNOWFLAKE_HOST> --env SNOWFLAKE_USER=<SNOWFLAKE_USER> --env SNOWFLAKE_PASSWORD=<SNOWFLAKE_PASSWORD> --env SNOWFLAKE_ROLE=<SNOWFLAKE_ROLE> --transport stdio oss-snowflake-mcp-server -- uvx snowflake-labs-mcpWhat OSS Snowflake MCP Server does
This community integration exposes Snowflake Cortex tools directly to MCP clients. It retrieves unstructured text for RAG workflows and runs queries against warehouse tables. All tools are registered in services/configuration.yaml. This requires manual setup.
Access control relies on statement filters. In the configuration file, admins can block destructive commands like Drop or Alter. Authentication runs through the Snowflake Python Connector with support for passwords and SSO.
Snowflake-Labs marked this repository as deprecated. Maintenance has ended, so the authors advise moving to the official Snowflake MCP Server. Without valid environment credentials and a prepared YAML file, the server will not start.
What it helps with
- query unstructured documents in Cortex Search for RAG workflows
- interact with structured datasets using Cortex Analyst models
- run SQL commands under statement permission restrictions
- modify Snowflake objects directly from the assistant session
Example prompts for the agent
- Retrieve matching policy sections from the Cortex Search index.
- Query monthly revenue figures using the Cortex Analyst model.
- Run a
Selectstatement on the transactions table to view recent entries.
How to install OSS Snowflake MCP Server
Platform CLI
claude mcp add --env SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT> --env SNOWFLAKE_HOST=<SNOWFLAKE_HOST> --env SNOWFLAKE_USER=<SNOWFLAKE_USER> --env SNOWFLAKE_PASSWORD=<SNOWFLAKE_PASSWORD> --env SNOWFLAKE_ROLE=<SNOWFLAKE_ROLE> --transport stdio oss-snowflake-mcp-server -- uvx snowflake-labs-mcpReplace <…> with your own values. 8 more environment variables are in the server README. uvx runs the command named after the package; if the README names another one, use uvx --from snowflake-labs-mcp <command>
Platform CLI
codex mcp add oss-snowflake-mcp-server --env SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT> --env SNOWFLAKE_HOST=<SNOWFLAKE_HOST> --env SNOWFLAKE_USER=<SNOWFLAKE_USER> --env SNOWFLAKE_PASSWORD=<SNOWFLAKE_PASSWORD> --env SNOWFLAKE_ROLE=<SNOWFLAKE_ROLE> -- uvx snowflake-labs-mcpReplace <…> with your own values. 8 more environment variables are in the server README. uvx runs the command named after the package; if the README names another one, use uvx --from snowflake-labs-mcp <command>
Config file
{
"mcpServers": {
"oss-snowflake-mcp-server": {
"command": "uvx",
"args": [
"snowflake-labs-mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
"SNOWFLAKE_HOST": "<SNOWFLAKE_HOST>",
"SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
"SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
"SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>"
}
}
}
}Replace <…> with your own values. 8 more environment variables are in the server README. uvx runs the command named after the package; if the README names another one, use uvx --from snowflake-labs-mcp <command>
Config file
{
"servers": {
"oss-snowflake-mcp-server": {
"type": "stdio",
"command": "uvx",
"args": [
"snowflake-labs-mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
"SNOWFLAKE_HOST": "<SNOWFLAKE_HOST>",
"SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
"SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
"SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>"
}
}
}
}Replace <…> with your own values. 8 more environment variables are in the server README. uvx runs the command named after the package; if the README names another one, use uvx --from snowflake-labs-mcp <command>
Platform CLI
gemini mcp add -e SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT> -e SNOWFLAKE_HOST=<SNOWFLAKE_HOST> -e SNOWFLAKE_USER=<SNOWFLAKE_USER> -e SNOWFLAKE_PASSWORD=<SNOWFLAKE_PASSWORD> -e SNOWFLAKE_ROLE=<SNOWFLAKE_ROLE> oss-snowflake-mcp-server uvx snowflake-labs-mcpReplace <…> with your own values. 8 more environment variables are in the server README. uvx runs the command named after the package; if the README names another one, use uvx --from snowflake-labs-mcp <command>
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about OSS Snowflake MCP Server
How to install OSS Snowflake MCP Server in Claude Code?
Run `claude mcp add --env SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT> --env SNOWFLAKE_HOST=<SNOWFLAKE_HOST> --env SNOWFLAKE_USER=<SNOWFLAKE_USER> --env SNOWFLAKE_PASSWORD=<SNOWFLAKE_PASSWORD> --env SNOWFLAKE_ROLE=<SNOWFLAKE_ROLE> --transport stdio oss-snowflake-mcp-server -- uvx snowflake-labs-mcp` with your account details.
What does OSS Snowflake MCP Server do?
It bridges development environments to Snowflake Cortex services, supporting semantic views, vector document search, and SQL execution.
Is this Snowflake MCP server actively supported?
No, Snowflake-Labs deprecated this repository and stopped releasing updates. They recommend switching to the official Snowflake MCP Server.
