Updated April 2026

Install Snowflake MCP Server

Pick your client, copy the command, done.

Local setup required. This server has to be cloned and prepared on your machine before you register it in Claude Code.
1

Set the server up locally

Run this once to clone and prepare the server before adding it to Claude Code.

Run in terminal
pip install -r requirements.txt
2

Register it in Claude Code

After the local setup is done, run this command to point Claude Code at the built server.

Run in terminal
claude mcp add -e "SNOWFLAKE_USER=${SNOWFLAKE_USER}" -e "SNOWFLAKE_PASSWORD=${SNOWFLAKE_PASSWORD}" -e "SNOWFLAKE_ACCOUNT=${SNOWFLAKE_ACCOUNT}" -e "SNOWFLAKE_WAREHOUSE=${SNOWFLAKE_WAREHOUSE}" -e "SNOWFLAKE_DATABASE=${SNOWFLAKE_DATABASE}" -e "SNOWFLAKE_SCHEMA=${SNOWFLAKE_SCHEMA}" snowflake-mcp -- bash -c "<FULL_PATH_TO_SNOWFLAKE_MCP>/dist/index.js"

Replace <FULL_PATH_TO_SNOWFLAKE_MCP>/dist/index.js with the actual folder you prepared in step 1.

Required:SNOWFLAKE_USERSNOWFLAKE_PASSWORDSNOWFLAKE_ACCOUNTSNOWFLAKE_WAREHOUSESNOWFLAKE_DATABASESNOWFLAKE_SCHEMA

Environment Variables

Set these before running Snowflake MCP Server.

VariableDescriptionRequired
SNOWFLAKE_USERSnowflake usernameYes
SNOWFLAKE_PASSWORDSnowflake passwordYes
SNOWFLAKE_ACCOUNTSnowflake account identifierYes
SNOWFLAKE_WAREHOUSESnowflake warehouse nameYes
SNOWFLAKE_DATABASESnowflake database nameYes
SNOWFLAKE_SCHEMASnowflake schema nameYes

Available Tools (3)

Once configured, Snowflake MCP Server gives your AI agent access to:

query_snowflakeExecute any SQL query on Snowflake and get formatted results.
sqllimit
list_tablesList all tables in a schema with row counts.
schema
describe_tableGet detailed structure of a table (columns, types, constraints).
table_name

Try It Out

After setup, try these prompts with your AI agent:

→Show me the top 10 customers by revenue
→How many orders were placed yesterday?
→What tables are available in the current schema?
→Describe the structure of the users table
→What's the average order value this month?
Prerequisites & system requirements
  • An MCP-compatible client (Claude Code, Cursor, Windsurf, Claude Desktop, or Codex)
  • Python 3.8+ with pip installed
  • SNOWFLAKE_USER — Snowflake username
  • SNOWFLAKE_PASSWORD — Snowflake password
  • SNOWFLAKE_ACCOUNT — Snowflake account identifier
  • SNOWFLAKE_WAREHOUSE — Snowflake warehouse name
  • SNOWFLAKE_DATABASE — Snowflake database name
  • SNOWFLAKE_SCHEMA — Snowflake schema name

Keep this setup from going cold

Save the docs, env vars, and workflow around Snowflake MCP Server in Conare so Claude Code, Codex, and Cursor remember it next time.

Need the legacy visual installer? Open Conare IDE.
Remember this setup
← Snowflake MCP Server overview Browse database servers →