- MCP Server for Snowflake
MCP Server for Snowflake
MCP Server for connecting to Snowflake with read-only questions
Overview
what is MCP Server for Snowflake?
MCP Server for Snowflake is a Model Context Protocol (MCP) server designed for performing read-only operations against Snowflake databases, allowing secure querying of Snowflake data without modifying any information.
how to use MCP Server for Snowflake?
To use the MCP Server, clone the repository, install the required packages, and configure your Snowflake credentials in a .env file. Then, run the server using the command uv run snowflake-mcp.
key features of MCP Server for Snowflake?
- Secure connection to Snowflake using service account authentication with private key
- MCP-compatible handlers for querying Snowflake data
- Read-only operations with security checks to prevent data modification
- Support for Python 3.12+
- Stdio-based MCP server for easy integration with Claude Desktop
use cases of MCP Server for Snowflake?
- Listing all accessible Snowflake databases
- Describing the structure of specific views in a database
- Executing custom read-only SQL queries
- Integrating with Claude Desktop for enhanced data querying capabilities
FAQ from MCP Server for Snowflake?
- Can I modify data using this server?
No, the MCP Server enforces read-only operations, allowing only SELECT statements.
- What are the prerequisites for using this server?
You need Python 3.12 or higher and a configured Snowflake service account.
- How do I secure my credentials?
Keep your
.envfile secure and do not commit it to version control.
Project Info
Created At
5 months agoUpdated At
5 months agoAuthor Name
dynamikeStar
4Language
PythonLicense
MIT licenseCategory
research-and-data
Recommend Servers
View AllAdd Number
@tree
Add Two Number
6 days ago
Crm Piperun
a day ago
Serper MCP Server
@garymengcom
A Serper MCP Server
Python
3 months ago
Higgsfield
3 days ago
Agent Mcp
@zhaozeen
11 days ago
Searchinfinity Mcp
@server
6 days ago
Quicktype Mcp
@AscEmon
10 days ago
Brave Search
@brave
11 days ago
Flomo Mcp
@hutusi
11 days ago