How do I install the snowflake mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `SNOWFLAKE_ACCOUNT`, `SNOWFLAKE_USERNAME`, `SNOWFLAKE_AUTHENTICATOR`, `SNOWFLAKE_WAREHOUSE`, `SNOWFLAKE_DATABASE`, `SNOWFLAKE_SCHEMA`, `SNOWFLAKE_PASSWORD`, `SNOWFLAKE_ROLE` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Snowflake MCP Server

MCP server for executing Snowflake queries

Local serverstdio

What is the Snowflake MCP Server?

MCP server for executing Snowflake queries

The short version

A Model Context Protocol (MCP) server that enables AI agents to execute SQL queries against Snowflake databases.

Execute SQL queries directly from AI agents like Cursor, Claude Desktop, etc
Schema Discovery — Browse databases, schemas, tables, and views
Table Inspection — Describe table structures, view sample data, check row counts
Query Safety — Readonly mode, row limits, and query timeouts
Multiple Output Formats — Table, JSON, or CSV
Query Explanation — Get execution plans for queries

What it needs from you

Node.js 18 or later

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
execute_query
explain_query
test_connection	Test the connection to Snowflake and return connection info including current user, role, warehouse, database, schema, and version.
list_databases
list_schemas
list_tables
list_views
describe_table	Get detailed information about a table's structure including columns, types, and constraints.
get_table_sample
get_table_row_count
get_primary_keys
analyze_table	Analyze a table's structure, sample data, and get query suggestions.

How to install the Snowflake MCP Server

{
  "mcpServers": {
    "snowflake": {
      "command": "npx",
      "args": ["-y", "snowflake-mcp"],
      "env": {
        "SNOWFLAKE_ACCOUNT": "your-org-your-account",
        "SNOWFLAKE_USERNAME": "your-username",
        "SNOWFLAKE_AUTHENTICATOR": "externalbrowser",
        "SNOWFLAKE_WAREHOUSE": "your-warehouse",
        "SNOWFLAKE_DATABASE": "your-database",
        "SNOWFLAKE_SCHEMA": "your-schema"
      }
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

Node.js 18 or later

Variable	Description	Required
SNOWFLAKE_ACCOUNT	Configuration value read at startup.	Optional
SNOWFLAKE_USERNAME	Configuration value read at startup.	Optional
SNOWFLAKE_AUTHENTICATOR	Configuration value read at startup.	Optional
SNOWFLAKE_WAREHOUSE	Configuration value read at startup.	Optional
SNOWFLAKE_DATABASE	Configuration value read at startup.	Optional
SNOWFLAKE_SCHEMA	Configuration value read at startup.	Optional
SNOWFLAKE_PASSWORD	Configuration value read at startup.	Optional
SNOWFLAKE_ROLE	Configuration value read at startup.	Optional

Example prompts to try

“Use Snowflake to Cursor.”
“Use Snowflake to execute query.”
“Use Snowflake to explain query.”

Frequently asked questions

MCP server for executing Snowflake queries Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.