OSS Snowflake MCP Server for VS Code

{
  "inputs": [
    {
      "type": "promptString",
      "id": "snowflake-account",
      "description": "SNOWFLAKE_ACCOUNT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-host",
      "description": "SNOWFLAKE_HOST",
      "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-role",
      "description": "SNOWFLAKE_ROLE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-warehouse",
      "description": "SNOWFLAKE_WAREHOUSE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-passcode",
      "description": "SNOWFLAKE_PASSCODE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-private-key",
      "description": "SNOWFLAKE_PRIVATE_KEY",
      "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-mcp-host",
      "description": "SNOWFLAKE_MCP_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-mcp-port",
      "description": "SNOWFLAKE_MCP_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-mcp-endpoint",
      "description": "SNOWFLAKE_MCP_ENDPOINT",
      "password": true
    }
  ],
  "servers": {
    "mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "${input:snowflake-account}",
        "SNOWFLAKE_HOST": "${input:snowflake-host}",
        "SNOWFLAKE_USER": "${input:snowflake-user}",
        "SNOWFLAKE_PASSWORD": "${input:snowflake-password}",
        "SNOWFLAKE_ROLE": "${input:snowflake-role}",
        "SNOWFLAKE_WAREHOUSE": "${input:snowflake-warehouse}",
        "SNOWFLAKE_PASSCODE": "${input:snowflake-passcode}",
        "SNOWFLAKE_PRIVATE_KEY": "${input:snowflake-private-key}",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "${input:snowflake-private-key-file}",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "${input:snowflake-private-key-file-pwd}",
        "SNOWFLAKE_MCP_HOST": "${input:snowflake-mcp-host}",
        "SNOWFLAKE_MCP_PORT": "${input:snowflake-mcp-port}",
        "SNOWFLAKE_MCP_ENDPOINT": "${input:snowflake-mcp-endpoint}"
      }
    }
  }
}