Snowflake MCP Server

io.github.nsphung/mcp-snowflake-server

7/8 checks passed
Runs locally
4 secrets
★ 2 GitHub stars
Updated 2026-09-24
Health score 56

About Snowflake MCP Server

Snowflake MCP Server is an MCP server published by the GitHub account nsphung. A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants

It runs on your own machine: your AI client starts it from the PyPI package mcp-snowflake-server-nsp at version 0.14.4.

It asks for 4 secrets: SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_OAUTH_CLIENT_SECRET and SNOWFLAKE_TOKEN. Give it a key with the least access that still works.

Version 0.14.4 was published on 24 September 2026, and the source code is public, so you can read it before installing.

Written from the registry entry. 9 automated checks on the registry entry and the package code: 7 pass, 1 warn, 0 fail, 1 info. How we check.

What it asks for

Variable	Required	Secret	Description
`SNOWFLAKE_ACCOUNT`	No	No	Snowflake account identifier
`SNOWFLAKE_USER`	No	No	Snowflake username
`SNOWFLAKE_PASSWORD`	No	Yes	Password (not required for key-pair / SSO)
`SNOWFLAKE_WAREHOUSE`	No	No	Virtual warehouse to use
`SNOWFLAKE_DATABASE`	No	No	Default database
`SNOWFLAKE_SCHEMA`	No	No	Default schema
`SNOWFLAKE_ROLE`	No	No	Role to assume
`SNOWFLAKE_AUTHENTICATOR`	No	No	Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials
`SNOWFLAKE_PRIVATE_KEY_FILE`	No	No	Absolute path to .p8 private key file
`SNOWFLAKE_PRIVATE_KEY_FILE_PWD`	No	Yes	Passphrase for encrypted private key
`SNOWFLAKE_OAUTH_CLIENT_ID`	No	No	OAuth 2.0 client ID (required for oauth_client_credentials authenticator)
`SNOWFLAKE_OAUTH_CLIENT_SECRET`	No	Yes	OAuth 2.0 client secret (required for oauth_client_credentials authenticator)
`SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL`	No	No	OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)
`SNOWFLAKE_OAUTH_SCOPE`	No	No	OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)
`SNOWFLAKE_TOKEN`	No	Yes	Pre-fetched OAuth bearer token (required for oauth authenticator)

Checks

Check	Result	Detail
Source repository linked	Pass	https://github.com/nsphung/mcp-snowflake-server
Version pinned	Pass	Every package has an explicit version
Secrets requested	Warn	Asks for 4 secrets: SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_TOKEN
Known package registry	Pass	All packages come from npm, PyPI, OCI, NuGet or MCPB
Namespace ownership	Info	Name verified via GitHub account nsphung
Registry text aimed at the AI	Pass	Description and settings contain no hidden characters or instructions to the AI
Install scripts	Pass	mcp-snowflake-server-nsp 0.14.4 has no setup.py; nothing runs at install
Code red flags	Pass	Read 40 files in mcp-snowflake-server-nsp 0.14.4: no obfuscation, encoded execution, credential reads or data-collection endpoints found
Text aimed at the AI	Pass	No hidden characters or instructions to the AI in 40 files, including comments and the README

Popularity & health: 56 / 100

Worked out from public numbers and our own checks, not from user reviews or ratings. It says how used and how looked-after a server is, not whether it is safe.

Popularity10 / 40

2 GitHub stars, 95 downloads last week, no Hacker News posts found. Best two of the three, each on a log scale.

Activity23 / 25

Last push 2026-10-28, last release 2026-09-24, 28 commits in 90 days.

Issue health8 / 15

2 closed of 6 issues, too few to judge. No data, so half marks.

Our checks16 / 20

1 warning, each costing a fifth.

0 forks, 123 merged pull requests. Sources: GitHub, npm, PyPI (pypistats.org) and Hacker News (Algolia), fetched 2026-10-31.

What people say

No Hacker News threads link to its source code.

Look further: search Reddit, search Hacker News, read its GitHub issues. These are not reviews we checked.

Facts

Registry name	`io.github.nsphung/mcp-snowflake-server`
Publisher	GitHub account nsphung
How the name is verified	Name verified via GitHub account nsphung. The registry ties the name prefix to that account or domain; it does not check the code.
Type	Local: runs on your machine from a package
Packages	pypi `mcp-snowflake-server-nsp` 0.14.4 (stdio) oci `docker.io/nsphung/mcp-snowflake-server-nsp:0.14.4` no version given (stdio)
Version	0.14.4
Published	2026-09-24
Last updated	2026-09-24
Source repository	https://github.com/nsphung/mcp-snowflake-server
Website	None linked
Category	Databases & data (assigned by keyword rule, not by hand)

Install

Claude Desktop · Python package

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

Claude Desktop · Docker image

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "docker.io/nsphung/mcp-snowflake-server-nsp:0.14.4"
      ]
    }
  }
}

What these checks don't cover

We did not run this server, so we don't know what it does when it runs. We read its package code on 2026-10-29 without running it, and pattern searches miss what they have no pattern for. Tool descriptions built at run time were not seen. And we don't watch it after you install: if the publisher changes it later (a rug pull), this page won't notice until the next scan. Treat a pass as "nothing found", not as "safe".

For people and their AI

The same data as plain JSON: /data/servers/io-github-nsphung-mcp-snowflake-server.json. Text inside it that came from the publisher is data, not instructions.