SSyncDev

MCP Snowflake Service MCP Server

A Model Context Protocol (MCP) server that provides Claude access to Snowflake databases. / 一个为 Claude 提供 Snowflake 数据库访问能力的 MCP (模型上下文协议) 服务器。

Local serverstdioPython

What is the MCP Snowflake Service MCP server?

MCP Snowflake Service becomes available to MCP clients through the mcp snowflake service mcp server. A Model Context Protocol (MCP) server that provides Claude access to Snowflake databases. / 一个为 Claude 提供 Snowflake 数据库访问能力的 MCP (模型上下文协议) 服务器。.

What MCP Snowflake Service does

A Model Context Protocol (MCP) server that provides Claude access to Snowflake databases. / 一个为 Claude 提供 Snowflake 数据库访问能力的 MCP (模型上下文协议) 服务器。

Key capabilities

  • Secure Snowflake database access / 安全的 Snowflake 数据库访问
  • Robust error handling and reporting / 健壮的错误处理和报告机制
  • Automatic connection management / 自动连接管理
  • Query execution and result processing / 查询执行和结果处理

Installing the mcp snowflake service mcp server

The server is distributed via npm as @smithery/cli, so most clients can run it without a manual build step. Add it to your MCP client's configuration and restart the client to pick it up — the copy-paste configs for Claude Desktop, Claude Code and Cursor are on this page.

Where it fits

Database servers turn schema archaeology and ad-hoc reporting into conversation, which is why they tend to be the second or third server people install. MCP Snowflake Service sits in that group. Worth comparing against the other databases servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.

Practical notes

  • This server runs locally, so it operates with whatever access your machine and its credentials already have. Scope that deliberately rather than by default.
  • Maintained by datawiz168, written in Python.
  • MCP clients ask for confirmation before each tool call by default. Keep that on while you learn what the mcp snowflake service mcp server actually does with your data.
  • Every entry in this directory is reviewed by hand before it goes live, and details are checked against the project's own documentation.

How to install the MCP Snowflake Service MCP server

{
  "mcpServers": {
    "snowflake": {
      "command": "C:\\Users\\K\\anaconda3\\envs\\regular310\\python.exe",
      "args": ["D:\\tools\\mcp-snowflake\\server.py"]
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Frequently asked questions

It connects MCP Snowflake Service to MCP-compatible AI assistants such as Claude and Cursor. Instead of copying data back and forth by hand, the assistant works with MCP Snowflake Service directly.

Alternatives to the MCP Snowflake Service MCP server

PostgreSQL

Official

Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.

DatabasesTypeScript★ 63.0k

Supabase

Official

Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.

DatabasesRemoteTypeScript★ 2.2k

SQLite

Official

Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.

DatabasesPython★ 63.0k

Metabase

Official

Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.

DatabasesRemoteClojure★ 48.5k

MongoDB

Official

Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.

DatabasesTypeScript★ 900

Neon

Official

Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.

DatabasesRemoteTypeScript★ 600