Install warehouse-mcp for Claude Desktop
Claude Desktop reads mcpServers from claude_desktop_config.json. Restart the app after saving.
- Open ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, %APPDATA%\Claude\claude_desktop_config.json on Windows, or ~/.config/Claude/claude_desktop_config.json on Linux.
- Paste the JSON config below.
- Replace placeholder secrets, then restart the client if it does not reload on its own.
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"kalehdoo-warehouse-mcp": {
"command": "npx",
"args": [
"-y",
"warehouse-mcp@0.4.2"
],
"env": {
"MCP_TRANSPORT": "stdio",
"WAREHOUSE_TYPE": "",
"MCP_API_KEYS": "YOUR_MCP_API_KEYS",
"DUCKDB_PATH": "",
"MOTHERDUCK_TOKEN": "YOUR_MOTHERDUCK_TOKEN",
"PG_HOST": "",
"PG_DATABASE": "",
"PG_USER": "",
"PG_PASSWORD": "YOUR_PG_PASSWORD",
"ORACLE_USER": "",
"ORACLE_PASSWORD": "YOUR_ORACLE_PASSWORD",
"ORACLE_CONNECT_STRING": "",
"SNOWFLAKE_ACCOUNT": "",
"SNOWFLAKE_USER": "",
"SNOWFLAKE_PRIVATE_KEY_PATH": "",
"BIGQUERY_PROJECT": "",
"GOOGLE_APPLICATION_CREDENTIALS": "",
"GUARDRAIL_PII_MASK": "off",
"MCP_RATE_LIMIT_RPM": "0"
}
}
}
}