mcp-snowflake-server
- Databases
Snowflake integration implementing read and (optional) write operations as well as insight tracking
Prompts
Interactive templates invoked by user choice
Name | Description |
---|---|
No prompts |
Resources
Contextual data attached and managed by the client
Name | Description |
---|---|
No resources |
Tools
Functions exposed to the LLM to take actions
Name | Description |
---|---|
No tools |
Server Configuration
Describes the environment variables required to run the server.
Name | Required | Description | Default |
---|---|---|---|
SNOWFLAKE_ROLE | Yes | Your Snowflake role | |
SNOWFLAKE_USER | Yes | Your Snowflake username | |
SNOWFLAKE_SCHEMA | Yes | Your Snowflake schema | |
SNOWFLAKE_ACCOUNT | Yes | Your Snowflake account identifier | |
SNOWFLAKE_DATABASE | Yes | Your Snowflake database | |
SNOWFLAKE_PASSWORD | Yes | Your Snowflake password | |
SNOWFLAKE_WAREHOUSE | Yes | Your Snowflake warehouse |
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
Installing via Smithery
To install Snowflake Server for Claude Desktop automatically via Smithery:
This server can be run without cloning or installing the repository.
GitHub Badge
Glama performs regular codebase and documentation scans to:
- Confirm that the MCP server is working as expected.
- Confirm that there are no obvious security issues with dependencies of the server.
- Extract server characteristics such as tools, resources, prompts, and required parameters.
Our directory badge helps users to quickly asses that the MCP server is safe, server capabilities, and instructions for installing the server.
Copy the following code to your README.md file: