snowflake-mcp

Snowflake MCP server built with FastMCP.

Quick Start

Windows PowerShell

python -m venv .venv
.venv\Scripts\activate
pip install -r requirements.txt

macOS / Linux

python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt

Related MCP server: Snowflake MCP Server

Configuration

Create an empty .env file in the project root with follwing credentials.

Provide credentials through environment variables configuration.

You can also copy the values from .env.example into .env and fill in your Snowflake details.

- SNOWFLAKE_ACCOUNT
- SNOWFLAKE_USER
- SNOWFLAKE_PASSWORD
- SNOWFLAKE_WAREHOUSE
- SNOWFLAKE_DATABASE
- SNOWFLAKE_SCHEMA
- SNOWFLAKE_ROLE
- SNOWFLAKE_ALLOW_WRITE=false

Keep SNOWFLAKE_ALLOW_WRITE=false unless you want to allow write operations.

Use the VS Code MCP start button in .vscode/mcp.json to launch the server.

Tools

• list_databases

• list_schemas

• list_tables

• describe_table

• read_query

• write_query

• create_table

• append_insight