home / mcp / snowflake mcp server

Snowflake MCP Server

Queries Snowflake data using external browser authentication to avoid storing Snowflake credentials on disk.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "oxplot-snowflake-mcp": {
      "command": "go",
      "args": [
        "run",
        "github.com/oxplot/snowflake-mcp@latest",
        "-account=PPXXXXX-XXXXXXX",
        "-role=reporter"
      ]
    }
  }
}

This MCP enables you to query Snowflake data through an MCP server while using external browser authentication. This approach avoids storing Snowflake credentials on disk and lets you run queries securely via your MCP client.

How to use

Use your MCP client to connect to the Snowflake MCP server and run queries as you would with other data sources. The server authenticates users via an external browser flow, so you won’t manage Snowflake credentials directly. You can perform read operations against Snowflake data sources, and you can integrate this MCP with your existing data workflows.

How to install

Prerequisites you need before running the MCP server include having Go installed on your system. If Go is not installed, install it from the official source for your operating system.

Run the MCP command exactly as shown to start the server locally. This uses Go’s module proxy to fetch and run the MCP package.

go run github.com/oxplot/snowflake-mcp@latest -account=PPXXXXX-XXXXXXX -role=reporter

Additional notes

External browser authentication is the sole supported method to connect to Snowflake for this MCP, ensuring credentials are not stored on disk. Be mindful of the permissions you grant to the Snowflake account, as the MCP does not restrict write operations by itself. Start by running the command above, then use your MCP client to issue read queries against Snowflake data.

Available tools

external_browser_auth

Authenticates Snowflake sessions via an external browser flow to avoid persisting credentials on disk.