Snowflake MCP Server

Name: Snowflake MCP Server
Author: isaacwasserman

@isaacwasserman

Repository

About Snowflake MCP Server

No overview available yet

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Snowflake MCP Server?

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

How to use Snowflake MCP Server?

Install via Smithery (npx -y @smithery/cli install mcp_snowflake_server --client claude) or locally using uvx. Configure with Snowflake credentials via environment variables, individual parameters, or a TOML connections file, then add the server to your claude_desktop_config.json. Invoke tools such as read_query, write_query, list_databases, list_schemas, list_tables, describe_table, and append_insight.

Key features of Snowflake MCP Server

Execute SELECT queries with the read_query tool
Write operations (INSERT, UPDATE, DELETE) via write_query (requires --allow-write)
Create tables with the create_table tool (requires --allow-write)
List databases, schemas, and tables with schema discovery tools
Describe table columns including names, types, nullability, defaults, and comments
Append and aggregate data insights in a dynamic memo://insights resource
Support for TOML-based multi-connection configuration

Use cases of Snowflake MCP Server

Run ad-hoc SQL queries on Snowflake from an MCP client
Explore database schema (databases, schemas, tables, columns) interactively
Log and accumulate data insights during analysis sessions
Perform controlled write operations (insert, update, delete, create table) when explicitly enabled

FAQ from Snowflake MCP Server

How do I enable write operations?

Write operations (write_query, create_table) are disabled by default. Enable them with the --allow-write flag.

What authentication methods are supported?

The server supports password-based authentication, private key authentication (--private_key_path), and external browser authentication (SNOWFLAKE_AUTHENTICATOR="externalbrowser").

Can I exclude certain databases, schemas, or tables?

Yes. You can set exclusion patterns via a runtime_config.json file.

How are data insights managed?

Use the append_insight tool to add insights, which automatically updates the memo://insights resource. Insights are aggregated in this dynamic memo.

What transports and configuration formats are available?

The server uses stdio transport. Configuration can be provided via environment variables, individual command-line arguments, or a TOML connections file (recommended for multiple connections).

Comments

More Databases MCP servers

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245