MCP Server for Snowflake

@dynamike

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

dynamike

关于 MCP Server for Snowflake

MCP Server for connecting to Snowflake with read-only questions

#snowflake #modelcontextprotocol

MCP Server for Snowflake 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MCP Server for Snowflake 工具

List all accessible Snowflake databases

List all views in a specified database and schema

Get detailed information about a specific view including columns and SQL definition

Query data from a view with an optional row limit

Execute custom read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) with results formatted as markdown tables

概览

What is MCP Server for Snowflake?

MCP Server for Snowflake is a Model Context Protocol server that enables Claude to perform read-only queries against Snowflake databases. It uses either service account private key or external browser authentication and supports multiple SQL statement types (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) with automatic result formatting.

How to use MCP Server for Snowflake?

Install the package with uv pip install -e . after cloning, configure a .env file with Snowflake credentials and chosen authentication type, then run uv run snowflake-mcp or uv run snowflake-mcp-stdio. For Claude Desktop, add a custom MCP server pointing to the uv command with the appropriate arguments.

Key features of MCP Server for Snowflake

Read-only operations with security checks to prevent data modification
Flexible authentication (private key or external browser)
Connection pooling with automatic background refresh
Support for querying multiple views and databases in a single session
MCP-compatible handlers for querying Snowflake data
Stdio-based MCP server for easy integration with Claude Desktop

Use cases of MCP Server for Snowflake

List all accessible databases in a Snowflake account
Describe the structure and SQL definition of specific views
Query sample data from a view with an optional row limit
Execute custom read-only SQL queries and get results as markdown tables
Compare data from views in different databases within one session

常见问题

What authentication methods are supported?

Two methods: private key authentication (service account with private key file) and external browser authentication (opens a browser window for interactive login).

Is MCP Server for Snowflake safe for production use?

Yes. The server enforces read-only operations, automatically adds LIMIT clauses to prevent large result sets, validates inputs to prevent SQL injection, and requires explicit authentication — the `.env` file should never be committed to version control.

How do I configure the connection pool refresh interval?

Set the environment variable `SNOWFLAKE_CONN_REFRESH_HOURS` to the desired number of hours. The default is 8 hours.

What SQL statements are allowed?

Only SELECT, SHOW, DESCRIBE, EXPLAIN, and WITH statements are permitted; all data modification queries are rejected.

What Python version does MCP Server for Snowflake require?

Python 3.12 or higher.

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

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

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