Snowflake MCP Server

@isaacwasserman

代码仓库

基本信息

分类

数据库

许可证

GPL-3.0

传输方式

stdio

作者

isaacwasserman

关于 Snowflake MCP Server

暂无概览

Snowflake MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

Snowflake MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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

常见问题

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).

数据库分类下的更多 MCP 服务器

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes