io.github.kalehdoo/warehouse-mcp

io.github.kalehdoo/warehouse-mcp

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

View repository →Homepage →

Connect this server

Add this to your MCP client config — claude_desktop_config.json (Claude Desktop) or .cursor/mcp.json (Cursor).Suits: Claude Desktop · Cursor.

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "warehouse-mcp@0.4.2"
      ],
      "env": {
        "MCP_TRANSPORT": "stdio",
        "WAREHOUSE_TYPE": "<your WAREHOUSE_TYPE>",
        "MCP_API_KEYS": "<your MCP_API_KEYS>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "PG_PASSWORD": "<your PG_PASSWORD>",
        "ORACLE_PASSWORD": "<your ORACLE_PASSWORD>",
        "GUARDRAIL_PII_MASK": "off",
        "MCP_RATE_LIMIT_RPM": "0"
      }
    }
  }
}
Environment variables
  • MCP_TRANSPORTSet to 'stdio' for desktop AI clients (Claude Desktop, Cursor). Defaults to 'http'.
  • WAREHOUSE_TYPErequiredWhich warehouse to connect to. One of: postgres, oracle, redshift, snowflake, bigquery, duckdb. (DuckDB also handles MotherDuck via DUCKDB_PATH=md:<db>.)
  • MCP_API_KEYSsecretComma-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.
  • MOTHERDUCK_TOKENsecretMotherDuck service token. Required when DUCKDB_PATH starts with 'md:'.
  • PG_PASSWORDsecretPostgres password.
  • ORACLE_PASSWORDsecretOracle password.
  • GUARDRAIL_PII_MASKSet to 'on' to enable role-aware PII masking on result rows (emails, SSNs, phones, IPs, Luhn-validated CCs). Off by default.
  • MCP_RATE_LIMIT_RPMPer-principal token-bucket rate limit on tool invocations. 0 = disabled. Recommend 60 for production.

A starting point — check the repository for exact arguments and setup. Restart your client after editing the config.

Category
Developer Tools
Version
0.4.2
Registry
active
Published
5/6/2026

More Developer Tools servers

Browse all Developer Tools →

io.github.Kali123411/kx402

Kali123411

Kaspa x402 agent payer — pay x402 v2 services on Kaspa (KAS) per call, no account or API key

Developer ToolsAdded 3 months ago

io.github.kalki-kgp/whatsapp-macos

kalki-kgp

WhatsApp MCP for macOS - Read messages from local DB, send via WhatsApp Web.

Developer ToolsAdded 7 months ago

io.github.KallistoX/mcp-unifi-applications

KallistoX

Queryable UniFi API docs: endpoint search, schemas, code examples. No controller access.

Developer ToolsAdded 1 week ago

Kalshi Eye

KalshiEye

Search Kalshi, Polymarket and Limitless markets, order book history, coverage and data files.

Developer ToolsAdded 2 weeks ago

io.github.KamaruSama/mcp-google-forms

KamaruSama

19 tools for Google Forms: create quizzes, add questions, set answer keys, read responses.

Developer ToolsAdded 6 months ago

io.github.KamaruSama/mcp-screenshot

KamaruSama

Take Wayland screenshots via grim/slurp. Full screen, region, or interactive crop.

Developer ToolsAdded 6 months ago

Add the badge to your site

Show visitors that io.github.kalehdoo/warehouse-mcp is listed here — it’s also the link we check for a free listing.

io.github.kalehdoo/warehouse-mcp — listed on Serverdex

HTML — for your website

<a href="https://serverdex.io/server/io-github-kalehdoo-warehouse-mcp?utm_source=badge"><img src="https://serverdex.io/brand/badge.svg" alt="io.github.kalehdoo/warehouse-mcp — listed on Serverdex" width="123" height="40" loading="lazy"></a>

Recommended. A dofollow link from your own domain is the one that counts for search engines, and it's the link we check for a free listing.

Markdown — for your README

[![io.github.kalehdoo/warehouse-mcp — listed on Serverdex](https://serverdex.io/brand/badge.svg)](https://serverdex.io/server/io-github-kalehdoo-warehouse-mcp?utm_source=badge)

Nice for visibility, but GitHub marks README links nofollow, so it doesn't pass authority. Use the HTML badge on your site as well.