MCP Catalogs
← Home

snowflake-mcp-server

by dynamike·★ 13·Score 36

An MCP server for secure read-only queries to Snowflake databases with multiple authentication methods.

databasedeveloper-toolsai-llm
12
Forks
7
Open issues
13 mo ago
Last commit
2d ago
Indexed

Overview

This MCP server enables Claude to securely query Snowflake data without modifying information. It supports flexible authentication methods including service account with private key and external browser authentication. The server implements connection pooling with automatic background refresh and supports multiple SQL statement types (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) with security checks to prevent data modification. Tools are available for listing databases, describing views, executing queries, and retrieving data with proper row limits to prevent overwhelming result sets.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

you:Data analysts can explore Snowflake databases through natural language queries
you:Teams can connect Claude Desktop to Snowflake for business intelligence tasks
you:Developers can integrate Snowflake data access into AI-powered applications
you:What SQL operations are supported?
you:What authentication methods are available?

When to choose this

Choose this when you need secure, read-only access to Snowflake databases through an MCP interface without modifying any data, especially when using Claude for data analysis.

When NOT to choose this

Avoid if you need write access to Snowflake databases or if you're not already using Snowflake as your data warehouse.

Tools this server exposes

5 tools extracted from the README
  • list_databases

    List all accessible Snowflake databases

  • list_views

    List all views in a specified database and schema

  • describe_view

    Get detailed information about a specific view including columns and SQL definition

  • query_view

    Query data from a view with an optional row limit

  • execute_query

    Execute custom read-only SQL queries with results formatted as markdown tables

Comparable tools

supabase-mcpneon-mcppostgres-mcpsnowflake-api-wrapper

Installation

Installation

  1. Clone the repository:
git clone https://github.com/dynamike/snowflake-mcp-server.git
cd snowflake-mcp-server
  1. Install the package:
uv pip install -e .
  1. Create a .env file with your Snowflake credentials (copy from .env.private_key.example or .env.browser.example)

Claude Desktop Integration

"snowflake-mcp-server": {
  "command": "uv",
  "args": [
    "--directory",
    "/<path-to-code>/snowflake-mcp-server",
    "run",
    "snowflake-mcp-stdio"
  ]
}

FAQ

What SQL operations are supported?
The server supports SELECT, SHOW, DESCRIBE, EXPLAIN, and WITH statements with security checks to prevent data modification.
What authentication methods are available?
Two methods are supported: service account authentication with private key for non-interactive use, and external browser authentication for interactive login.

Compare snowflake-mcp-server with

snowflake-mcp-server vs ultimate_mcp_serversnowflake-mcp-server vs mcp-server-chartsnowflake-mcp-server vs everythingsnowflake-mcp-server vs filesystemsnowflake-mcp-server vs time
GitHub →

Last updated · Auto-generated from public README + GitHub signals.