How do I install Snowflake?

Copy the stdio config for Cursor, Claude Desktop, Claude Code, or VS Code on this page. It uses the publisher's install, not a PlugMCP proxy.

Does Snowflake need an API key?

No required environment variable is listed on this record.

What transport does Snowflake use?

Snowflake runs locally over stdio.

When was Snowflake last checked?

Last checked 2026-11-11. MCP server for executing Snowflake queries

Snowflake MCP 伺服器

接入你的智能体

新增此伺服器

The publisher's own command. Not a PlugMCP endpoint.

Add to Cursor Add to VS Code 在 PlugMCP 上執行

用我們的金鑰與日誌託管一份副本。

Local command

npx -y [email protected]

Claude Code has no install link for a local command. Copy the command below and run it in a terminal.

shClaude Code

1claude mcp add snowflake-mcp -- npx -y snowflake-mcp@1.1.0

Run in a terminal.

jsonClaude Desktop

1{2  "mcpServers": {3    "snowflake-mcp": {4      "command": "npx",5      "args": [6        "-y",7        "[email protected]"8      ]9    }10  }11}

claude_desktop_config.json

Local · npmPublisher installStep-by-step: add this in Claude

Remote URL or a command on your machine? How the two installs differ

在 PlugMCP 上執行

用我們的金鑰與日誌託管一份副本。

这是你新建的服务器，不是此条目的官方端点。若要用发布方的 URL 与凭证，请使用上方安装面板。

啟動

Server facts

Local

Transport: stdio
Version: 1.1.0
Last checked

Tools

No tool list yet. Remote servers get one after the first health check.

FAQ

Questions

Snowflake MCP Server

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

Users can use natural language to query Snowflake databases, like:

"Get me the top 10 products by revenue"
"Show me the total revenue for the last 30 days"
"Describe the structure of the orders table"
"Explore the database and summarize what data is available"
"Build a query to find customers who haven't ordered in 90 days"

Features

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
MCP Prompts: Guided workflows for common tasks
Support for both password and SSO (browser-based) authentication
Configurable default warehouse, database, schema, and role

Prerequisites

Node.js 18 or later

Usage

Cursor

Add to your Cursor MCP settings (~/.cursor/mcp.json):

SSO Authentication (Recommended)

{
  "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"
      }
    }
  }
}

A browser window will open for authentication on first query.

Password Authentication

{
  "mcpServers": {
    "snowflake": {
      "command": "npx",
      "args": ["-y", "snowflake-mcp"],
      "env": {
        "SNOWFLAKE_ACCOUNT": "your-org-your-account",
        "SNOWFLAKE_USERNAME": "your-username",
        "SNOWFLAKE_PASSWORD": "your-password",
        "SNOWFLAKE_ROLE": "your-role",
        "SNOWFLAKE_WAREHOUSE": "your-warehouse",
        "SNOWFLAKE_DATABASE": "your-database",
        "SNOWFLAKE_SCHEMA": "your-schema",
        "SNOWFLAKE_READONLY": "true"
      }
    }
  }
}

Claude Desktop

Add to your Claude Desktop config (~/Library/Application Support/Claude/claude_desktop_config.json on macOS):

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

Configuration

Variable	Required	Default	Description
`SNOWFLAKE_ACCOUNT`	Yes	-	Your Snowflake account identifier (e.g., `ORG-ACCOUNT`)
`SNOWFLAKE_USERNAME`	Yes	-	Snowflake username
`SNOWFLAKE_AUTHENTICATOR`	No	`externalbrowser`	Authentication method: `externalbrowser` (SSO) or `snowflake` (password)
`SNOWFLAKE_PASSWORD`	Conditional	-	Required if authenticator is `snowflake`, not needed for `externalbrowser`
`SNOWFLAKE_ROLE`	No	-	Role to use for the session (uses account default if not set)
`SNOWFLAKE_WAREHOUSE`	No	-	Warehouse to use (uses account default if not set)
`SNOWFLAKE_DATABASE`	No	-	Database to use (uses account default if not set)
`SNOWFLAKE_SCHEMA`	No	-	Schema to use (uses account default if not set)
`SNOWFLAKE_READONLY`	No	`false`	Set to `true` to block write operations (INSERT, UPDATE, DELETE, etc.)

Finding Your Connection Settings

You can find your connection settings in Snowsight (Snowflake's web interface):

Sign in to Snowsight
Click on your username in the bottom-left corner to open the user menu
Select Connect a tool to Snowflake
Open the Config File tab
Select the Warehouse, Database, Schema you want to use
Copy values from the generated config file

Available Tools

Query Execution

`execute_query`

Execute a SQL query against Snowflake.

Parameter	Type	Required	Default	Description
`query`	string	Yes	-	The SQL query to execute
`max_rows`	number	No	100	Maximum number of rows to return
`timeout`	number	No	-	Query timeout in seconds
`format`	string	No	table	Output format: `table`, `json`, or `csv`

`explain_query`

Get the execution plan for a SQL query without running it.

Parameter	Type	Required	Description
`query`	string	Yes	The SQL query to explain

Connection

`test_connection`

Test the connection to Snowflake and return connection info including current user, role, warehouse, database, schema, and version.

Schema Discovery

`list_databases`

List all accessible databases in Snowflake.

`list_schemas`

List all schemas in a database.

Parameter	Type	Required	Description
`database`	string	No	Database name (uses current if not specified)

`list_tables`

List all tables in a schema.

Parameter	Type	Required	Description
`database`	string	No	Database name
`schema`	string	No	Schema name

`list_views`

List all views in a schema.

Parameter	Type	Required	Description
`database`	string	No	Database name
`schema`	string	No	Schema name

Table Inspection

`describe_table`

Get detailed information about a table's structure including columns, types, and constraints.

Parameter	Type	Required	Description
`table`	string	Yes	Table name (can include database.schema.table)

`get_table_sample`

Get a sample of rows from a table to understand its data.

Parameter	Type	Required	Default	Description
`table`	string	Yes	-	Table name
`limit`	number	No	5	Number of sample rows to return

`get_table_row_count`

Get the total number of rows in a table.

Parameter	Type	Required	Description
`table`	string	Yes	Table name

`get_primary_keys`

Get primary key columns for a table.

Parameter	Type	Required	Description
`table`	string	Yes	Table name

MCP Resources

`schema://current`

Returns information about the current database schema, including:

Current database and schema names
List of all tables
List of all views

Access this resource to get a quick overview of the connected schema without running queries.

MCP Prompts

`analyze_table`

Analyze a table's structure, sample data, and get query suggestions.

Parameter	Type	Required	Description
`table_name`	string	Yes	The table to analyze

`explore_database`

Explore and summarize the structure of a database.

Parameter	Type	Required	Description
`database_name`	string	No	Database to explore (uses current if not specified)

`query_builder`

Help build a SQL query based on natural language description.

Parameter	Type	Required	Description
`description`	string	Yes	Natural language description of desired query
`tables`	string	No	Comma-separated list of relevant tables

Security Considerations

SSO authentication is recommended for production use as it avoids storing passwords in configuration files
Readonly mode (SNOWFLAKE_READONLY=true) is recommended when you only need to query data
Never commit configuration files containing credentials to version control
Consider using environment variables or a secrets manager for sensitive values
The server executes queries with the permissions of the configured Snowflake user—ensure appropriate access controls are in place
The max_rows parameter helps prevent accidentally returning massive result sets

License

MIT License

新增此伺服器

用我們的金鑰與日誌託管一份副本。

Server facts

Tools

Questions

How do I install Snowflake?

Does Snowflake need an API key?

What transport does Snowflake use?

When was Snowflake last checked?

Documentation

Snowflake MCP Server

Features

Prerequisites

Usage

Cursor

SSO Authentication (Recommended)

Password Authentication

Claude Desktop

Configuration

Finding Your Connection Settings

Available Tools

Query Execution

execute_query

explain_query

Connection

test_connection

Schema Discovery

list_databases

list_schemas

list_tables

list_views

Table Inspection

describe_table

get_table_sample

get_table_row_count

get_primary_keys

MCP Resources

schema://current

MCP Prompts

analyze_table

explore_database

query_builder

Security Considerations

License

`execute_query`

`explain_query`

`test_connection`

`list_databases`

`list_schemas`

`list_tables`

`list_views`

`describe_table`

`get_table_sample`

`get_table_row_count`

`get_primary_keys`

`schema://current`

`analyze_table`

`explore_database`

`query_builder`