Snowflake MCP Server

Snowflake MCP Server

PythonCloudDatabaseSnowflakeSqlJavascriptGoRubyR

About This Server

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

Server Information

šŸ“‹ Overview:

This webpage is the GitHub repository for "mcp-snowflake-server" owned by isaacwasserman. It describes a Model Context Protocol (MCP) server implementation for interacting with Snowflake databases. The page provides details on the project's components, tools, and installation instructions for Claude Desktop.


ā­ Key Points:
  • The repository is public.

  • The project provides database interaction with Snowflake.

  • It exposes a dynamic resource: memo://insights, which is a continuously updated data insights memo.

  • The server offers six core tools for query, schema, and analysis purposes.

  • Installation instructions are provided for Smithery, UVX, and local setups for use with Claude Desktop.

  • The project is licensed under GPL-3.0.


  • šŸ” Main Findings:
  • The mcp-snowflake-server facilitates interaction with Snowflake databases through a Model Context Protocol server.

  • It offers resources and tools for querying, schema management, and data analysis.

  • The project integrates with Claude Desktop and provides detailed installation instructions.

  • The server has 15 stars and 4 forks.

  • The primary programming language is Python.


  • šŸ“Š Details:
  • Resources: The server exposes a single dynamic resource: memo://insights

  • Tools: Six core tools are available: readquery, writequery, createtable, listtables, describe-table, and append_insight.

  • Installation: Installation methods include Smithery, UVX, and local installation.

  • Repository details: Includes links to releases (19), contributors (2), and used-by information.


šŸŽÆ Conclusion:
The mcp-snowflake-server is a publicly available GitHub repository offering a Snowflake database interaction server. It provides tools for querying, schema management, and data analysis, with specific integration and installation instructions for Claude Desktop. The project is licensed under GPL-3.0.

Server Features

read_query

Execute SELECT queries to read data from the database

write_query

Execute INSERT, UPDATE, or DELETE queries

create_table

Create new tables in the database

list_tables

Get a list of all tables in the database

describe-table

View column information for a specific table

append_insight

Add new data insights to the memo resource

Provider Information

Isaacwasserman logo

Isaacwasserman

cloud Provider

Visit Provider Website

Quick Actions

Visit Website

MCP Configuration

Available Tools

read_querywrite_querycreate_tablelist_tablesdescribe-tableappend_insight

Available Resources

memo://insights