Snowflake-Admin-MCP-Server
Snowflake-Admin-MCP-Serverは、Snowflakeデータベースの管理を自動化するためのPythonベースのツールです。このツールは、データのインポート、エクスポート、クエリの実行、ユーザー管理などの機能を提供し、データベースの運用効率を向上させます。使いやすいインターフェースを持ち、スクリプトを通じて自動化が可能です。
GitHubスター
0
ユーザー評価
未評価
お気に入り
0
閲覧数
19
フォーク
0
イシュー
0
Snowflake-Admin-MCP-Server
MCP (Model Context Protocol) Server for Connecting LLMs with Snowflake Administration Tools.
Overview
This custom MCP server serves as a connection between Snowflake and the LLM (Claude Desktop in our Case), which will be our host for the server.
The server allows us to integrate primarily tools, context & resources to the LLM, which will be based on the Model Context Protocol devised by Claude. More on MCPs below
What is MCP (Model Context Protocol)
Architecture
The following will be our high-level architecture
Features
- Tools
- Query Execution
- Memory Management
- Memory
- Long Term Memory
- Resources
- Custom Templates for the Snowflake Management
- Prompts
- Custom prompts to steer LLMs (MCP Client) to make the best out of MCP server
Tools
Here, we are primarily focused on creating tools, such as
- Query Execution
- Admin Tasks
Setup
Clone the repo
Environment Variables
- Create a .env file in the project directory
- The file should contain the following
- This will be the credentials/config for the Snowflake / MongoDB Connection
Claude Desktop Config
You can install this MCP Server in Claude Desktop in either of those ways,
- UV package manager command
- uv run mcp install server.py
- Adding the following config to the Claude Config JSON File
Demo
Here are the screenshots / demo of the server execution.