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

SERVER, read 10 Nov 2026

**The short answer.** mcp-snowflake-server (community) is a community MCP server for Snowflake, published by isaacwasserman and read from its own source on 10 Nov 2026. It runs local (stdio), and 8 tools are named. Version read: 0.4.0. Last release: 10 Apr 2025. Auth: Snowflake user credentials (password, private key, external browser) or connections.toml.

- **Data tool:** [Snowflake](/mcp/snowflake/)
- **Publisher:** isaacwasserman (community)
- **Kind:** Community
- **Repository or docs:** [github.com/isaacwasserman/mcp-snowflake-server](https://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](https://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](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md).

## 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](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), 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](https://pypi.org/pypi/mcp-snowflake-server/json), 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](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), read 10 Nov 2026.)
- When prefetch is enabled it exposes per-table schema summaries as resources. (isaacwasserman's own claim; [source](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), read 10 Nov 2026.)

### Access and safety

- Write operations are disabled by default and enabled only with --allow-write. (isaacwasserman's own claim; [source](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), read 10 Nov 2026.)
- Tool exclusion and database/schema/table exclusion patterns are supported. (isaacwasserman's own claim; [source](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), 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](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), read 10 Nov 2026.)

### What it reaches

- Covers Snowflake only. (isaacwasserman's own claim; [source](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), 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](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), 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](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), 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](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), 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](https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md), read 10 Nov 2026.)

## Read next

- [MCP servers for Snowflake](/mcp/snowflake/): 3 listed
- [Snowflake Labs MCP Server](/servers/snowflake-labs-mcp/): also for Snowflake
- [Snowflake-managed MCP server](/servers/snowflake-managed-mcp/): also for Snowflake
- [mcp-snowflake-server (community) and Snowflake-managed MCP server, side by side](/compare/isaacwasserman-mcp-snowflake-server-vs-snowflake-managed-mcp/)
- [mcp-snowflake-server (community) and Snowflake Labs MCP Server, side by side](/compare/isaacwasserman-mcp-snowflake-server-vs-snowflake-labs-mcp/)
- [The Context Weight Index](/context-weight/)

## Sources

- raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md: https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md (read 10 Nov 2026)
- pypi.org/pypi/mcp-snowflake-server/json: https://pypi.org/pypi/mcp-snowflake-server/json (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datamcpservers.com/servers/isaacwasserman-mcp-snowflake-server/
