MCP Snowflake Reader

@fnf-deepHeading

Basic information

About MCP Snowflake Reader

A Model Context Protocol (MCP) server that provides secure, read-only access to Snowflake databases. Allows LLMs to safely query tables and describe schemas without write permissions. Built with Python and the official Snowflake SDK.

MCP Snowflake Reader config

Add this server to your MCP-compatible client using the configuration below.

{
  "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\"}"
      ]
    }
  }
}

MCP Snowflake Reader tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MCP Snowflake Reader?

MCP Snowflake Reader is a read-only MCP server that provides secure, read-only access to Snowflake databases through the MCP protocol.

How to use MCP Snowflake Reader?

Configure your MCP client (Cursor AI or Claude) with a Docker or uvx command, passing a JSON connection string with your Snowflake account, user, password, warehouse, database, schema, and role. Alternatively, install automatically via Smithery.

Key features of MCP Snowflake Reader

Read-only access to Snowflake databases
Connection via JSON configuration string
Supports Docker and uvx runtimes
Installable via Smithery for Claude Desktop
MIT licensed

Use cases of MCP Snowflake Reader

Query Snowflake data without write risk from MCP clients
Provide safe, read-only database access to AI assistants
Integrate Snowflake analytics into Cursor AI or Claude workflows
Automate table inspection and reporting in a controlled environment

Frequently asked questions

Can MCP Snowflake Reader write or modify data?

No, only read-only operations are allowed. SQL keywords like INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, GRANT, REVOKE, COMMIT, and ROLLBACK are explicitly prohibited.

What connection credentials are required?

You must provide a JSON object containing account, user, password, warehouse, database, schema, and role.

Are there any restrictions on table names?

Table names can only contain alphanumeric characters, underscores, and dots.

What runtimes are supported?

The server can be run via Docker or uvx. Configuration is provided in the MCP client settings file.

How do I install MCP Snowflake Reader on Claude Desktop automatically?

Run `npx -y @smithery/cli install @fnf-deepHeading/mcp-snowflake-reader --client claude` via Smithery.

Comments

More Databases MCP servers

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412