Snowflake-Admin-MCP-Server

sandeepvsk10/Snowflake-Admin-MCP-Server

3.2

If you are the rightful owner of Snowflake-Admin-MCP-Server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Snowflake-Admin-MCP-Server is a custom Model Context Protocol server designed to connect Snowflake administration tools with LLMs, specifically using Claude Desktop as the host.

Tools
2
Resources
0
Prompts
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 5f5f3ff57c7734905a2843c22a9f4f2583a06fa1

image

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

  1. Query Execution
  2. Admin Tasks

Setup

Clone the repo

Environment Variables

  1. Create a .env file in the project directory
  2. The file should contain the following
  3. 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,

  1. UV package manager command
    • uv run mcp install server.py
  2. Adding the following config to the Claude Config JSON File

Demo

Here are the screenshots / demo of the server execution.

Next Steps