Add the Snowflake MCP server to Claude Code

Config last verified Jun 1, 2026

The exact config to run Snowflake in Claude Code — paste it in, restart, and the tools load.

Prerequisites

  • Claude Code installed.
  • SNOWFLAKE_PAT — Programmatic Access Token (or OAuth bearer token) for the Snowflake role, sent as the Authorization: Bearer header to the MCP endpoint.

Setup

1. Open ~/.claude.json

2. Add this configuration

Add to ~/.claude.json

~/.claude.json
json
{
  "mcpServers": {
    "snowflake": {
      "type": "http",
      "url": "https://your-org-your-account.snowflakecomputing.com/api/v2/databases/your_db/schemas/your_schema/mcp-servers/your_server",
      "headers": {
        "Authorization": "Bearer <SNOWFLAKE_PAT>"
      }
    }
  }
}
Or via CLI
bash
claude mcp add --transport http snowflake https://your-org-your-account.snowflakecomputing.com/api/v2/databases/your_db/schemas/your_schema/mcp-servers/your_server

3. Restart Claude Code and confirm the Snowflake tools load.

Gotchas

Claude Code stores MCP servers under an "mcpServers" object in ~/.claude.json. It also reads a project-scoped .mcp.json and supports adding servers from the command line with "claude mcp add". Each entry must declare either a "type" or a "command"; Claude Code refuses an entry that has neither. Remote servers connect natively over Streamable HTTP with OAuth.

← Back to the Snowflake MCP server