# 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
```bash
git clone https://github.com/your-username/snowflake-mcp-server.git
cd snowflake-mcp-server
```
2. Install Dependencies
```bash
pip install -r server/requirements.txt
```
3. Set Up Environment Variables
```Create a .env file (NOT committed to GitHub):
SNOWFLAKE_USER=your_user
SNOWFLAKE_PASSWORD=your_password
SNOWFLAKE_ACCOUNT=your_account
SNOWFLAKE_WAREHOUSE=your_wh
SNOWFLAKE_DATABASE=your_db
SNOWFLAKE_SCHEMA=your_schema
```
4. Run the MCP Server
```bash
python server/snowflake_mcp_server.py
Expected output:
MCP Snowflake Server started...
Listening for Claude Desktop connections…
```
5. Configure Claude Desktop JSON
```Add this block to your Claude Desktop config:
{
"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
