warehouse-mcp

Indexed by io.github.kalehdoo

About

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

Use this server

Add it to your MCP client. The catalogue lists this config verbatim from its source — it does not run, download, or vouch for the server. Review the command before you run it.

Transportstdio (runs a local command)

Env varsMCP_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

Claude Code

claude mcp add --env MCP_TRANSPORT= --env WAREHOUSE_TYPE= --env MCP_API_KEYS= --env DUCKDB_PATH= --env MOTHERDUCK_TOKEN= --env PG_HOST= --env PG_DATABASE= --env PG_USER= --env PG_PASSWORD= --env ORACLE_USER= --env ORACLE_PASSWORD= --env ORACLE_CONNECT_STRING= --env SNOWFLAKE_ACCOUNT= --env SNOWFLAKE_USER= --env SNOWFLAKE_PRIVATE_KEY_PATH= --env BIGQUERY_PROJECT= --env GOOGLE_APPLICATION_CREDENTIALS= --env GUARDRAIL_PII_MASK= --env MCP_RATE_LIMIT_RPM= warehouse-mcp -- npx warehouse-mcp

Cursor

Add to Cursor

If the button doesn't open Cursor, use the JSON below — Cursor accepts the same mcpServers config.

VS Code

code --add-mcp '{"name":"warehouse-mcp","command":"npx","args":["warehouse-mcp"],"env":{"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":""}}'

JSON

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "warehouse-mcp"
      ],
      "env": {
        "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": ""
      }
    }
  }
}

Environment variables are listed by name only — fill in your own values. Entries never carry secrets.