Warehouse MCP Server

by kalehdooio.github.kalehdoo/warehouse-mcpv0.4.2

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

0Node.jsstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Slowing4mo ago

Install Warehouse MCP server

claude mcp add warehouse -e WAREHOUSE_TYPE='<warehouse-type>' -e MCP_API_KEYS='<mcp-api-keys>' -e MOTHERDUCK_TOKEN='<motherduck-token>' -e PG_PASSWORD='<pg-password>' -e ORACLE_PASSWORD='<oracle-password>' -- npx -y warehouse-mcp

{
  "mcpServers": {
    "warehouse": {
      "command": "npx",
      "args": [
        "-y",
        "warehouse-mcp"
      ],
      "env": {
        "WAREHOUSE_TYPE": "<warehouse-type>",
        "MCP_API_KEYS": "<mcp-api-keys>",
        "MOTHERDUCK_TOKEN": "<motherduck-token>",
        "PG_PASSWORD": "<pg-password>",
        "ORACLE_PASSWORD": "<oracle-password>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "warehouse": {
      "command": "npx",
      "args": [
        "-y",
        "warehouse-mcp"
      ],
      "env": {
        "WAREHOUSE_TYPE": "<warehouse-type>",
        "MCP_API_KEYS": "<mcp-api-keys>",
        "MOTHERDUCK_TOKEN": "<motherduck-token>",
        "PG_PASSWORD": "<pg-password>",
        "ORACLE_PASSWORD": "<oracle-password>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "warehouse": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "warehouse-mcp"
      ],
      "env": {
        "WAREHOUSE_TYPE": "<warehouse-type>",
        "MCP_API_KEYS": "<mcp-api-keys>",
        "MOTHERDUCK_TOKEN": "<motherduck-token>",
        "PG_PASSWORD": "<pg-password>",
        "ORACLE_PASSWORD": "<oracle-password>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "warehouse": {
      "command": "npx",
      "args": [
        "-y",
        "warehouse-mcp"
      ],
      "env": {
        "WAREHOUSE_TYPE": "<warehouse-type>",
        "MCP_API_KEYS": "<mcp-api-keys>",
        "MOTHERDUCK_TOKEN": "<motherduck-token>",
        "PG_PASSWORD": "<pg-password>",
        "ORACLE_PASSWORD": "<oracle-password>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
MCP_TRANSPORT	—	—	Set to 'stdio' for desktop AI clients (Claude Desktop, Cursor). Defaults to 'http'.
WAREHOUSE_TYPE	yes	—	Which warehouse to connect to. One of: postgres, oracle, redshift, snowflake, bigquery, duckdb. (DuckDB also handles MotherDuck via DUCKDB_PATH=md:<db>.)
MCP_API_KEYS	—	yes	Comma-separated bearer keys with role and optional warehouse-role impersonation: 'key1:reader,key2:admin', 'key3:reader:set_role=alice'. Leave empty for stdio (OS process boundary is the trust boundary). Required for HTTP.
DUCKDB_PATH	—	—	DuckDB file path, ':memory:', or 'md:<database>' for MotherDuck. Required when WAREHOUSE_TYPE=duckdb.
MOTHERDUCK_TOKEN	—	yes	MotherDuck service token. Required when DUCKDB_PATH starts with 'md:'.
PG_HOST	—	—	Postgres host. Required when WAREHOUSE_TYPE=postgres. (Use REDSHIFT_HOST for Redshift.)
PG_DATABASE	—	—	Postgres database name.
PG_USER	—	—	Postgres user.
PG_PASSWORD	—	yes	Postgres password.
ORACLE_USER	—	—	Oracle user. Required when WAREHOUSE_TYPE=oracle.
ORACLE_PASSWORD	—	yes	Oracle password.
ORACLE_CONNECT_STRING	—	—	Oracle Easy Connect (e.g. host:1521/SERVICE), TNS descriptor, or alias.
SNOWFLAKE_ACCOUNT	—	—	Snowflake account identifier (e.g. xy12345.us-east-1). Required when WAREHOUSE_TYPE=snowflake.
SNOWFLAKE_USER	—	—	Snowflake username.
SNOWFLAKE_PRIVATE_KEY_PATH	—	—	Path to PKCS8 private key (.p8). Snowflake auth is key-pair only; password auth is not supported.
BIGQUERY_PROJECT	—	—	GCP project id. Required when WAREHOUSE_TYPE=bigquery.
GOOGLE_APPLICATION_CREDENTIALS	—	—	Path to BigQuery service-account JSON. Omit on GKE / Cloud Run with workload identity.
GUARDRAIL_PII_MASK	—	—	Set to 'on' to enable role-aware PII masking on result rows (emails, SSNs, phones, IPs, Luhn-validated CCs). Off by default.
MCP_RATE_LIMIT_RPM	—	—	Per-principal token-bucket rate limit on tool invocations. 0 = disabled. Recommend 60 for production.

Freshness

Slowing — last maintenance signal 4mo ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-06-18 · 4mo ago · GitHub
Latest release
no data · GitHub
Package published
no data · npm/PyPI
Registry entry updated
2026-05-06 · 5mo ago · official registry · v0.4.2

FAQ

›How do I install the Warehouse MCP server in Claude Code?

Run: claude mcp add warehouse -e WAREHOUSE_TYPE='<warehouse-type>' -e MCP_API_KEYS='<mcp-api-keys>' -e MOTHERDUCK_TOKEN='<motherduck-token>' -e PG_PASSWORD='<pg-password>' -e ORACLE_PASSWORD='<oracle-password>' -- npx -y warehouse-mcp. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does Warehouse require an API key?

Yes. It expects WAREHOUSE_TYPE, MCP_API_KEYS, MOTHERDUCK_TOKEN, PG_PASSWORD, ORACLE_PASSWORD, of which 4 are secrets.

›Can I use Warehouse as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is Warehouse in the official MCP registry?

Yes, as io.github.kalehdoo/warehouse-mcp.