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?

A Model Context Protocol (MCP) server enabling Claude to securely perform read-only queries against Snowflake databases. It supports flexible authentication via service account (private key) or external browser login, and includes connection pooling with automatic background refresh.

How to use MCP Server for Snowflake?

Install Python 3.12+ and the uv package manager. Clone the repository, install with uv pip install -e ., configure a .env file with Snowflake credentials, then run as a stdio-based MCP server with uv run snowflake-mcp. Connect to it from Claude Desktop via Settings → MCP Servers.

Key features of MCP Server for Snowflake

Read-only enforcement: SELECT, SHOW, DESCRIBE, EXPLAIN, WITH only
Private key or external browser authentication
Automatic connection pooling with configurable refresh interval
Input validation and automatic LIMIT clauses to prevent large results
Stdio transport for easy Claude Desktop integration

Use cases of MCP Server for Snowflake

List all accessible databases and schema objects
Describe view structure, columns, and SQL definitions
Query sample data from views with optional row limits
Execute custom read-only SQL and receive markdown table results
Compare data across different databases and views in a single session

常见问题

What authentication methods are supported?

Private key authentication for service accounts, or external browser authentication for interactive user login sessions.

What are the required dependencies?

Python 3.12+, the uv package manager, and a Snowflake account with either a configured service account or regular user account.

Can I modify data with this server?

No. The server strictly enforces read-only operations and blocks INSERT, UPDATE, DELETE, and other modification statements.

How can I adjust connection pool refresh timing?

Set the `SNOWFLAKE_CONN_REFRESH_HOURS` environment variable (default 8 hours) to control how often connections are refreshed.

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

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.