io.github.kalehdoo/warehouse-mcp

io.github.kalehdoo/warehouse-mcpv0.4.2Databases

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

In-path gate · all MCP tools

Using io.github.kalehdoo/warehouse-mcp in Claude, Cursor, Gemini CLI, Cline, or Zed?

MCP tool contracts can change remotely with no version bump. The mcpindex gate pins each contract and HOLDs the call when it drifts-before your agent acts. Zero credentials. This is not the package install for this server itself (use Install this server for that).

Install the mcpindex gate (one command)

Rewrites your MCP host config so each server launches behind the gate. Inspect first: curl -fsSL https://mcpindex.ai/install.sh | less

uv tool install mcpindex-gate && mcpindex-config-wire

Auditable install path →Watch it hold a drift →

Trust verdict · v1 advisory · method

REVIEWstatus: STALEfresh until 2026-08-02 11:00 UTC

screened 2026-07-03tier: scannedgranularity: description-levelsource: registry

Semantic screen found no manipulation pattern in the description. Conformance probe not yet run.

mcpindex.integrity.descriptionpassINFO

evidence“No malicious instructions found”via static_description

Limits of this verdict

- Semantic screen only - the deterministic conformance probe has not run on this server
- Confidence is reported but not yet calibrated (v1)
- Screen reads the tool description, not the live behavior
- advisory
- registry description only no input schema
- screen model 8b
- Past its expiry date - awaiting re-screen

Semantic screen: an LLM judge reads the tool description for hidden instructions (status PARTIAL). A pass means the description is not lying, not that the tool is safe: a high-capability tool with an honest description still warrants caution. The deterministic conformance probe has not been run on this server yet, so the screen here is semantic-only. Posture: advisory. Confidences are reported but not yet calibrated (calibrated=false at v1). Full verdict history is not shown on this page.

Own this server? Screen its description →

That verdict was true at screening time (snapshot 2026-08-04).

Contracts can change after screening, with no version bump. The gate pins io.github.kalehdoo/warehouse-mcp’s tool contracts on first sight and holds any silent change before your agent acts - the check that keeps being true on Tuesday.

See your first HOLD in 2 minutes →

Embed this badge

A live verdict badge for your README or listing. It reflects the current screen, links back here, and updates when the verdict does.

Markdown

[![mcpindex](https://mcpindex.ai/api/v1/badge/io-github-kalehdoo-warehouse-mcp)](https://mcpindex.ai/server/io-github-kalehdoo-warehouse-mcp)

HTML

<a href="https://mcpindex.ai/server/io-github-kalehdoo-warehouse-mcp"><img src="https://mcpindex.ai/api/v1/badge/io-github-kalehdoo-warehouse-mcp" alt="mcpindex verdict" height="20" /></a>

Environment variables

MCP_TRANSPORT

Set to 'stdio' for desktop AI clients (Claude Desktop, Cursor). Defaults to 'http'.

WAREHOUSE_TYPE

required

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

secret

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

secret

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

secret

Postgres password.

ORACLE_USER

Oracle user. Required when WAREHOUSE_TYPE=oracle.

ORACLE_PASSWORD

secret

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.

MCP quality score · maturity, not trust · methodology

freshness

completeness

installability

documentation

stability

Alternatives in Databases

Cortex RMCP

ai.dinglebear/cortex

Self-hosted homelab log intelligence over MCP, CLI, and REST with SQLite/FTS.

Aiven MCP

io.aiven/mcp

Provision PostgreSQL, manage Apache Kafka, and deploy apps with Aiven - all from your AI assistant.

io.github.kiki830621/che-apple-mail-mcp

Apple Mail MCP — 44 tools, SQLite millisecond search, .emlx parser, batch ops

Install this server

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "--",
        "warehouse-mcp"
      ],
      "env": {
        "MCP_TRANSPORT": "stdio",
        "WAREHOUSE_TYPE": "<warehouse_type>",
        "MCP_API_KEYS": "<your-mcp_api_keys>",
        "DUCKDB_PATH": "<duckdb_path>",
        "MOTHERDUCK_TOKEN": "<your-motherduck_token>",
        "PG_HOST": "<pg_host>",
        "PG_DATABASE": "<pg_database>",
        "PG_USER": "<pg_user>",
        "PG_PASSWORD": "<your-pg_password>",
        "ORACLE_USER": "<oracle_user>",
        "ORACLE_PASSWORD": "<your-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": "off",
        "MCP_RATE_LIMIT_RPM": "0"
      }
    }
  }
}

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "--",
        "warehouse-mcp"
      ],
      "env": {
        "MCP_TRANSPORT": "stdio",
        "WAREHOUSE_TYPE": "<warehouse_type>",
        "MCP_API_KEYS": "<your-mcp_api_keys>",
        "DUCKDB_PATH": "<duckdb_path>",
        "MOTHERDUCK_TOKEN": "<your-motherduck_token>",
        "PG_HOST": "<pg_host>",
        "PG_DATABASE": "<pg_database>",
        "PG_USER": "<pg_user>",
        "PG_PASSWORD": "<your-pg_password>",
        "ORACLE_USER": "<oracle_user>",
        "ORACLE_PASSWORD": "<your-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": "off",
        "MCP_RATE_LIMIT_RPM": "0"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

npx -y -- warehouse-mcp

Claude Code (claude mcp add)

claude mcp add --scope user warehouse-mcp -- npx -y -- warehouse-mcp

Gemini CLI (gemini mcp add)

gemini mcp add -s user warehouse-mcp npx -y -- warehouse-mcp

Verdict API

curl -s mcpindex.ai/api/v1/trust/server/io-github-kalehdoo-warehouse-mcp

Free-tier verdict as JSON: decision + dimensions + severity. Call it from your agent before it invokes a tool it just discovered.

Details

version: v0.4.2
category: Databases
verdict expires: 2026-08-02
quality: 81 / 100
operator: kalehdoo

Listing

Listed from the official MCP registry. Unclaimed by its maintainer. Maintainer? Email us →

Provenance

Each verdict is bound to a hash of the exact description it judged, so a re-crawl that changes the text produces a new record rather than silently inheriting this one. Verdict history is hash-chained and anchored to Bitcoin via OpenTimestamps (latest confirmed at block 960,824). Verify it yourself.

Links

Repository →Website →