Skip to main content
Glama
snowflake-mcp

snowflake-mcp

by faressoft

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

Related MCP server: Snowflake Developer MCP Server

Prerequisites

  • Node.js 18 or later

Usage

Cursor

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

{
  "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):

  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.

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

Available Tools

11 tools
describe_tableA

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

Inputs: table (required).

execute_queryC

Execute a SQL query against Snowflake and return the results

Inputs: query (required), format, timeout, max_rows.

explain_queryA

Get the execution plan for a SQL query without running it

Inputs: query (required).

get_primary_keysB

Get primary key columns for a table

Inputs: table (required).

get_table_row_countA

Get the total number of rows in a table

Inputs: table (required).

get_table_sampleB

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

Inputs: table (required), limit.

list_databasesA

List all accessible databases in Snowflake

Inputs: no named parameters.

list_schemasA

List all schemas in a database

Inputs: database.

list_tablesB

List all tables in a schema

Inputs: schema, database.

list_viewsC

List all views in a schema

Inputs: schema, database.

test_connectionA

Test the connection to Snowflake and return connection info

Inputs: no named parameters.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.8/5.0

    Scored across 11 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose: listing vs describing vs sampling vs querying vs explaining. No overlapping tools that could cause confusion.

    Naming Consistency5/5

    All tool names follow a consistent verb_noun snake_case pattern (get_*, list_*, describe_*, test_*, execute_*, explain_*). No mixed conventions or varied verb styles.

    Tool Count5/5

    11 tools is well within the ideal 3-15 range and maps neatly to the domain of Snowflake exploration and querying. Each tool earns its place without bloat.

    Completeness5/5

    Covers the full read-side workflow: connection testing, database/schema/table/view enumeration, schema inspection, row counts, primary keys, sampling, query execution, and query planning. No critical gaps for an exploration/query-focused server.

    Maintenance

    ActivityInactive
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      A
      quality
      Not graded
      maintenance
      Enables AI assistants to securely connect to Snowflake data warehouses and execute SQL queries through natural language interactions. Supports multiple authentication methods and provides formatted query results with built-in security controls.
      1
      2
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to perform comprehensive Snowflake database operations including DDL, DML, and warehouse management. It allows users to query data, manage database objects, and configure permissions using natural language commands.
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to securely access Snowflake data warehouses through natural language, executing SQL queries and retrieving insights with support for multiple authentication methods.
      3
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables natural language querying and management of Snowflake databases, including SQL execution, schema exploration, and warehouse monitoring.
      MIT