home / mcp / mcp snowflake reader mcp server

MCP Snowflake Reader MCP Server

Provides read-only MCP access to Snowflake data sources for safe querying through the MCP protocol.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "fnf-deepheading-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\"}"
      ]
    }
  }
}

You can securely access Snowflake databases in read‑only mode through the MCP Snowflake Reader. This server lets you query Snowflake data using the MCP protocol while guaranteeing that only read operations are performed.

How to use

Configure your MCP client to connect to the Snowflake Reader using one of the available local runtimes. You can run the server through Docker or UVX, passing a JSON connection descriptor that contains your Snowflake credentials and context. Once connected, you can perform read-only queries against Snowflake tables that your role permits.

How to install

Prerequisites you need before installation:

- Node.js and npm installed on your machine for CLI tools

- Docker or UVX if you plan to run the server locally via those runtimes

Step 1. Install via Smithery for Claude Desktop

npx -y @smithery/cli install @fnf-deepHeading/mcp-snowflake-reader --client claude

Configuration examples

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

{
  "mcpServers": {
    "snowflake_reader": {
      "command": "uvx",
      "args": [
        "snowflake_reader",
        "--connection",
        "{\"account\":\"your-account\",\"user\":\"your-user\",\"password\":\"your-password\",\"warehouse\":\"your-warehouse\",\"database\":\"your-database\",\"schema\":\"your-schema\",\"role\":\"your-role\"}"
      ]
    }
  }
}

Security and limitations

- Only read‑only operations are allowed.

- Table names can include only alphanumeric characters, underscores, and dots.

- The following SQL keywords are prohibited: INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER, CREATE, GRANT, REVOKE, COMMIT, ROLLBACK.

License

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

Additional notes

Smithery installation enables automated setup for Claude Desktop. Use the exact command shown under the installation step to add the MCP Snowflake Reader to your client configuration. Ensure you replace the placeholder connection values with your actual Snowflake account details.