Which integrations are available for this server?

Enables natural-language SQL interaction with [Snowflake](/mcp/servers/integrations/snowflake) databases, allowing users to query tables, retrieve data, execute SQL commands, and manage database objects through conversational prompts.

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

Python Snowflake Claude Platform

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