Snowflake-Admin-MCP-Server
The Snowflake-Admin-MCP-Server is a Python-based tool designed to automate the management of Snowflake databases. It provides features such as data import/export, query execution, and user management, enhancing operational efficiency in database management. With a user-friendly interface, it allows for automation through scripting.
GitHub Stars
0
User Rating
Not Rated
Favorites
0
Views
29
Forks
0
Issues
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.