Snowflake

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

Finding Your Connection Settings

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

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

Available Tools

Query Execution

execute_query

Execute a SQL query against Snowflake.

explain_query

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

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.

list_tables

List all tables in a schema.

list_views

List all views in a schema.

Table Inspection

describe_table

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

get_table_sample

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

get_table_row_count

Get the total number of rows in a table.

get_primary_keys

Get primary key columns for a table.

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.

explore_database

Explore and summarize the structure of a database.

query_builder

Help build a SQL query based on natural language description.

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