snowflake-mcp-server

What it does

A read-only MCP server for Snowflake by Michael Kania. It lists databases and the views in a schema, describes a view's columns and SQL definition, samples rows from a view with a limit, and runs custom SELECT, SHOW, DESCRIBE, EXPLAIN or WITH statements, returning results as markdown tables; security checks reject anything that would change data. It signs in either as a service account with a private key or through browser-based login, keeps a pooled connection refreshed in the background, and can query several databases in one session. It runs locally over stdio with uv and needs Python 3.12 or later.

Capabilities

List databases and views
Describe a view's columns and definition
Query a view with a row limit
Run read-only SELECT, SHOW, DESCRIBE, EXPLAIN and WITH statements

Install

Follow the project's install instructions

From the project's documentation

Details

Fact	Value	Source
Type	MCP server
Tool	Snowflake
Publisher	Michael Kania	source
Official status	Community (not published by the tool's vendor)	source
Connection	Local (runs on your computer)	source
Can change data	No	source
Needs an API key or sign-in	Yes	source
Platforms	Not stated in its documentation
AI clients	Claude Desktop	source
Licence	MIT	source
Pricing	Not stated in its documentation
Activity	Last commit Apr 28, 202514 GitHub starsDownload data not available (not on npm or PyPI)	source
Links	Repository

Sources

README (README.md)github.com/dynamike/snowflake-mcp-server · Backs: AI clients, Can change data, Connection, Needs an API key or sign-in, Official statusNov 12, 2026
Licence file (LICENSE)github.com/dynamike/snowflake-mcp-server · Backs: Licence, PublisherNov 12, 2026
GitHub repositorygithub.com/dynamike/snowflake-mcp-server · Backs: Activity, LicenceNov 11, 2026
GitHub API recordgithub.com/dynamike/snowflake-mcp-serverNov 10, 2026

How we check listings