Skip to content
VS Code

Snowflake MCP Server for VS Code

io.github.nsphung/mcp-snowflake-server

A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants

client:VS Code transport:stdio runtime:pypi

Install Snowflake MCP Server in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "snowflake-account",
      "description": "SNOWFLAKE_ACCOUNT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-user",
      "description": "SNOWFLAKE_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-password",
      "description": "SNOWFLAKE_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-warehouse",
      "description": "SNOWFLAKE_WAREHOUSE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-database",
      "description": "SNOWFLAKE_DATABASE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-schema",
      "description": "SNOWFLAKE_SCHEMA",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-role",
      "description": "SNOWFLAKE_ROLE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-authenticator",
      "description": "SNOWFLAKE_AUTHENTICATOR",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-private-key-file",
      "description": "SNOWFLAKE_PRIVATE_KEY_FILE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-private-key-file-pwd",
      "description": "SNOWFLAKE_PRIVATE_KEY_FILE_PWD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-oauth-client-id",
      "description": "SNOWFLAKE_OAUTH_CLIENT_ID",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-oauth-client-secret",
      "description": "SNOWFLAKE_OAUTH_CLIENT_SECRET",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-oauth-token-request-url",
      "description": "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-oauth-scope",
      "description": "SNOWFLAKE_OAUTH_SCOPE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-token",
      "description": "SNOWFLAKE_TOKEN",
      "password": true
    }
  ],
  "servers": {
    "mcp-snowflake-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "${input:snowflake-account}",
        "SNOWFLAKE_USER": "${input:snowflake-user}",
        "SNOWFLAKE_PASSWORD": "${input:snowflake-password}",
        "SNOWFLAKE_WAREHOUSE": "${input:snowflake-warehouse}",
        "SNOWFLAKE_DATABASE": "${input:snowflake-database}",
        "SNOWFLAKE_SCHEMA": "${input:snowflake-schema}",
        "SNOWFLAKE_ROLE": "${input:snowflake-role}",
        "SNOWFLAKE_AUTHENTICATOR": "${input:snowflake-authenticator}",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "${input:snowflake-private-key-file}",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "${input:snowflake-private-key-file-pwd}",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "${input:snowflake-oauth-client-id}",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "${input:snowflake-oauth-client-secret}",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "${input:snowflake-oauth-token-request-url}",
        "SNOWFLAKE_OAUTH_SCOPE": "${input:snowflake-oauth-scope}",
        "SNOWFLAKE_TOKEN": "${input:snowflake-token}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

Snowflake MCP Server in other clients