agents-libagents-lib
AgentsMCP ServersWorkflowsTutorialsComparisonsTemplatesNewsAbout
🔌

Snowflake MCP

Database•⭐ 850

Execute SQL queries and manage Snowflake data warehouse for analytics and data science.

GitHubWebsite →
Claude DesktopCursor

Overview

Execute SQL queries and manage Snowflake data warehouse for analytics and data science.

Setup

Run with npx:

npx -y @modelcontextprotocol/server-snowflake

Configuration

SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA

Documentation

Snowflake MCP (Enhanced)

Overview

Snowflake MCP provides access to Snowflake data warehouse for SQL queries and analytics.

Features

  • SQL query execution
  • Database management
  • Data loading
  • Warehouse management
  • Security controls

Installation

npx -y @modelcontextprotocol/server-snowflake

Configuration

Set up Snowflake credentials:

export SNOWFLAKE_ACCOUNT=your_account
export SNOWFLAKE_USER=your_user
export SNOWFLAKE_PASSWORD=your_password
export SNOWFLAKE_WAREHOUSE=your_warehouse
export SNOWFLAKE_DATABASE=your_database
export SNOWFLAKE_SCHEMA=your_schema

Available Operations

OperationDescription
Execute QueryRun SQL query
List TablesGet schema tables
Describe TableGet table structure
Load DataImport data files
Get ResultsFetch query results

Usage Examples

Execute Query

{
  "action": "execute_query",
  "sql": "SELECT * FROM customers WHERE status = 'active' LIMIT 10"
}

List Tables

{
  "action": "list_tables",
  "database": "analytics",
  "schema": "public"
}

Describe Table

{
  "action": "describe_table",
  "table_name": "customers"
}

Pros

  • ✅ Enterprise-grade analytics
  • ✅ Scalable performance
  • ✅ SQL-native
  • ✅ Cloud-native architecture

Cons

  • ❌ Requires Snowflake account
  • ❌ Complex credential setup
  • ❌ Cost for large queries

Resources