Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.
Use this profile to copy client config, check auth requirements, review tools and resources, and compare related MCP servers before adding it to an AI client.
npx -y warehouse-mcp{
"MCP_TRANSPORT": "stdio",
"WAREHOUSE_TYPE": "YOUR_VALUE_HERE",
"MCP_API_KEYS": "YOUR_SECRET_VALUE",
"DUCKDB_PATH": "YOUR_VALUE_HERE",
"MOTHERDUCK_TOKEN": "YOUR_SECRET_VALUE",
"PG_HOST": "YOUR_VALUE_HERE",
"PG_DATABASE": "YOUR_VALUE_HERE",
"PG_USER": "YOUR_VALUE_HERE",
"PG_PASSWORD": "YOUR_SECRET_VALUE",
"ORACLE_USER": "YOUR_VALUE_HERE",
"ORACLE_PASSWORD": "YOUR_SECRET_VALUE",
"ORACLE_CONNECT_STRING": "YOUR_VALUE_HERE",
"SNOWFLAKE_ACCOUNT": "YOUR_VALUE_HERE",
"SNOWFLAKE_USER": "YOUR_VALUE_HERE",
"SNOWFLAKE_PRIVATE_KEY_PATH": "YOUR_VALUE_HERE",
"BIGQUERY_PROJECT": "YOUR_VALUE_HERE",
"GOOGLE_APPLICATION_CREDENTIALS": "YOUR_VALUE_HERE",
"GUARDRAIL_PII_MASK": "off",
"MCP_RATE_LIMIT_RPM": "0"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-kalehdoo-warehouse-mcp": {
"command": "npx",
"args": [
"-y",
"warehouse-mcp"
],
"env": {
"MCP_TRANSPORT": "stdio",
"WAREHOUSE_TYPE": "YOUR_VALUE_HERE",
"MCP_API_KEYS": "YOUR_SECRET_VALUE",
"DUCKDB_PATH": "YOUR_VALUE_HERE",
"MOTHERDUCK_TOKEN": "YOUR_SECRET_VALUE",
"PG_HOST": "YOUR_VALUE_HERE",
"PG_DATABASE": "YOUR_VALUE_HERE",
"PG_USER": "YOUR_VALUE_HERE",
"PG_PASSWORD": "YOUR_SECRET_VALUE",
"ORACLE_USER": "YOUR_VALUE_HERE",
"ORACLE_PASSWORD": "YOUR_SECRET_VALUE",
"ORACLE_CONNECT_STRING": "YOUR_VALUE_HERE",
"SNOWFLAKE_ACCOUNT": "YOUR_VALUE_HERE",
"SNOWFLAKE_USER": "YOUR_VALUE_HERE",
"SNOWFLAKE_PRIVATE_KEY_PATH": "YOUR_VALUE_HERE",
"BIGQUERY_PROJECT": "YOUR_VALUE_HERE",
"GOOGLE_APPLICATION_CREDENTIALS": "YOUR_VALUE_HERE",
"GUARDRAIL_PII_MASK": "off",
"MCP_RATE_LIMIT_RPM": "0"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
warehouse-mcp is an MCP server for Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.. It supports STDIO transport.
Use the generated config in Install. This server runs with npx -y warehouse-mcp; add any required environment variables before starting your client.
Choose the Claude Desktop tab in Install and copy the config for npx -y warehouse-mcp. Add required environment variables before starting Claude Desktop.
Choose the Claude Code tab in Install and copy the config for npx -y warehouse-mcp. Add required environment variables before starting Claude Code.
Choose the Codex tab in Install and copy the config for npx -y warehouse-mcp. Add required environment variables before starting Codex.
Choose the Cursor or VS Code tab in Install and copy the config for npx -y warehouse-mcp. Add required environment variables before starting Cursor or VS Code.
warehouse-mcp uses STDIO transport. Use the package or command config in Install.
warehouse-mcp inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
warehouse-mcp is marked with Auth required by registry metadata auth. You may need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
warehouse-mcpstdio | npm | 0.4.2 | Env: MCP_TRANSPORT Env: WAREHOUSE_TYPE required Env: MCP_API_KEYS secret Env: DUCKDB_PATH Env: MOTHERDUCK_TOKEN secret Env: PG_HOST Env: PG_DATABASE Env: PG_USER Env: PG_PASSWORD secret Env: ORACLE_USER Env: ORACLE_PASSWORD secret Env: ORACLE_CONNECT_STRING Env: SNOWFLAKE_ACCOUNT Env: SNOWFLAKE_USER Env: SNOWFLAKE_PRIVATE_KEY_PATH Env: BIGQUERY_PROJECT Env: GOOGLE_APPLICATION_CREDENTIALS Env: GUARDRAIL_PII_MASK Env: MCP_RATE_LIMIT_RPM |