InnerVault

warehouse-mcp

Stale Official MCP Registry, io.github.kalehdoo

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

Open the source (opens github.com) https://github.com/kalehdoo/warehouse-mcp

Before you use it

  • Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
  • Needs credentials: MCP_API_KEYS, MOTHERDUCK_TOKEN, ORACLE_PASSWORD, PG_PASSWORD. Use a key with the least access you can.

What it is

MCP servers from io.github.kalehdoo.

The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.

How to get it

npm package (stdio)

warehouse-mcp@0.4.2

From the server's entry in the official MCP Registry

Settings it asks for

  • 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…
  • 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.

Related

  1. Warehouse MCP

    MCP servers

    Governed read-only warehouse access for agents: SQL guard, row policies, PII pseudonyms, audit log.

    Stale Official MCP Registry, io.github.tantn89 Updated 15 days ago 2 notes

    warehouse-mcp@0.1.0
  2. GitHub MCP server

    MCP servers

    GitHub's official MCP server. It lets an agent read and work with repositories, issues and pull requests.

    Hand-checked InnerVault (hand-checked), GitHub 34.3k ★MIT

    https://api.githubcopilot.com/mcp/
  3. Apify MCP server

    MCP servers

    Lets an agent run Apify's ready-made scrapers to pull data from websites, search engines, maps and social platforms.

    Hand-checked InnerVault (hand-checked), Apify 16.0k ★MIT

  4. Official MCP Registry

    MCP servers

    The MCP project's own registry of public MCP servers, so you can look for a connector before building one.

    Hand-checked InnerVault (hand-checked), MCP project Moving from MIT to Apache-2.0

  5. MCP reference servers

    MCP servers

    Small example servers from the MCP project (filesystem, git, fetch, memory and more) that show how MCP works.

    Hand-checked InnerVault (hand-checked), MCP project Moving from MIT to Apache-2.0

  6. Anthropic's guide to adding MCP servers to Claude Code, with examples of local and remote servers.

    Hand-checked InnerVault (hand-checked), Anthropic Anthropic documentation