warehouse mcp for Windsurf

io.github.kalehdoo/warehouse-mcp

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

client:Windsurf transport:stdio runtime:npm

Install warehouse mcp in Windsurf

~/.codeium/windsurf/mcp_config.json · windows: %USERPROFILE%\.codeium\windsurf\mcp_config.json

MCP_TRANSPORT

WAREHOUSE_TYPE

MCP_API_KEYS

DUCKDB_PATH

MOTHERDUCK_TOKEN

PG_HOST

PG_DATABASE

PG_USER

PG_PASSWORD

ORACLE_USER

ORACLE_PASSWORD

ORACLE_CONNECT_STRING

SNOWFLAKE_ACCOUNT

SNOWFLAKE_USER

SNOWFLAKE_PRIVATE_KEY_PATH

BIGQUERY_PROJECT

GOOGLE_APPLICATION_CREDENTIALS

GUARDRAIL_PII_MASK

MCP_RATE_LIMIT_RPM

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "warehouse-mcp"
      ],
      "env": {
        "MCP_TRANSPORT": "<MCP_TRANSPORT>",
        "WAREHOUSE_TYPE": "<WAREHOUSE_TYPE>",
        "MCP_API_KEYS": "<MCP_API_KEYS>",
        "DUCKDB_PATH": "<DUCKDB_PATH>",
        "MOTHERDUCK_TOKEN": "<MOTHERDUCK_TOKEN>",
        "PG_HOST": "<PG_HOST>",
        "PG_DATABASE": "<PG_DATABASE>",
        "PG_USER": "<PG_USER>",
        "PG_PASSWORD": "<PG_PASSWORD>",
        "ORACLE_USER": "<ORACLE_USER>",
        "ORACLE_PASSWORD": "<ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<ORACLE_CONNECT_STRING>",
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<SNOWFLAKE_PRIVATE_KEY_PATH>",
        "BIGQUERY_PROJECT": "<BIGQUERY_PROJECT>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
        "GUARDRAIL_PII_MASK": "<GUARDRAIL_PII_MASK>",
        "MCP_RATE_LIMIT_RPM": "<MCP_RATE_LIMIT_RPM>"
      }
    }
  }
}

Global only — Windsurf has no per-project MCP config. Refresh Cascade after saving. Windsurf docs

warehouse mcp in other clients

warehouse mcp MCP server