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.)
Read next
- MCP servers for Snowflake3 listed
- Snowflake Labs MCP Serveralso for Snowflake
- Snowflake-managed MCP serveralso for Snowflake
- mcp-snowflake-server (community) and Snowflake-managed MCP server, side by side
- mcp-snowflake-server (community) and Snowflake Labs MCP Server, side by side
- The Context Weight Index
Sources
- raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md, read 10 Nov 2026
- pypi.org/pypi/mcp-snowflake-server/json, read 10 Nov 2026
Last reviewed 10 Nov 2026.