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_server3. 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.