Skip to content
Data MCP Directory

SERVER, read 10 Nov 2026

mcp-snowflake-server (community): 8 tools, local (stdio), from isaacwasserman

MCP servers for SnowflakeBack to the directory

Data tool
Snowflake
Publisher
isaacwasserman (community)
Kind
Community
Repository or docs
github.com/isaacwasserman/mcp-snowflake-server
Version or commit
0.4.0
Last release
10 Apr 2025
Transport
Local (stdio)
Auth
Snowflake user credentials (password, private key, external browser) or connections.toml.
Access
Configurable
Tools listed
8 named in the evidence
Tool definitions read at
raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md
Context weight
103 tokens for 8 tool definitions (8 with a description), measured from the README read
Status
Exists as a community server; PyPI 0.4.0 dated 10 Apr 2025, GitHub pushed 7 Oct 2025 (GitHub API).
Read
10 Nov 2026

In one sentence

A community server for schema browsing and read-only SQL on Snowflake, with write tools off by default.

What mcp-snowflake-server (community) exposes

8 tools are named in the evidence read on 10 Nov 2026.

read_query write_query create_table list_databases list_schemas list_tables describe_table append_insight

Not found in the sources read

  • A lineage or dependency tool in the README tool list. Source.

The evidence on mcp-snowflake-server (community), by topic

Publisher and releases

  • The server is a community project by isaacwasserman, not published by Snowflake; license is GPL-3.0 per GitHub API. (isaacwasserman's own claim; source, read 10 Nov 2026.)
  • PyPI lists mcp-snowflake-server 0.4.0 uploaded 10 Apr 2025; the GitHub repo was last pushed 7 Oct 2025. (observed in the source; source, read 10 Nov 2026.)

Clients, auth and scoping

  • The server exposes a memo://insights resource and an append_insight tool that stores agent-discovered insights. (isaacwasserman's own claim; source, read 10 Nov 2026.)
  • When prefetch is enabled it exposes per-table schema summaries as resources. (isaacwasserman's own claim; source, read 10 Nov 2026.)

Access and safety

  • Write operations are disabled by default and enabled only with --allow-write. (isaacwasserman's own claim; source, read 10 Nov 2026.)
  • Tool exclusion and database/schema/table exclusion patterns are supported. (isaacwasserman's own claim; source, read 10 Nov 2026.)
  • Authentication uses Snowflake user credentials, a private key path or external browser; the README shows plain passwords in config. (isaacwasserman's own claim; source, read 10 Nov 2026.)

What it reaches

  • Covers Snowflake only. (isaacwasserman's own claim; source, read 10 Nov 2026.)

Lineage and impact

  • Schema tools list databases, schemas, tables and describe columns; no lineage tool is listed. (isaacwasserman's own claim; source, read 10 Nov 2026.)

Definitions, ownership and rules

  • Describe_table returns column names, types, nullability, defaults and comments, so table and column comments reach the agent. (isaacwasserman's own claim; source, read 10 Nov 2026.)

Freshness and upkeep

  • Metadata is read live from Snowflake on each tool call; no scheduled collection is described. (isaacwasserman's own claim; source, read 10 Nov 2026.)

Profile

  • Run via uvx or uv with stdio for Claude Desktop; install via Smithery is also documented. (isaacwasserman's own claim; source, read 10 Nov 2026.)

Sources

  1. raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md, read 10 Nov 2026
  2. pypi.org/pypi/mcp-snowflake-server/json, read 10 Nov 2026

Last reviewed 10 Nov 2026.