How do I install warehouse-mcp?

Pick a client above and copy the generated config. Cursor and VS Code also have a deep link when the server can run locally or remotely.

Is warehouse-mcp official?

No. Registry-listed is not the same as vendor-official. Read the methodology for the difference.

How is the trust score calculated?

This listing scores 45 (Fair). The formula is published on the methodology page.

MCPpedia

warehouse-mcp MCP Server

Name: warehouse-mcp MCP Server
Author: kalehdoo

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

Tools Versions Alternatives

Registrykalehdoo

45Fair

Install

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "kalehdoo-warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "warehouse-mcp@0.4.2"
      ],
      "env": {
        "MCP_TRANSPORT": "stdio",
        "WAREHOUSE_TYPE": "",
        "MCP_API_KEYS": "YOUR_MCP_API_KEYS",
        "DUCKDB_PATH": "",
        "MOTHERDUCK_TOKEN": "YOUR_MOTHERDUCK_TOKEN",
        "PG_HOST": "",
        "PG_DATABASE": "",
        "PG_USER": "",
        "PG_PASSWORD": "YOUR_PG_PASSWORD",
        "ORACLE_USER": "",
        "ORACLE_PASSWORD": "YOUR_ORACLE_PASSWORD",
        "ORACLE_CONNECT_STRING": "",
        "SNOWFLAKE_ACCOUNT": "",
        "SNOWFLAKE_USER": "",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "",
        "BIGQUERY_PROJECT": "",
        "GOOGLE_APPLICATION_CREDENTIALS": "",
        "GUARDRAIL_PII_MASK": "off",
        "MCP_RATE_LIMIT_RPM": "0"
      }
    }
  }
}

Install guide

Related servers

Elfsight AI Chatbot

68Good

Read conversations, leads, knowledge base and analytics of your Elfsight AI Chatbot widgets.

RegistryRemoteelfsight2 stars2 tools

XposedOrNot Breach Intelligence

warehouse-mcp MCP Server | MCPpedia

Environment

Name	Required	Notes
MCP_TRANSPORT	No	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	No	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. Secret.
DUCKDB_PATH	No	DuckDB file path, ':memory:', or 'md:<database>' for MotherDuck. Required when WAREHOUSE_TYPE=duckdb.
MOTHERDUCK_TOKEN	No	MotherDuck service token. Required when DUCKDB_PATH starts with 'md:'. Secret.
PG_HOST	No	Postgres host. Required when WAREHOUSE_TYPE=postgres. (Use REDSHIFT_HOST for Redshift.)
PG_DATABASE	No	Postgres database name.
PG_USER	No	Postgres user.
PG_PASSWORD	No	Postgres password. Secret.
ORACLE_USER	No	Oracle user. Required when WAREHOUSE_TYPE=oracle.
ORACLE_PASSWORD	No	Oracle password. Secret.
ORACLE_CONNECT_STRING	No	Oracle Easy Connect (e.g. host:1521/SERVICE), TNS descriptor, or alias.
SNOWFLAKE_ACCOUNT	No	Snowflake account identifier (e.g. xy12345.us-east-1). Required when WAREHOUSE_TYPE=snowflake.
SNOWFLAKE_USER	No	Snowflake username.
SNOWFLAKE_PRIVATE_KEY_PATH	No	Path to PKCS8 private key (.p8). Snowflake auth is key-pair only; password auth is not supported.
BIGQUERY_PROJECT	No	GCP project id. Required when WAREHOUSE_TYPE=bigquery.
GOOGLE_APPLICATION_CREDENTIALS	No	Path to BigQuery service-account JSON. Omit on GKE / Cloud Run with workload identity.
GUARDRAIL_PII_MASK	No	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	No	Per-principal token-bucket rate limit on tool invocations. 0 = disabled. Recommend 60 for production.

warehouse-mcp MCP Server

Install

Related servers

Elfsight AI Chatbot

XposedOrNot Breach Intelligence

Environment

Tools

About

FAQ

Reviews

Supabase

mcp-ssh-manager

Misar.Blog MCP Server

AI Tag Debugger