Add the Snowflake MCP server to VS Code

Config last verified Jun 1, 2026

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

Prerequisites

VS 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 `.vscode/mcp.json`

2. Add this configuration

Add to .vscode/mcp.json

.vscode/mcp.json

json

{
  "servers": {
    "snowflake": {
      "type": "http",
      "url": "https://your-org-your-account.snowflakecomputing.com/api/v2/databases/your_db/schemas/your_schema/mcp-servers/your_server"
    }
  }
}

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

Gotchas

VS Code is the exception to every other client: its top-level key is "servers", not "mcpServers", and each entry needs an explicit "type" (for example "http" or "stdio"). Secrets are not inlined; instead you declare an "inputs" array and reference each value as ${input:id}, so VS Code prompts for it once and never writes it to disk. Remote servers connect natively with OAuth.

← Back to the Snowflake MCP server