Local-Snowflake-MCP-Server
A local Model Context Protocol (MCP) server that enables Claude Desktop to interact with a Snowflake database through natural-language SQL. Built in Python, this project demonstrates how modern LLMs can integrate with enterprise data systems using secure, local tooling.
🔗 Badges
Overview
This repository contains:
- A Python MCP server (
snowflake_mcp_server.py) - Instructions/Code in README for the claude_desktop_config.json file
- Screenshots and documentation showing the MCP server running locally
- Instructions for connecting Claude → MCP Server → Snowflake securely
This project demonstrates how to use MCP to build custom AI-powered database tooling.
Repository Structure
snowflake-mcp-server/
│
├── server/
│ ├── snowflake_mcp_server.py
│ ├── requirements.txt
│
├── docs/
│ ├── screenshots/
│
└── README.md
Getting Started
1. Clone the Repository
git clone https://github.com/your-username/snowflake-mcp-server.git
cd snowflake-mcp-server
- Install Dependencies
pip install -r server/requirements.txt
- Set Up Environment Variables
SNOWFLAKE_USER=your_user
SNOWFLAKE_PASSWORD=your_password
SNOWFLAKE_ACCOUNT=your_account
SNOWFLAKE_WAREHOUSE=your_wh
SNOWFLAKE_DATABASE=your_db
SNOWFLAKE_SCHEMA=your_schema
- Run the MCP Server
python server/snowflake_mcp_server.py
Expected output:
MCP Snowflake Server started...
Listening for Claude Desktop connections…
- Configure Claude Desktop JSON
{
"mcpServers": {
"snowflake": {
"command": "your_env_path",
"args": [
"your_server_path.py"
],
"env": {
"SF_ACCOUNT": "account_name",
"SF_USER": "username",
"SF_PASSWORD": "password",
"SF_WH": "warehouse_name",
"SF_DB": "database_name",
"SF_SCHEMA": "schema_name"
},
"autoStart": true
}
}
}
Restart Claude. The tool should appear automatically.
Example Claude Prompts “Run a query to list the tables in my schema.”
“Show the top 10 rows from MY_TABLE.”
“Explain what this SQL query does and suggest optimizations.”
“Create a table called DEMO_TEST with sample values.”
🧱 Architecture
Claude Desktop
│
▼
Local MCP Server (Python)
│
▼
Snowflake Database
Security Notes (Important!) This repo does not include:
❌ Snowflake credentials ❌ Hardcoded passwords ❌ Personal account identifiers