- 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 data without modifying any information.
How to use MCP Server for Snowflake?
To use the MCP Server, clone the repository, install the package, and configure your Snowflake credentials in a .env file. You can then run the server and connect it to Claude Desktop or any compatible MCP client.
Key features of MCP Server for Snowflake?
- Flexible authentication methods (service account with private key or external browser)
- Connection pooling with automatic refresh
- Support for multiple SQL statement types (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH)
- Read-only operations with security checks
- Integration with Claude Desktop for easy querying
Use cases of MCP Server for Snowflake?
- Listing all databases and views in a Snowflake account.
- Describing the structure of specific views.
- Executing custom read-only SQL queries.
- Comparing data from different views across databases.
FAQ from MCP Server for Snowflake?
- Can I modify data using this server?
No, the server enforces read-only operations to ensure data integrity.
- What authentication methods are supported?
The server supports both private key authentication and external browser authentication.
- Is there a limit on the number of queries I can run?
There is no explicit limit, but the server automatically adds LIMIT clauses to prevent large result sets.
Project Info
Created At
a year agoUpdated At
a year agoAuthor Name
dynamikeStar
4Language
PythonLicense
MIT licenseCategory
research-and-data
Recommend Servers
View AllTest
@modelcontextprotocol
test
7 months ago
Australia Payments Mcp
@junter1989k-ai
12 days ago
mcp-server-flomo MCP Server
@chatmcp
Write notes to Flomo
JavaScript
a year ago
Bahrain Payments Mcp
@junter1989k-ai
12 days ago
Lithuania Payments Mcp
@junter1989k-ai
12 days ago
Rwanda Payments Mcp
@junter1989k-ai
12 days ago
Creationloop
@marino129
12 days ago
Uruguay Payments Mcp
@junter1989k-ai
12 days ago
France Payments Mcp
@junter1989k-ai
13 days ago
Croatia Payments Mcp
@junter1989k-ai
12 days ago
Latvia Payments Mcp
@junter1989k-ai
12 days ago
Egypt Payments Mcp
@junter1989k-ai
12 days ago
Cyprus Payments Mcp
@junter1989k-ai
12 days ago
Malta Payments Mcp
@junter1989k-ai
12 days ago
Senegal Payments Mcp
@junter1989k-ai
12 days ago
Slovakia Payments Mcp
@junter1989k-ai
12 days ago