Snowflake MCP Server

A Model Context Protocol (MCP) server / MCP server that connects AI assistants to Snowflake - enabling SQL queries, schema exploration, and data insights directly from your LLM client. Its 8 documented tools cluster into read & search, create & write, append. It runs locally over stdio via the published package.

People who work with snowflake, agentic ai and database and want it reachable from Claude, Cursor, VS Code, or another MCP client. The project is written in Python.

VERIFIED ACTIVE

LAST COMMIT 2026-09-17 · ★ 2 · #69 OF 168 MAINTAINED DATABASE · VERIFIED 2026-09-18

MIT · Python servers · how we verify → /methodology

01 · Install Snowflake MCP Server

before you install - you'll need

Set SNOWFLAKE_USER, SNOWFLAKE_ACCOUNT, SNOWFLAKE_AUTHENTICATOR, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_ROLE, SNOWFLAKE_OAUTH_CLIENT_ID, SNOWFLAKE_OAUTH_CLIENT_SECRET before connecting. SNOWFLAKE_PASSWORD, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_PRIVATE_KEY_FILE, SNOWFLAKE_PRIVATE_KEY_FILE_PWD are optional or environment-specific per the README.

Claude Code

claude mcp add nsphung-mcp-snowflake-server -- uvx mcp-snowflake-server-nsp

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "nsphung-mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ]
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions · container (OCI image) - can be sandboxed away from your filesystem

license MIT - declared in the repository

pypi package mcp-snowflake-server-nsp - check the name against the project README before installing (PyPI has no namespace ownership)

registry namespace io.github.nsphung is GitHub-verified and matches the repo owner

03 · What Snowflake MCP Server can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

What you can build

With this server connected, an agent can list all databases in the Snowflake instance, list all schemas within a database, list all tables within a database and schema, and describe columns of a table (name, type, nullability, default, comment).

Capability map

Tools grouped from the project's README - what Snowflake MCP Server lets an agent do.

read & search

5 tools - e.g. Execute SELECT queries. Input: query (string).; List all databases in the Snowflake instance.; List all schemas within a database.

read_query · list_databases · list_schemas · list_tables · describe_table

create & write

2 tools - e.g. Execute INSERT, UPDATE, or DELETE queries. Input: query (string).; Execute CREATE TABLE statements. Input: query (string).

write_query · create_table

Append

1 tool - e.g. Add a data insight to the memo://insights resource.

append_insight

Latest releases

v0.14.3 · 2026-09-04

0.14.3 (2026-09-04) · bump pypa/gh-action-pypi-publish to v1.14.2 for metadata v2.5 support

v0.14.2 · 2026-09-04

0.14.2 (2026-09-04) · update security dependency constraints · Miscellaneous · deps-dev: bump the patch-updates group with 2 updates · deps-dev: bump types-pyyaml from 6.0.12.20260518 to 6.0.12.20260724 · bump…

v0.14.1 · 2026-07-24

0.14.1 (2026-07-24) · Miscellaneous · deps-dev: bump prek from 0.4.4 to 0.4.5 in the patch-updates group · deps-dev: bump pytest from 9.0.3 to 9.1.0 in the minor-updates group · deps-dev: bump the patch-updates group…

04 · Who maintains Snowflake MCP Server

Snowflake MCP Server is maintained by nsphung. It's the only MCP server we track from this author; the repo dates to Sep 2025.

05 · Facts

repository: github.com/nsphung/mcp-snowflake-server
category: database - ranked #69 of 168 actively-maintained database servers as of 2026-09-18.
release cadence: 3 releases in the last 90 days (latest 2026-09-04)
registry: io.github.nsphung/mcp-snowflake-server (active, first published 2026-04-28 · 13 versions)
packages: pypi:mcp-snowflake-server-nsp · oci:docker.io/nsphung/mcp-snowflake-server-nsp:0.14.3

06 · Snowflake MCP Server FAQ

Is Snowflake MCP Server still maintained?

Yes - as of 2026-09-18, its last commit was 2026-09-17 and it shipped 3 releases in the last 90 days. We re-verify nightly.

What can Snowflake MCP Server do?

How do I install Snowflake MCP Server?

Run `uvx mcp-snowflake-server-nsp`. The README documents 12 environment variables (SNOWFLAKE_USER, SNOWFLAKE_ACCOUNT, SNOWFLAKE_AUTHENTICATOR…) to set first. Set SNOWFLAKE_USER, SNOWFLAKE_ACCOUNT, SNOWFLAKE_AUTHENTICATOR, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_ROLE, SNOWFLAKE_OAUTH_CLIENT_ID, SNOWFLAKE_OAUTH_CLIENT_SECRET before connecting. SNOWFLAKE_PASSWORD, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_PRIVATE_KEY_FILE, SNOWFLAKE_PRIVATE_KEY_FILE_PWD are optional or environment-specific per the README. You can also paste the ready-made client config above.

Does Snowflake MCP Server run locally?

Yes - it's a stdio server: it runs on your machine (via uvx) with your user's permissions. Your data stays local unless the server itself calls external APIs.

07 · Alternatives to Snowflake MCP Server

Alternatives to Snowflake MCP Server

Maintained database servers if Snowflake MCP Server isn't the fit.

Pairs well with

Servers that cover what Snowflake MCP Server doesn't - only shown when the pairing reason fits the companion.

More database MCP servers · Dynoxide · Octopus Blackboard · SQLite · GLEIF MCP Server · Ouestcharlie Woof

More Python MCP servers · AGENTS.md Generator · NVEIL · Claude Memory Manager · DICOM/HL7/FHIR Interoperability MCP Server · Aseprite Live · see all