Skip to content
VS Code

warehouse mcp for VS Code

io.github.kalehdoo/warehouse-mcp

Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.

client:VS Code transport:stdio runtime:npm

Install warehouse mcp in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "mcp-transport",
      "description": "MCP_TRANSPORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "warehouse-type",
      "description": "WAREHOUSE_TYPE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcp-api-keys",
      "description": "MCP_API_KEYS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "duckdb-path",
      "description": "DUCKDB_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "motherduck-token",
      "description": "MOTHERDUCK_TOKEN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pg-host",
      "description": "PG_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pg-database",
      "description": "PG_DATABASE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pg-user",
      "description": "PG_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pg-password",
      "description": "PG_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "oracle-user",
      "description": "ORACLE_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "oracle-password",
      "description": "ORACLE_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "oracle-connect-string",
      "description": "ORACLE_CONNECT_STRING",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-account",
      "description": "SNOWFLAKE_ACCOUNT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-user",
      "description": "SNOWFLAKE_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-private-key-path",
      "description": "SNOWFLAKE_PRIVATE_KEY_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "bigquery-project",
      "description": "BIGQUERY_PROJECT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google-application-credentials",
      "description": "GOOGLE_APPLICATION_CREDENTIALS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "guardrail-pii-mask",
      "description": "GUARDRAIL_PII_MASK",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcp-rate-limit-rpm",
      "description": "MCP_RATE_LIMIT_RPM",
      "password": true
    }
  ],
  "servers": {
    "warehouse-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "warehouse-mcp"
      ],
      "env": {
        "MCP_TRANSPORT": "${input:mcp-transport}",
        "WAREHOUSE_TYPE": "${input:warehouse-type}",
        "MCP_API_KEYS": "${input:mcp-api-keys}",
        "DUCKDB_PATH": "${input:duckdb-path}",
        "MOTHERDUCK_TOKEN": "${input:motherduck-token}",
        "PG_HOST": "${input:pg-host}",
        "PG_DATABASE": "${input:pg-database}",
        "PG_USER": "${input:pg-user}",
        "PG_PASSWORD": "${input:pg-password}",
        "ORACLE_USER": "${input:oracle-user}",
        "ORACLE_PASSWORD": "${input:oracle-password}",
        "ORACLE_CONNECT_STRING": "${input:oracle-connect-string}",
        "SNOWFLAKE_ACCOUNT": "${input:snowflake-account}",
        "SNOWFLAKE_USER": "${input:snowflake-user}",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "${input:snowflake-private-key-path}",
        "BIGQUERY_PROJECT": "${input:bigquery-project}",
        "GOOGLE_APPLICATION_CREDENTIALS": "${input:google-application-credentials}",
        "GUARDRAIL_PII_MASK": "${input:guardrail-pii-mask}",
        "MCP_RATE_LIMIT_RPM": "${input:mcp-rate-limit-rpm}"
      }
    }
  }
}

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

warehouse mcp in other clients