MCP Server Snowflake 977fd2c2

MCP数据服务

提供方 patrickfreyer

数据服务 未标注 无需鉴权 社区 / 第三方 Claude DesktopClaudeCursor

一个基于TypeScript的MCP服务器,使大型语言模型(如Claude)能够直接查询和与Snowflake数据库交互。

一句话选型结论

按资料字段整理

MCP Server Snowflake 977fd2c2 属于数据服务类 MCP 服务器,传输方式未标注,无需鉴权,可直接接入 Claude Desktop、Claude、Cursor,没有现成安装命令,需按官方文档接入。接入前先确认权限范围;涉及写入、删除或付款的操作,建议先在测试环境验证。

分类数据服务 传输方式未标注 鉴权无需鉴权 部署方式未标注
GitHub 星标 1 仓库热度,无公开仓库时显示未标注
工具数 5 暴露给模型的工具数量
资源 / 提示词 0 / 0 资源与提示词模板数量
维护方 社区 / 第三方 核验等级 仅资料核对

工具与能力

数据服务
数量来自来源目录的标注,具体工具清单以官方文档为准
工具数量5暴露给模型可调用的工具个数
资源数量0可读取的资源条目
提示词数量0内置提示词模板数量

能力标签

支持客户端

适用场景

数据库查询JavaScript本地部署LLM集成Snowflake连接器TypeScript开发MCP协议

安装与配置

未标注 无需鉴权
上游未给出传输方式
  1. 1
    准备运行环境

    按官方文档确认运行环境(常见为 Node.js 或 Python),装好后再执行安装命令。

  2. 2
    安装服务

    复制上面的安装命令执行;命令里带占位符的位置,换成自己的密钥或路径。

  3. 3
    写入客户端配置

    在客户端的 MCP 配置里填好启动命令和参数,保存后完全退出客户端再打开,让新配置生效。

  4. 4
    验证是否可用

    连接成功后客户端会列出约 5 个工具,随便调一个只读工具确认能返回结果。

典型使用场景

3 类
按分类与标签整理的常见用法,具体以官方文档为准
数据库查询

用自然语言查库、取数,不用手写 SQL。

数据同步与清洗

把多来源数据拉到一处做整理。

报表取数

按口径快速拉出统计结果。

选择建议

选之前先看这几条
按条目字段给出的判断,不替你决定用不用

值得选的地方

  • 资料标注 5 个工具,职责相对集中,接入后不容易误操作。
  • 已适配 Claude Desktop、Claude、Cursor,换客户端不用重新研究配置。
  • 资料标注无需鉴权,装好就能连。

先想清楚的地方

  • 没有现成安装命令,需要按官方文档自己填启动命令和参数。
  • 版本更新与行为细节以官方仓库为准。

更适合

  • 需要在数据服务场景里让模型直接调用外部能力的人。
  • 已经在用 Claude Desktop、Claude 的用户,接入路径最短。
  • 想先快速试一下、能接受在本地或自有环境跑服务的人。

不太适合

  • 需要厂商级 SLA 和技术支持的生产环境。

同类对比

6 个同类
同分类里挑最接近的几条,字段以各自详情页为准
MCP 服务器工具数传输方式部署方式安装命令最后核验
MCP Server Snowflake 977fd2c2当前 5 未标注 未标注 无 2026-05-17
Memory 9d25f64e 9 未标注 未标注 无 2026-05-17
Getzep MCP 9 stdio · 本地进程 本地部署 有 2026-05-17
anything-llm 未标注 stdio · 本地进程 本地部署 有 2026-04-11
Prisma MCP Server 未标注 stdio · 本地进程 本地部署 有 2026-05-17
Astr Bot 未标注 stdio · 本地进程 本地部署 有 2026-05-17

服务器档案

数据服务
字段来自项目仓库与公开索引,中文说明由本站标注
提供方patrickfreyer上游标注的维护方 patrickfreyer
分类数据服务本站按上游分类展示
连接方式未标注上游未给出传输方式
鉴权方式无需鉴权远程服务建议用最小权限凭据
维护方社区 / 第三方核验等级 仅资料核对
包名 / 运行时未标注 · 未标注本地安装时用到的包标识与运行时
部署类型未标注上游给出的部署形态
最近核验2026-05-17上游最后核验时间

详细介绍

9.1 KB
来自项目仓库与上游目录的原文,未做删改

Node-based Snowflake MCP

A TypeScript-based MCP (Model Context Protocol) server that enables Large Language Models (LLMs) like Claude to directly query and interact with Snowflake databases.

🌟 Features

  • 🔌 Easy Integration - Simple setup with Claude Desktop, Cursor, or any MCP-compatible tool
  • 🔒 Secure - Multiple authentication methods including environment variables and key-pair authentication
  • 🚀 High Performance - Built with TypeScript and the native Snowflake Node.js driver
  • 📊 Full Database Access - Query, explore schemas, list tables, and analyze data
  • 🛠️ Developer Friendly - Comprehensive TypeScript types and error handling

📋 Prerequisites

  • Node.js 18 or higher
  • npm or yarn
  • Snowflake account with appropriate access permissions
  • MCP-compatible client (Claude Desktop, Cursor, Continue, etc.)

🚀 Quick Start

Installation Options

Option 1: Install via MCPB Package (Recommended for Claude Desktop)

The easiest way to install this MCP server in Claude Desktop is using the pre-built MCPB package:

  1. Download the latest release:
    - Go to Releases
    - Download the snowflake-mcp-v1.0.0.mcpb file

  2. Install in Claude Desktop:
    - Open Claude Desktop
    - Navigate to Settings → Developer → MCP Servers
    - Click "Install from file"
    - Select the downloaded .mcpb file
    - Configure your Snowflake credentials when prompted

Option 2: Build MCPB Package from Source```bash

Clone the repository

git clone https://github.com/patrickfreyer/mcp-server-snowflake.git
cd mcp-server-snowflake

Install dependencies

npm install

Build the TypeScript server

npm run build

Create the MCPB package

./build-mcpb.sh

The package will be created as snowflake-mcp-v1.0.0.mcpb

Install this file in Claude Desktop as described above


#### Option 3: Manual Installation (For Development)```bash
# Clone the repository
git clone https://github.com/patrickfreyer/mcp-server-snowflake.git
cd mcp-server-snowflake

# Install dependencies
npm install

# Build the server
npm run build

Configuration

Configuration depends on your installation method:

For MCPB Package Users

When you install the MCPB package, Claude Desktop will automatically prompt you for:
- Snowflake Account (e.g., your-account.region.provider)
- Warehouse name
- Username (typically your email)
- Password
- Role (optional)
- Database (optional)
- Schema (optional)

These credentials are securely stored in Claude Desktop's configuration.

For Manual Installation

  1. Set up environment variables:```bash

Copy the example environment file

cp .env.example .env

Edit .env with your Snowflake credentials

SNOWFLAKE_ACCOUNT=your-account.region.provider
SNOWFLAKE_USER=your.email@company.com
SNOWFLAKE_PASSWORD=your-password
SNOWFLAKE_WAREHOUSE=YOUR_WAREHOUSE # Optional
SNOWFLAKE_DATABASE=YOUR_DATABASE # Optional
SNOWFLAKE_SCHEMA=YOUR_SCHEMA # Optional
SNOWFLAKE_ROLE=YOUR_ROLE # Optional


2. **Configure your MCP client:**

#### Claude Desktop

Add to `~/Library/Application Support/Claude/claude_desktop_config.json`:```json
{
  "mcpServers": {
    "snowflake": {
      "command": "node",
      "args": ["/absolute/path/to/mcp-server-snowflake/dist/index.js"],
      "env": {
        "SNOWFLAKE_ACCOUNT": "your-account.region.provider",
        "SNOWFLAKE_USER": "your.email@company.com",
        "SNOWFLAKE_PASSWORD": "your-password",
        "SNOWFLAKE_WAREHOUSE": "YOUR_WAREHOUSE",
        "SNOWFLAKE_DATABASE": "YOUR_DATABASE",
        "SNOWFLAKE_SCHEMA": "YOUR_SCHEMA",
        "SNOWFLAKE_ROLE": "YOUR_ROLE"
      }
    }
  }
}

Cursor

Add to Cursor settings:```json
{
"mcp.servers": {
"snowflake": {
"command": "node",
"args": ["/path/to/mcp-server-snowflake/dist/index.js"],
"env": {
"SNOWFLAKE_ACCOUNT": "your-account",
"SNOWFLAKE_USER": "your-user",
"SNOWFLAKE_PASSWORD": "your-password"
}
}
}
}


## 📚 Available Tools

The MCP server provides the following tools for interacting with Snowflake:

### `read_query`
Execute SELECT queries on your Snowflake database.```typescript
// Example
{
  "query": "SELECT * FROM customers LIMIT 10"
}

list_databases

List all available databases in your Snowflake account.

list_schemas

List all schemas in a specific database.```typescript
// Example
{
"database": "MY_DATABASE" // Optional
}


### `list_tables`
List all tables in a specific schema.```typescript
// Example
{
  "database": "MY_DATABASE",  // Optional
  "schema": "MY_SCHEMA"       // Optional
}

describe_table

Get detailed information about a table's structure.```typescript
// Example
{
"table_name": "DATABASE.SCHEMA.TABLE"
}


## 🔒 Security

### Environment Variables

The recommended approach for credentials:```bash
export SNOWFLAKE_ACCOUNT="your-account"
export SNOWFLAKE_USER="your-user"
export SNOWFLAKE_PASSWORD="your-password"

Key-Pair Authentication (Production)

For production environments, we recommend using key-pair authentication:

  1. Generate a key pair
  2. Configure your Snowflake user with the public key
  3. Update the server configuration to use the private key

File Permissions

Secure your configuration files:```bash
chmod 600 ~/.env
chmod 600 ~/Library/Application\ Support/Claude/claude_desktop_config.json


## 📦 Building MCPB Packages

The MCPB (MCP Bundle) format allows for easy distribution and installation of MCP servers in Claude Desktop.

### Building a Package```bash
# Ensure the project is built
npm run build

# Create the MCPB package
./build-mcpb.sh

This will create a snowflake-mcp-v1.0.0.mcpb file containing:
- Compiled server code
- Manifest with configuration schema
- Production dependencies
- Installation metadata

Package Contents

The MCPB package includes:
- manifest.json - Defines configuration parameters and server entry point
- dist/ - Compiled TypeScript server code
- node_modules/ - Production dependencies only
- README.md - Package documentation

Manifest Configuration

The manifest.json file defines:
- User configuration parameters (without default values for security)
- Server entry point and environment variable mapping
- Tool definitions for Snowflake operations
- Package metadata (name, version, author, etc.)

🧪 Development

Setup Development Environment```bash

Install dependencies

npm install

Run in development mode

npm run dev

Run tests

npm test

Lint code

npm run lint

Type check

npm run type-check


### Project Structure```
mcp-server-snowflake/
├── src/
│   └── index.ts          # Main server implementation
├── dist/                 # Compiled JavaScript (generated)
├── tests/               # Test files
├── .env.example         # Environment variable template
├── .github/
│   └── workflows/       # CI/CD workflows
├── manifest.json        # MCPB package configuration
├── build-mcpb.sh        # Script to build MCPB package
├── package.json         # Node.js dependencies
├── tsconfig.json        # TypeScript configuration
├── LICENSE             # MIT License
├── CONTRIBUTING.md     # Contribution guidelines
└── README.md          # This file

🤝 Contributing

We welcome contributions! Please see our Contributing Guide for details.

How to Contribute

  1. Fork the repository
  2. Create your feature branch (git checkout -b feature/AmazingFeature)
  3. Commit your changes (git commit -m 'Add some AmazingFeature')
  4. Push to the branch (git push origin feature/AmazingFeature)
  5. Open a Pull Request

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.

🆘 Support

If you encounter any issues or have questions:

  1. Check the Troubleshooting section below
  2. Search existing issues
  3. Create a new issue

🔧 Troubleshooting

Common Issues

"Missing required Snowflake configuration"

  • Ensure all required environment variables are set
  • Check for typos in variable names
  • Verify the .env file is in the correct location

Connection Failed

  • Verify your Snowflake account format: account.region.provider
  • Check network connectivity and firewall settings
  • Ensure your IP is whitelisted in Snowflake network policies

Permission Denied

  • Verify your Snowflake role has necessary permissions
  • Check warehouse access rights
  • Ensure database and schema permissions are granted

Debug Mode

Enable verbose logging:bash export DEBUG=mcp:* node dist/index.js

🚀 Roadmap

  • [ ] Add support for write operations (INSERT, UPDATE, DELETE)
  • [ ] Implement connection pooling
  • [ ] Add support for Snowflake stored procedures
  • [ ] Create a web-based configuration UI
  • [ ] Add support for multiple Snowflake accounts
  • [ ] Implement query result caching
  • [ ] Add data visualization capabilities

👥 Authors

  • Patrick Freyer - Initial work

🙏 Acknowledgments

  • Anthropic for the MCP protocol specification
  • Snowflake for their excellent Node.js SDK
  • The open-source community for continuous support and contributions

📊 Stats


Made with ❤️ by Patrick Freyer

常见问题

6 问
答案由本站依据条目字段整理,不引用上游原文
MCP Server Snowflake 977fd2c2 怎么安装?

资料没有给出安装命令,请到官方仓库或文档按说明接入;这类条目多数是生态应用,或尚未发布可安装包。

MCP Server Snowflake 977fd2c2 怎么在 Claude Desktop、Claude、Cursor 里配置?

它的传输方式未标注,在客户端的 MCP 配置里填好启动命令和参数,保存后完全退出客户端再打开,配置才会生效。

MCP Server Snowflake 977fd2c2 收费吗?

本站不代收费用,也没有标注具体价格。是否收费取决于服务本身和背后的接口额度,正式使用前按官方说明确认。

MCP Server Snowflake 977fd2c2 需要 API Key 吗?

资料标注为无需认证,装好就能连;如果实际调用时报鉴权错误,按官方文档补上凭据。

MCP Server Snowflake 977fd2c2 支持哪些客户端?

资料标注支持 Claude Desktop、Claude、Cursor;其他客户端只要能配置 MCP Server,也能用同样的命令或地址接入。

MCP Server Snowflake 977fd2c2 能提供哪些能力?

资料显示约 5 个工具;能力标签包括 数据分析、JavaScript、Claude、TypeScript开发。具体工具清单以官方文档为准。

热门专题

按标签挑服务器
全部专题 →

服务器信息以作者仓库与官方文档为准;分类、传输方式与鉴权方式的中文说明为中文整理,最近核验 2026-05-17。