Snowflake MCP Server
by isaacwasserman
The Snowflake MCP Server is a Model Context Protocol (MCP) server implementation for interacting with Snowflake databases. It enables running SQL queries and exposing data insights and schema context as resources.
Last updated: N/A
What is Snowflake MCP Server?
A Model Context Protocol (MCP) server that provides database interaction with Snowflake. It allows users to execute SQL queries and access data insights and schema context through resources and tools.
How to use Snowflake MCP Server?
The server can be installed via Smithery, UVX, or locally. It exposes various tools for querying, schema management, and data analysis. Configuration involves setting up Snowflake credentials and optionally modifying runtime configurations for exclusion patterns.
Key features of Snowflake MCP Server
Provides resources for data insights and schema summaries.
Offers tools for executing read and write queries.
Includes schema management tools for listing databases, schemas, and tables.
Supports dynamic updating of data insights.
Integrates with Claude Desktop via Smithery or manual configuration.
Allows filtering of databases, schemas, and tables via exclusion patterns.
Supports external browser authentication for Snowflake.
Offers configurable logging levels.
Use cases of Snowflake MCP Server
Integrating Snowflake data with AI models and applications.
Automating data analysis and insight discovery.
Providing schema context to AI agents for better understanding of data.
Enabling natural language querying of Snowflake databases.
FAQ from Snowflake MCP Server
How do I enable write operations?
How do I enable write operations?
Write operations are disabled by default. You can enable them by using the --allow-write
flag when starting the server.
Can I filter out specific databases, schemas, or tables?
Can I filter out specific databases, schemas, or tables?
Yes, the server supports filtering databases, schemas, or tables using exclusion patterns in the configuration.
How does the append_insight
tool work?
How does the append_insight
tool work?
The append_insight
tool adds new data insights to the memo://insights
resource, which is updated dynamically.
What is Smithery?
What is Smithery?
Smithery is a platform that simplifies the installation and management of MCP servers like the Snowflake MCP Server.
What Python version is recommended?
What Python version is recommended?
Python version <=3.12 is recommended.