warehouse mcp MCP

v0.4.2

io.github.kalehdoo/warehouse-mcp

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

transport:stdio runtime:npm

View source Website

Target client

run in your project directory

MCP_TRANSPORT

WAREHOUSE_TYPE

MCP_API_KEYS

DUCKDB_PATH

MOTHERDUCK_TOKEN

PG_HOST

PG_DATABASE

PG_USER

PG_PASSWORD

ORACLE_USER

ORACLE_PASSWORD

ORACLE_CONNECT_STRING

SNOWFLAKE_ACCOUNT

SNOWFLAKE_USER

SNOWFLAKE_PRIVATE_KEY_PATH

BIGQUERY_PROJECT

GOOGLE_APPLICATION_CREDENTIALS

GUARDRAIL_PII_MASK

MCP_RATE_LIMIT_RPM

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

claude mcp add warehouse-mcp -e MCP_TRANSPORT=<MCP_TRANSPORT> -e WAREHOUSE_TYPE=<WAREHOUSE_TYPE> -e MCP_API_KEYS=<MCP_API_KEYS> -e DUCKDB_PATH=<DUCKDB_PATH> -e MOTHERDUCK_TOKEN=<MOTHERDUCK_TOKEN> -e PG_HOST=<PG_HOST> -e PG_DATABASE=<PG_DATABASE> -e PG_USER=<PG_USER> -e PG_PASSWORD=<PG_PASSWORD> -e ORACLE_USER=<ORACLE_USER> -e ORACLE_PASSWORD=<ORACLE_PASSWORD> -e ORACLE_CONNECT_STRING=<ORACLE_CONNECT_STRING> -e SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT> -e SNOWFLAKE_USER=<SNOWFLAKE_USER> -e SNOWFLAKE_PRIVATE_KEY_PATH=<SNOWFLAKE_PRIVATE_KEY_PATH> -e BIGQUERY_PROJECT=<BIGQUERY_PROJECT> -e GOOGLE_APPLICATION_CREDENTIALS=<GOOGLE_APPLICATION_CREDENTIALS> -e GUARDRAIL_PII_MASK=<GUARDRAIL_PII_MASK> -e MCP_RATE_LIMIT_RPM=<MCP_RATE_LIMIT_RPM> -- npx -y warehouse-mcp