Snowflake MCP Service
@davidamom
关于 Snowflake MCP Service
MCP server implementation for Snowflake integration
基本信息
配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"snowflake-mcp": {
"command": "python",
"args": [
"server.py"
]
}
}
}工具
未检测到工具
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
What is Snowflake MCP Service?
The Snowflake MCP Service is a Model Context Protocol (MCP) server that provides access to Snowflake databases for any MCP-compatible client. It allows AI applications and tools to execute SQL queries on Snowflake, automatically manage database connections (connect, reconnect on timeout, close), and handle query results and errors safely, using either password or key pair authentication.
How to use Snowflake MCP Service?
Clone the repository, install dependencies with pip install -r requirements.txt, and create a .env file with your Snowflake credentials and authentication method. Then configure your MCP client (e.g., Claude Desktop) with the path to the Python interpreter and the server script, or use the provided Docker setup. The server starts automatically when invoked by the client; for testing you can run python server.py manually.
Key features of Snowflake MCP Service
- Secure Snowflake database access
- Automatic connection lifecycle management
- Password and key pair authentication
- SQL query execution and result processing
- Export queries to CSV files
- Compatible with any MCP-compliant client
Use cases of Snowflake MCP Service
- Query Snowflake databases directly from an AI assistant like Claude
- Export SQL query results to CSV files for further analysis
- Enable natural language data exploration via MCP clients
- Automate database reporting through conversational interfaces
FAQ from
数据库 分类下的更多 MCP 服务器
mcp-server-duckdb
ktanaka101A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities
Multi Database MCP Server
FreePeakA powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
Database Gateway
centralmindUniversal MCP-Server for your Databases optimized for LLMs and AI-Agents.
Elasticsearch/OpenSearch MCP Server
cr7258A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.
MongoDB Lens
furey🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases
评论