Snowflake MCP Server

Overview

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake. This server enables running SQL queries with tools and intereacting with a memo of data insights presented as a resource.

Components

Resources

The server exposes a single dynamic resource:

  • memo://insights: A continuously updated data insights memo that aggregates discovered insights during analysis
    • Auto-updates as new insights are discovered via the append-insight tool

Tools

The server offers six core tools:

Query Tools

  • read_query

    • Execute SELECT queries to read data from the database
    • Input:
      • query (string): The SELECT SQL query to execute
    • Returns: Query results as array of objects

  • write_query (with --allow-write flag)

    • Execute INSERT, UPDATE, or DELETE queries
    • Input:
      • query (string): The SQL modification query
    • Returns: { affected_rows: number }

  • create_table (with --allow-write flag)

    • Create new tables in the database
    • Input:
      • query (string): CREATE TABLE SQL statement
    • Returns: Confirmation of table creation

Schema Tools

  • list_tables

    • Get a list of all tables in the database
    • No input required
    • Returns: Array of table names

  • describe-table

    • View column information for a specific table
    • Input:
      • table_name (string): Name of table to describe (can be fully qualified)
    • Returns: Array of column definitions with names and types

Analysis Tools

  • append_insight
    • Add new data insights to the memo resource
    • Input:
      • insight (string): data insight discovered from analysis
    • Returns: Confirmation of insight addition
    • Triggers update of memo://insights resource

Usage with Claude Desktop

# Add the server to your claude_desktop_config.json
"mcpServers": {
  "snowflake": {
      "command": "uv",
      "args": [
          "--directory",
          "/absolute/path/to/mcp-snowflake-server",
          "run",
          "mcp_snowflake_snowflake"
          # Optionally: "--allow-write" (but not recommended)
      ],
      "env": {
          "SNOWFLAKE_WAREHOUSE": "your_warehouse",
          "SNOWFLAKE_DATABASE": "your_database",
          "SNOWFLAKE_ACCOUNT": "your_account_identifier",
          "SNOWFLAKE_USER": "your_username",
          "SNOWFLAKE_ROLE": "your_role",
          "SNOWFLAKE_SCHEMA": "your_schema",
          "SNOWFLAKE_PASSWORD": "your_password"
      }
  }
}

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (0.4.0)

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for isaacwasserman from gravatar.com isaacwasserman

Requires

Python >=3.10

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mcp_snowflake_server-0.0.2.tar.gz (5.8 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

mcp_snowflake_server-0.0.2-py3-none-any.whl (6.1 kB view details)

Uploaded Python 3

File details

Details for the file mcp_snowflake_server-0.0.2.tar.gz.

File metadata

  • Download URL: mcp_snowflake_server-0.0.2.tar.gz
  • Upload date:
  • Size: 5.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.0.1 CPython/3.12.8

File hashes

Hashes for mcp_snowflake_server-0.0.2.tar.gz
Algorithm Hash digest
SHA256 d39415370e8d7b6ba168082c93c70e97739dad0dc331c2072c50531a3ea036f5
MD5 249544553b41db75ec95200e7854101f
BLAKE2b-256 45059e2824377e9fb7e9e17c2917e91201fdbf586ac983d976d24ee2ae869447

See more details on using hashes here.

Provenance

The following attestation bundles were made for mcp_snowflake_server-0.0.2.tar.gz:

Publisher: python-publish.yml on isaacwasserman/mcp-snowflake-server

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file mcp_snowflake_server-0.0.2-py3-none-any.whl.

File metadata

File hashes

Hashes for mcp_snowflake_server-0.0.2-py3-none-any.whl
Algorithm Hash digest
SHA256 e1322840f206067bc6a2d6e57bf198a3aaff9d853b22a917ef5422181daf37c2
MD5 f7d73500f02c5451916d7c3e93545fe1
BLAKE2b-256 1922b64946ff147e043e77579185add4a818723d7cb1e8c372a7ffa29cf5f781

See more details on using hashes here.

Provenance

The following attestation bundles were made for mcp_snowflake_server-0.0.2-py3-none-any.whl:

Publisher: python-publish.yml on isaacwasserman/mcp-snowflake-server

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page