warehouse-mcp
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_TYPErequired · Which warehouse to connect to. One of: postgres, oracle, redshift, snowflake, bigquery, duckdb. (DuckDB also handles MotherDuck via DUCKDB_PATH=md:<db>.)MCP_API_KEYSsecret · 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_TOKENsecret · 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_PASSWORDsecret · Postgres password.ORACLE_USER· Oracle user. Required when WAREHOUSE_TYPE=oracle.ORACLE_PASSWORDsecret · Oracle password.ORACLE_CONNECT_STRING· Oracle Easy Connect (e.g. host:1521/SERVICE), TNS descriptor, or alias.
Related
-
Warehouse MCP
MCP serversGoverned read-only warehouse access for agents: SQL guard, row policies, PII pseudonyms, audit log.
warehouse-mcp@0.1.0 -
GitHub MCP server
MCP serversGitHub's official MCP server. It lets an agent read and work with repositories, issues and pull requests.
https://api.githubcopilot.com/mcp/ -
Apify MCP server
MCP serversLets an agent run Apify's ready-made scrapers to pull data from websites, search engines, maps and social platforms.
-
Official MCP Registry
MCP serversThe MCP project's own registry of public MCP servers, so you can look for a connector before building one.
-
MCP reference servers
MCP serversSmall example servers from the MCP project (filesystem, git, fetch, memory and more) that show how MCP works.
-
Connect MCP servers to Claude Code
MCP serversAnthropic's guide to adding MCP servers to Claude Code, with examples of local and remote servers.