MCP Snowflake Server NSP - A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants
MCP ServersOfficial Registry2 stars0 forks● PythonMITUpdated today
ClaudeWave Trust Score
87/100
Passed
- ✓Open-source license (MIT)
- ✓Actively maintained (<30d)
- ✓Clear description
- ✓Topics declared
Last scanned: 6/11/2026
Install in Claude Code / Claude Desktop
Method: UVX (Python) · --python
Claude Code CLI
claude mcp add mcp-snowflake-server -- uvx --pythonclaude_desktop_config.json (Claude Desktop)
{
"mcpServers": {
"mcp-snowflake-server": {
"command": "uvx",
"args": ["--python"]
}
}
}1. Run the command above in your terminal (Claude Code), or paste the JSON config into claude_desktop_config.json (Claude Desktop).
2. Replace any <placeholder> values with your API keys or paths.
3. Restart Claude. The MCP server and its tools appear automatically.
About
MCP Servers overview
<div align="center">
<a href="https://github.com/nsphung/mcp-snowflake-server"><img width="80%" height="80%" alt="mcp-snowflake-server-nsp-banner" src="https://github.com/user-attachments/assets/73ccb230-907e-4b4c-ae51-cbda9cdc8c2c" /></a>
[](https://pypi.org/project/mcp-snowflake-server-nsp/) • [](https://codecov.io/gh/nsphung/mcp-snowflake-server) • [](https://pypi.org/project/mcp-snowflake-server-nsp/) • [](https://hub.docker.com/r/nsphung/mcp-snowflake-server-nsp) • [](https://opensource.org/licenses/MIT)
| | |
| -------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Test | [](https://github.com/nsphung/mcp-snowflake-server/actions/workflows/test.yml)  [](https://github.com/nsphung/mcp-snowflake-server/actions/workflows/docker-check.yml) |
| Lint | [](https://github.com/nsphung/mcp-snowflake-server/actions/workflows/lint.yml) [](https://github.com/astral-sh/ruff) [](http://mypy-lang.org/) [](https://github.com/j178/prek) [](https://oxc.rs/docs/guide/usage/formatter) |
| Meta | [](./CODE_OF_CONDUCT.md) [](https://modelcontextprotocol.io/) [](https://www.python.org/) [](https://www.python.org/) |
| Security |  [](https://github.com/nsphung/mcp-snowflake-server/actions/workflows/github-code-scanning/codeql) [](https://scorecard.dev/viewer/?uri=github.com/nsphung/mcp-snowflake-server) [](https://socket.dev/pypi/package/mcp-snowflake-server-nsp) |
| Best Practices | [](https://www.bestpractices.dev/projects/12747) [](https://www.bestpractices.dev/projects/12747) |
| Documentation | [](https://deepwiki.com/nsphung/mcp-snowflake-server) |
</div>
---
# Snowflake MCP Server NSP
A [Model Context Protocol (MCP)](https://modelcontextprotocol.io/) server / MCP server that connects AI assistants to Snowflake — enabling SQL queries, schema exploration, and data insights directly from your LLM client.
<!-- mcp-name: io.github.nsphung/mcp-snowflake-server -->
**Highlights:**
- Multiple authentication methods: password, key-pair, external browser, OAuth 2.0 (client credentials & bearer token), TOML connection files
- TOML multi-connection config — manage `production`, `staging`, and `development` environments in one file
- Write-safety guard — write operations are disabled by default and must be explicitly enabled
- Exclusion patterns — filter out databases, schemas, or tables from discovery
- `--exclude-json-results` flag — reduces LLM context window usage
- Selective tool exclusion via `--exclude_tools`
- Prefetch mode — pre-load table schema as MCP resources
- Docker support with hardened image ([DHI](https://docs.docker.com/dhi/), nonroot user, no shell in runtime)
---
## Table of Contents
- [Snowflake MCP Server NSP](#snowflake-mcp-server-nsp)
- [Table of Contents](#table-of-contents)
- [Quick Start](#quick-start)
- [Claude Code](#claude-code)
- [Visual Studio Code (VSCode)](#visual-studio-code-vscode)
- [OpenCode](#opencode)
- [Components](#components)
- [Resources](#resources)
- [Tools](#tools)
- [Query Tools](#query-tools)
- [Schema Tools](#schema-tools)
- [Analysis Tools](#analysis-tools)
- [Authentication](#authentication)
- [Password](#password)
- [Key-Pair](#key-pair)
- [External Browser](#external-browser)
- [OAuth 2.0 Client Credentials](#oauth-20-client-credentials)
- [OAuth Bearer Token](#oauth-bearer-token)
- [TOML Connection File (Recommended)](#toml-connection-file-recommended)
- [Installation](#installation)
- [Via UVX](#via-uvx)
- [Via Docker Hub](#via-docker-hub)
- [Configuration Reference](#configuration-reference)
- [Exclusion Patterns](#exclusion-patterns)
- [License](#license)
- [Fork and Attribution](#fork-and-attribution)
---
## Quick Start
The fastest way to try it — using `uvx` with a TOML connection file:Topics
agentic-aiagentsdatabasedockerdocker-imagemcpmcp-servermcp-toolsmodel-context-protocolmodelcontextprotocolpython3snowflakeuvx
Frequently asked
What people ask about mcp-snowflake-server
What is nsphung/mcp-snowflake-server?
+
nsphung/mcp-snowflake-server is mcp servers for the Claude AI ecosystem. MCP Snowflake Server NSP - A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants It has 2 GitHub stars and was last updated today.
How do I install mcp-snowflake-server?
+
You can install mcp-snowflake-server by cloning the repository (https://github.com/nsphung/mcp-snowflake-server) or following the README instructions on GitHub. ClaudeWave also provides quick install blocks on this page.
Is nsphung/mcp-snowflake-server safe to use?
+
Our security agent has analyzed nsphung/mcp-snowflake-server and assigned a Trust Score of 87/100 (tier: Trusted). See the full breakdown of passed checks and flags on this page.
Who maintains nsphung/mcp-snowflake-server?
+
nsphung/mcp-snowflake-server is maintained by nsphung. The last recorded GitHub activity is from today, with 0 open issues.
Are there alternatives to mcp-snowflake-server?
+
Yes. On ClaudeWave you can browse similar mcp servers at /categories/mcp, sorted by popularity or recent activity.
1-click deploy
Deploy mcp-snowflake-server to your cloud
Ship this repo to production in minutes. Each platform spins up its own environment with editable env vars.
Embeddable badge
Maintain this repo? Add a badge to your README
Drop the badge into your GitHub README to show it's tracked on ClaudeWave. Each badge links back to this page and reflects the live Trust Score.
[](https://claudewave.com/repo/nsphung-mcp-snowflake-server)<a href="https://claudewave.com/repo/nsphung-mcp-snowflake-server"><img src="https://claudewave.com/api/badge/nsphung-mcp-snowflake-server" alt="Featured on ClaudeWave: nsphung/mcp-snowflake-server" width="320" height="64" /></a>Related
More MCP Servers
n8n-io
n8n
today
Fair-code workflow automation platform with native AI capabilities. Combine visual building with custom code, self-host or cloud, 400+ integrations.
193.1k58.7kTypeScript
MCP ServersaiapisInstall
open-webui
open-webui
today
User-friendly AI Interface (Supports Ollama, OpenAI API, ...)
142.2k20.4kPython
MCP ServersaillmInstall
google-gemini
gemini-cli
today
An open-source AI agent that brings the power of Gemini directly into your terminal.
105.4k14.1kTypeScript
MCP Serversaiai-agentsInstall
netdata
netdata
today
The fastest path to AI-powered full stack observability, even for lean teams.
79.3k6.5kC
MCP ServersaialertingInstall
D4Vinci
Scrapling
yesterday
🕷️ An adaptive Web Scraping framework that handles everything from a single request to a full-scale crawl!
64.8k6.4kPython
MCP Serversaiai-scrapingInstall
sansan0
TrendRadar
6d ago
⭐AI-driven public opinion & trend monitor with multi-platform aggregation, RSS, and smart alerts.🎯 告别信息过载，你的 AI 舆情监控助手与热点筛选工具！聚合多平台热点 + RSS 订阅，支持关键词精准筛选。AI 智能筛选新闻 + AI 翻译 + AI 分析简报直推手机，也支持接入 MCP 架构，赋能 AI 自然语言对话分析、情感洞察与趋势预测等。支持 Docker ，数据本地/云端自持。集成微信/飞书/钉钉/Telegram/邮件/ntfy/bark/slack 等渠道智能推送。
59.6k24.7kPython
MCP ServersaibarkInstall