# warehouse-mcp MCP server

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

## Links
- Registry page: https://www.getdrio.com/mcp/io-github-kalehdoo-warehouse-mcp
- Repository: https://github.com/kalehdoo/warehouse-mcp
- Website: https://github.com/kalehdoo/warehouse-mcp

## Install
- Command: `npx -y warehouse-mcp`
- Auth: Auth required by registry metadata

## Setup notes
- Package: Npm warehouse-mcp v0.4.2
- Environment variable: MCP_TRANSPORT (default stdio)
- Environment variable: WAREHOUSE_TYPE (required; choices postgres, oracle, redshift, snowflake, bigquery, duckdb)
- Environment variable: MCP_API_KEYS (secret)
- Environment variable: DUCKDB_PATH
- Environment variable: MOTHERDUCK_TOKEN (secret)
- Environment variable: PG_HOST
- Environment variable: PG_DATABASE
- Environment variable: PG_USER
- Environment variable: PG_PASSWORD (secret)
- Environment variable: ORACLE_USER
- Environment variable: ORACLE_PASSWORD (secret)
- Environment variable: ORACLE_CONNECT_STRING
- Environment variable: SNOWFLAKE_ACCOUNT
- Environment variable: SNOWFLAKE_USER
- Environment variable: SNOWFLAKE_PRIVATE_KEY_PATH
- Environment variable: BIGQUERY_PROJECT
- Environment variable: GOOGLE_APPLICATION_CREDENTIALS
- Environment variable: GUARDRAIL_PII_MASK (default off; choices on, off)
- Environment variable: MCP_RATE_LIMIT_RPM (default 0)
- The upstream registry signals required auth or secrets.

## Tools
Not captured

## Resources
Not captured

## Prompts
Not captured

## Metadata
- Owner: io.github.kalehdoo
- Version: 0.4.2
- Runtime: Npm
- Transports: STDIO
- License: Not captured
- Language: Not captured
- Stars: Not captured
- Updated: May 6, 2026
- Source: https://registry.modelcontextprotocol.io