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 MongoDB Server
kiliczshA Model Context Protocol Server for MongoDB
mcp-server-duckdb
ktanaka101A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzeroMulti Database MCP Server
FreePeakA powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
コメント