io.github.kalehdoo/warehouse-mcp MCP Server
io.github.kalehdoo/warehouse-mcp
What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the io.github.kalehdoo/warehouse-mcp MCP server?
Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.
How to install io.github.kalehdoo/warehouse-mcp
Copy-paste configuration for popular MCP clients.
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.
DUCKDB_PATHDuckDB file path, ':memory:', or 'md:<database>' for MotherDuck. Required when WAREHOUSE_TYPE=duckdb.
MOTHERDUCK_TOKENsecretMotherDuck service token. Required when DUCKDB_PATH starts with 'md:'.
PG_HOSTPostgres host. Required when WAREHOUSE_TYPE=postgres. (Use REDSHIFT_HOST for Redshift.)
PG_DATABASEPostgres database name.
PG_USERPostgres user.
PG_PASSWORDsecretPostgres password.
ORACLE_USEROracle user. Required when WAREHOUSE_TYPE=oracle.
ORACLE_PASSWORDsecretOracle password.
ORACLE_CONNECT_STRINGOracle Easy Connect (e.g. host:1521/SERVICE), TNS descriptor, or alias.
SNOWFLAKE_ACCOUNTSnowflake account identifier (e.g. xy12345.us-east-1). Required when WAREHOUSE_TYPE=snowflake.
SNOWFLAKE_USERSnowflake username.
SNOWFLAKE_PRIVATE_KEY_PATHPath to PKCS8 private key (.p8). Snowflake auth is key-pair only; password auth is not supported.
BIGQUERY_PROJECTGCP project id. Required when WAREHOUSE_TYPE=bigquery.
GOOGLE_APPLICATION_CREDENTIALSPath to BigQuery service-account JSON. Omit on GKE / Cloud Run with workload identity.
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.
{
"mcpServers": {
"warehouse-mcp": {
"command": "npx",
"args": [
"-y",
"warehouse-mcp",
"start"
],
"env": {
"MCP_TRANSPORT": "<YOUR_MCP_TRANSPORT>",
"WAREHOUSE_TYPE": "<YOUR_WAREHOUSE_TYPE>",
"MCP_API_KEYS": "<YOUR_MCP_API_KEYS>",
"DUCKDB_PATH": "<YOUR_DUCKDB_PATH>",
"MOTHERDUCK_TOKEN": "<YOUR_MOTHERDUCK_TOKEN>",
"PG_HOST": "<YOUR_PG_HOST>",
"PG_DATABASE": "<YOUR_PG_DATABASE>",
"PG_USER": "<YOUR_PG_USER>",
"PG_PASSWORD": "<YOUR_PG_PASSWORD>",
"ORACLE_USER": "<YOUR_ORACLE_USER>",
"ORACLE_PASSWORD": "<YOUR_ORACLE_PASSWORD>",
"ORACLE_CONNECT_STRING": "<YOUR_ORACLE_CONNECT_STRING>",
"SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
"SNOWFLAKE_USER": "<YOUR_SNOWFLAKE_USER>",
"SNOWFLAKE_PRIVATE_KEY_PATH": "<YOUR_SNOWFLAKE_PRIVATE_KEY_PATH>",
"BIGQUERY_PROJECT": "<YOUR_BIGQUERY_PROJECT>",
"GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>",
"GUARDRAIL_PII_MASK": "<YOUR_GUARDRAIL_PII_MASK>",
"MCP_RATE_LIMIT_RPM": "<YOUR_MCP_RATE_LIMIT_RPM>"
}
}
}
}Related MCP servers

DB2TOON MCP
Read-only SQL database and plain-text SQL dump schema extraction to compact TOON for MCP clients.
US grid data for agents: LMP, carbon, load, queues, ERCOT large loads, RT−DA spread forecasts.
Real-time oil, gas, and commodity prices for Brent, WTI, natural gas, and 40+ commodities.
View repository →
segment-mcp
Read-first MCP server for Twilio Segment: routing, stale sources, delivery health, governance.

io.github.kalki-kgp/whatsapp-macos
WhatsApp MCP for macOS - Read messages from local DB, send via WhatsApp Web.

io.github.kambleaa007/weather
An MCP server for weather information.

