本文へスキップ
Kitbay
掲載依頼
MCPサーバー

snowflake-mcp-server

ローカルで動作MIT2025年4月28日 更新14GitHubスターAPIキーが必要

A read-only MCP server for Snowflake by Michael Kania.

このサーバーについて

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.

できること

  • 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