What authentication methods are supported?

Supports username/password, private key file, or external browser authentication via environment variables.

How are data insights managed?

Insights can be appended using the append_insight tool and are aggregated in the memo://insights resource.

Can I prefetch schema information?

Yes, with prefetch enabled, per-table schema summaries are exposed as context resources.

What environment variables are required?

You must set Snowflake credentials such as SNOWFLAKE_USER, SNOWFLAKE_ACCOUNT, SNOWFLAKE_ROLE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_WAREHOUSE, and SNOWFLAKE_PASSWORD or SNOWFLAKE_PRIVATE_KEY_PATH.

MCP Snowflake Server

snowflakedatabasesqlschemainsights

MCP server enabling SQL read/write and schema insight operations on Snowflake databases.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "isaacwasserman-mcp-snowflake-server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli"
      ]
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Overview

This MCP server provides tools to interact with Snowflake databases, supporting SQL query execution, schema exploration, and data insight tracking. It offers read-only operations by default and optional write capabilities when enabled. Use it to integrate Snowflake data access and metadata into AI agent workflows requiring database context and insights.

Use cases

Execute SELECT queries on Snowflake data

Run INSERT/UPDATE/DELETE queries with write enabled

Explore database schemas, tables, and columns

Create new tables in Snowflake

Track and append data insights for analysis

Key features

Read SQL queries via read_query tool

Write SQL queries and create tables with --allow-write

List databases, schemas, and tables

Describe table schema details

Append and aggregate data insights as memo resource

Capabilities & Tool Schemas (15)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by MCP Snowflake Server.

read_query

Callable MCP tool function

query

Callable MCP tool function

SELECT

Callable MCP tool function

write_query

Callable MCP tool function

create_table

Callable MCP tool function

list_databases

Callable MCP tool function

Documentation Overview

Snowflake MCP Server

Overview

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake. This server enables running SQL queries via tools and exposes data insights and schema context as resources.

Components

Resources

memo://insights
A continuously updated memo aggregating discovered data insights.
Updated automatically when new insights are appended via the append_insight tool.
context://table/{table_name}
(If prefetch enabled) Per-table schema summaries, including columns and comments, exposed as individual resources.

Tools

The server exposes the following tools:

Query Tools

read_query
Execute SELECT queries to read data from the database.
Input:
- query (string): The SELECT SQL query to execute
  Returns: Query results as array of objects
write_query (enabled only with --allow-write)
Execute INSERT, UPDATE, or DELETE queries.
Input:
- query (string): The SQL modification query
  Returns: Number of affected rows or confirmation
create_table (enabled only with --allow-write)
Create new tables in the database.
Input:
- query (string): CREATE TABLE SQL statement
  Returns: Confirmation of table creation

Schema Tools

list_databases
List all databases in the Snowflake instance.
Returns: Array of database names
list_schemas
List all schemas within a specific database.
Input:
- database (string): Name of the database
  Returns: Array of schema names
list_tables
List all tables within a specific database and schema.
Input:
- database (string): Name of the database
- schema (string): Name of the schema
  Returns: Array of table metadata
describe_table
View column information for a specific table.
Input:
- table_name (string): Fully qualified table name (database.schema.table)
  Returns: Array of column definitions with names, types, nullability, defaults, and comments

Analysis Tools

append_insight
Add new data insights to the memo resource.
Input:
- insight (string): Data insight discovered from analysis
  Returns: Confirmation of insight addition
  Effect: Triggers update of memo://insights resource

Usage with Claude Desktop

Installing via Smithery

To install Snowflake Server for Claude Desktop automatically via Smithery:

Terminal

npx -y @smithery/cli install mcp_snowflake_server --client claude

Installing via UVX

Traditional Configuration (Individual Parameters)

json

"mcpServers": {
  "snowflake_pip": {
    "command": "uvx",
    "args": [
      "--python=3.12",  // Optional: specify Python version <=3.12
      "mcp_snowflake_server",
      "--account", "your_account",
      "--warehouse", "your_warehouse",
      "--user", "your_user",
      "--password", "your_password",
      "--role", "your_role",
      "--database", "your_database",
      "--schema", "your_schema"
      // Optionally: "--private_key_path", "your_private_key_absolute_path"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

TOML Configuration (Recommended)

json

"mcpServers": {
  "snowflake_production": {
    "command": "uvx",
    "args": [
      "--python=3.12",
      "mcp_snowflake_server",
      "--connections-file", "/path/to/snowflake_connections.toml",
      "--connection-name", "production"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  },
  "snowflake_staging": {
    "command": "uvx",
    "args": [
      "--python=3.12",
      "mcp_snowflake_server",
      "--connections-file", "/path/to/snowflake_connections.toml",
      "--connection-name", "staging"
    ]
  }
}

Installing Locally

Install Claude AI Desktop App
Install uv:

Terminal

curl -LsSf https://astral.sh/uv/install.sh | sh

Create a .env file with your Snowflake credentials:

bash

SNOWFLAKE_USER="xxx@your_email.com"
SNOWFLAKE_ACCOUNT="xxx"
SNOWFLAKE_ROLE="xxx"
SNOWFLAKE_DATABASE="xxx"
SNOWFLAKE_SCHEMA="xxx"
SNOWFLAKE_WAREHOUSE="xxx"
SNOWFLAKE_PASSWORD="xxx"
SNOWFLAKE_PASSWORD="xxx"
SNOWFLAKE_PRIVATE_KEY_PATH=/absolute/path/key.p8
# Alternatively, use external browser authentication:
# SNOWFLAKE_AUTHENTICATOR="externalbrowser"

[Optional] Modify runtime_config.json to set exclusion patterns for databases, schemas, or tables.
Test locally:

bash

uv --directory /absolute/path/to/mcp_snowflake_server run mcp_snowflake_server

Add the server to your claude_desktop_config.json:

Traditional Configuration (Using Environment Variables)

json

"mcpServers": {
  "snowflake_local": {
    "command": "/absolute/path/to/uv",
    "args": [
      "--python=3.12",  // Optional
      "--directory", "/absolute/path/to/mcp_snowflake_server",
      "run", "mcp_snowflake_server"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

TOML Configuration (Recommended)

json

"mcpServers": {
  "snowflake_local": {
    "command": "/absolute/path/to/uv",
    "args": [
      "--python=3.12",
      "--directory", "/absolute/path/to/mcp_snowflake_server",
      "run", "mcp_snowflake_server",
      "--connections-file", "/absolute/path/to/snowflake_connections.toml",
      "--connection-name", "development"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

Notes

By default, write operations are disabled. Enable them explicitly with --allow-write.
The server supports filtering out specific databases, schemas, or tables via exclusion patterns.
The server exposes additional per-table context resources if prefetching is enabled.
The append_insight tool updates the memo://insights resource dynamically.

License

MIT

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

186

Stargazers on the source repository.

npm downloads

30k

Package downloads in the last 30 days.

Last commit

11mo ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Directory activity

2 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about MCP Snowflake Server

Start the server with the --allow-write flag to enable write_query and create_table tools.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

MCP Snowflake Server AllMCPs Directory Badge

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/isaacwasserman-mcp-snowflake-server?style=directory)](https://allmcps.com/mcp/isaacwasserman-mcp-snowflake-server)

HTML Embed

<a href="https://allmcps.com/mcp/isaacwasserman-mcp-snowflake-server"><img src="https://allmcps.com/api/badge/isaacwasserman-mcp-snowflake-server?style=directory" alt="MCP Snowflake Server on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

PricingBring your own API key (usage-based cost)

13/13 checks healthy over the last 32d

60Quality signal: Good · 60/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools27/30

Adoption & activity8/15

Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 23d ago via OSV.dev · @smithery/cli (npm)

★ Featured

Moxie Docs MCP

MCP & Agent Skills for Automated Documentation, and codebase conventions + context

Explore Server →

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge — proof is checked automatically, then reviewed by our team.

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to MCP Snowflake Server →Install in Claude Desktop Install in Cursor Install in VS Code

MCP Snowflake Server

snowflakedatabasesqlschemainsights

MCP server enabling SQL read/write and schema insight operations on Snowflake databases.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "isaacwasserman-mcp-snowflake-server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli"
      ]
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Overview

Use cases

Execute SELECT queries on Snowflake data

Run INSERT/UPDATE/DELETE queries with write enabled

Explore database schemas, tables, and columns

Create new tables in Snowflake

Track and append data insights for analysis

Key features

Read SQL queries via read_query tool

Write SQL queries and create tables with --allow-write

List databases, schemas, and tables

Describe table schema details

Append and aggregate data insights as memo resource

Capabilities & Tool Schemas (15)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by MCP Snowflake Server.

read_query

Callable MCP tool function

query

Callable MCP tool function

SELECT

Callable MCP tool function

write_query

Callable MCP tool function

create_table

Callable MCP tool function

list_databases

Callable MCP tool function

Documentation Overview

Snowflake MCP Server

Overview

Components

Resources

memo://insights
A continuously updated memo aggregating discovered data insights.
Updated automatically when new insights are appended via the append_insight tool.
context://table/{table_name}
(If prefetch enabled) Per-table schema summaries, including columns and comments, exposed as individual resources.

Tools

The server exposes the following tools:

Query Tools

read_query
Execute SELECT queries to read data from the database.
Input:
- query (string): The SELECT SQL query to execute
  Returns: Query results as array of objects
write_query (enabled only with --allow-write)
Execute INSERT, UPDATE, or DELETE queries.
Input:
- query (string): The SQL modification query
  Returns: Number of affected rows or confirmation
create_table (enabled only with --allow-write)
Create new tables in the database.
Input:
- query (string): CREATE TABLE SQL statement
  Returns: Confirmation of table creation

Schema Tools

list_databases
List all databases in the Snowflake instance.
Returns: Array of database names
list_schemas
List all schemas within a specific database.
Input:
- database (string): Name of the database
  Returns: Array of schema names
list_tables
List all tables within a specific database and schema.
Input:
- database (string): Name of the database
- schema (string): Name of the schema
  Returns: Array of table metadata
describe_table
View column information for a specific table.
Input:
- table_name (string): Fully qualified table name (database.schema.table)
  Returns: Array of column definitions with names, types, nullability, defaults, and comments

Analysis Tools

append_insight
Add new data insights to the memo resource.
Input:
- insight (string): Data insight discovered from analysis
  Returns: Confirmation of insight addition
  Effect: Triggers update of memo://insights resource

Usage with Claude Desktop

Installing via Smithery

To install Snowflake Server for Claude Desktop automatically via Smithery:

Terminal

npx -y @smithery/cli install mcp_snowflake_server --client claude

Installing via UVX

Traditional Configuration (Individual Parameters)

json

"mcpServers": {
  "snowflake_pip": {
    "command": "uvx",
    "args": [
      "--python=3.12",  // Optional: specify Python version <=3.12
      "mcp_snowflake_server",
      "--account", "your_account",
      "--warehouse", "your_warehouse",
      "--user", "your_user",
      "--password", "your_password",
      "--role", "your_role",
      "--database", "your_database",
      "--schema", "your_schema"
      // Optionally: "--private_key_path", "your_private_key_absolute_path"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

TOML Configuration (Recommended)

json

"mcpServers": {
  "snowflake_production": {
    "command": "uvx",
    "args": [
      "--python=3.12",
      "mcp_snowflake_server",
      "--connections-file", "/path/to/snowflake_connections.toml",
      "--connection-name", "production"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  },
  "snowflake_staging": {
    "command": "uvx",
    "args": [
      "--python=3.12",
      "mcp_snowflake_server",
      "--connections-file", "/path/to/snowflake_connections.toml",
      "--connection-name", "staging"
    ]
  }
}

Installing Locally

Install Claude AI Desktop App
Install uv:

Terminal

curl -LsSf https://astral.sh/uv/install.sh | sh

Create a .env file with your Snowflake credentials:

bash

SNOWFLAKE_USER="xxx@your_email.com"
SNOWFLAKE_ACCOUNT="xxx"
SNOWFLAKE_ROLE="xxx"
SNOWFLAKE_DATABASE="xxx"
SNOWFLAKE_SCHEMA="xxx"
SNOWFLAKE_WAREHOUSE="xxx"
SNOWFLAKE_PASSWORD="xxx"
SNOWFLAKE_PASSWORD="xxx"
SNOWFLAKE_PRIVATE_KEY_PATH=/absolute/path/key.p8
# Alternatively, use external browser authentication:
# SNOWFLAKE_AUTHENTICATOR="externalbrowser"

[Optional] Modify runtime_config.json to set exclusion patterns for databases, schemas, or tables.
Test locally:

bash

uv --directory /absolute/path/to/mcp_snowflake_server run mcp_snowflake_server

Add the server to your claude_desktop_config.json:

Traditional Configuration (Using Environment Variables)

json

"mcpServers": {
  "snowflake_local": {
    "command": "/absolute/path/to/uv",
    "args": [
      "--python=3.12",  // Optional
      "--directory", "/absolute/path/to/mcp_snowflake_server",
      "run", "mcp_snowflake_server"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

TOML Configuration (Recommended)

json

"mcpServers": {
  "snowflake_local": {
    "command": "/absolute/path/to/uv",
    "args": [
      "--python=3.12",
      "--directory", "/absolute/path/to/mcp_snowflake_server",
      "run", "mcp_snowflake_server",
      "--connections-file", "/absolute/path/to/snowflake_connections.toml",
      "--connection-name", "development"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

Notes

By default, write operations are disabled. Enable them explicitly with --allow-write.
The server supports filtering out specific databases, schemas, or tables via exclusion patterns.
The server exposes additional per-table context resources if prefetching is enabled.
The append_insight tool updates the memo://insights resource dynamically.

License

MIT

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

186

Stargazers on the source repository.

npm downloads

30k

Package downloads in the last 30 days.

Last commit

11mo ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Directory activity

2 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about MCP Snowflake Server

Start the server with the --allow-write flag to enable write_query and create_table tools.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/isaacwasserman-mcp-snowflake-server?style=directory)](https://allmcps.com/mcp/isaacwasserman-mcp-snowflake-server)

HTML Embed

<a href="https://allmcps.com/mcp/isaacwasserman-mcp-snowflake-server"><img src="https://allmcps.com/api/badge/isaacwasserman-mcp-snowflake-server?style=directory" alt="MCP Snowflake Server on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

PricingBring your own API key (usage-based cost)

13/13 checks healthy over the last 32d

60Quality signal: Good · 60/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools27/30

Adoption & activity8/15

Community engagement0/10

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 23d ago via OSV.dev · @smithery/cli (npm)

★ Featured

Moxie Docs MCP

MCP & Agent Skills for Automated Documentation, and codebase conventions + context

Explore Server →

Own this project?

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to MCP Snowflake Server →Install in Claude Desktop Install in Cursor Install in VS Code