Schema | Snowflake MCP Server

Server Configuration

Describes the environment variables required to run the server.

Name	Required	Description
`SNOWFLAKE_ROLE`	No	Your Snowflake role
`SNOWFLAKE_SCHEMA`	No	Your Snowflake schema
`SNOWFLAKE_ACCOUNT`	No	Your Snowflake account identifier (e.g., abc12345.us-east-1.snowflakecomputing.com)
`SNOWFLAKE_DATABASE`	No	Your Snowflake database
`SNOWFLAKE_MAX_ROWS`	No	Maximum number of rows to return from queries
`SNOWFLAKE_PASSWORD`	No	Your Snowflake password
`SNOWFLAKE_USERNAME`	No	Your Snowflake username
`SNOWFLAKE_WAREHOUSE`	No	Your Snowflake warehouse
`SNOWFLAKE_AUTHENTICATOR`	No	Authentication method (e.g., externalbrowser for SSO)
`SNOWFLAKE_PRIVATE_KEY_PATH`	No	Path to your RSA private key file (e.g., /path/to/rsa_key.p8)
`SNOWFLAKE_PRIVATE_KEY_PASSPHRASE`	No	Passphrase for the private key (optional)

Capabilities

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Tools

Functions exposed to the LLM to take actions

Name Description

Name	Description
execute_snowflake_sql_query	Execute any SQL query on Snowflake. ⚠️ SECURITY WARNING: This tool executes raw SQL queries on your Snowflake instance. Ensure proper user permissions and network security. Consider query restrictions for production environments. Args: query: The SQL query to execute (required) database: Override the default database (optional) schema: Override the default schema (optional) warehouse: Override the default warehouse (optional) Returns: Formatted string containing query results or error message

execute_snowflake_sql_query

Execute any SQL query on Snowflake.

⚠️  SECURITY WARNING: This tool executes raw SQL queries on your Snowflake instance.
Ensure proper user permissions and network security. Consider query restrictions
for production environments.

Args:
    query: The SQL query to execute (required)
    database: Override the default database (optional)
    schema: Override the default schema (optional)
    warehouse: Override the default warehouse (optional)

Returns:
    Formatted string containing query results or error message

Prompts

Interactive templates invoked by user choice

Name	Description
No prompts

Resources

Contextual data attached and managed by the client

Name	Description
No resources

Snowflake MCP Server

Server Configuration

Capabilities

Tools

Prompts

Resources

Latest Blog Posts

MCP directory API