MCP Snowflake Reader MCP Server

A read-only MCP server for Snowflake databases. This server provides secure, read-only access to Snowflake databases through the MCP protocol.

Local serverstdio

What is the MCP Snowflake Reader MCP server?

Mcp snowflake reader mcp server lets Claude, Cursor and other MCP clients work with MCP Snowflake Reader directly. A read-only MCP server for Snowflake databases. This server provides secure, read-only access to Snowflake databases through the MCP protocol.

What MCP Snowflake Reader does

A read-only MCP server for Snowflake databases. This server provides secure, read-only access to Snowflake databases through the MCP protocol.

Key capabilities

  • Read-only Access — Secure read-only access to Snowflake databases

Tools it exposes

Once connected, the assistant can call these 9 tools directly:

  • Read — only Access**: Secure read-only access to Snowflake databases
  • INSERT — UPDATE
  • DELETE — DROP
  • TRUNCATE — ALTER
  • CREATE — GRANT
  • REVOKE — COMMIT
  • Features — The Features tool exposed by this server
  • Setup — The Setup tool exposed by this server
  • Limitations — The Limitations tool exposed by this server

Installing the mcp snowflake reader 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 Reader sits in that group, and the shape of its toolset — Read, INSERT, DELETE among others — tells you what it is really for. 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.
  • With 9 tools exposed, expect a noticeable bump in prompt size — disable it in projects that never use MCP Snowflake Reader.
  • Maintained by fnf-deepHeading.
  • MCP clients ask for confirmation before each tool call by default. Keep that on while you learn what the mcp snowflake reader 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.

Available tools

ToolWhat it does
Readonly Access**: Secure read-only access to Snowflake databases
INSERTUPDATE
DELETEDROP
TRUNCATEALTER
CREATEGRANT
REVOKECOMMIT
FeaturesThe Features tool exposed by this server.
SetupThe Setup tool exposed by this server.
LimitationsThe Limitations tool exposed by this server.

How to install the MCP Snowflake Reader MCP server

{
  "mcpServers": {
    "mcp-snowflake-reader": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp-snowflake-reader",
        "--connection",
        "{\"account\":\"your-account\",\"user\":\"your-user\",\"password\":\"your-password\",\"warehouse\":\"your-warehouse\",\"database\":\"your-database\",\"schema\":\"your-schema\",\"role\":\"your-role\"}"
      ]
    }
  }
}

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

Example prompts to try

  • Use MCP Snowflake Reader to Read.
  • Use MCP Snowflake Reader to INSERT.
  • Use MCP Snowflake Reader to DELETE.

Frequently asked questions

It connects MCP Snowflake Reader to MCP-compatible AI assistants such as Claude and Cursor, exposing 9 tools (Read, INSERT, DELETE, and more) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with MCP Snowflake Reader directly.