warehouse mcp for Grok
io.github.kalehdoo/warehouse-mcp
Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.
client:Grok
transport:stdio
runtime:npm
Install warehouse mcp in Grok
.mcp.json (in your project root)
{
"mcpServers": {
"warehouse-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"warehouse-mcp"
],
"env": {
"MCP_TRANSPORT": "<MCP_TRANSPORT>",
"WAREHOUSE_TYPE": "<WAREHOUSE_TYPE>",
"MCP_API_KEYS": "<MCP_API_KEYS>",
"DUCKDB_PATH": "<DUCKDB_PATH>",
"MOTHERDUCK_TOKEN": "<MOTHERDUCK_TOKEN>",
"PG_HOST": "<PG_HOST>",
"PG_DATABASE": "<PG_DATABASE>",
"PG_USER": "<PG_USER>",
"PG_PASSWORD": "<PG_PASSWORD>",
"ORACLE_USER": "<ORACLE_USER>",
"ORACLE_PASSWORD": "<ORACLE_PASSWORD>",
"ORACLE_CONNECT_STRING": "<ORACLE_CONNECT_STRING>",
"SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
"SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
"SNOWFLAKE_PRIVATE_KEY_PATH": "<SNOWFLAKE_PRIVATE_KEY_PATH>",
"BIGQUERY_PROJECT": "<BIGQUERY_PROJECT>",
"GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
"GUARDRAIL_PII_MASK": "<GUARDRAIL_PII_MASK>",
"MCP_RATE_LIMIT_RPM": "<MCP_RATE_LIMIT_RPM>"
}
}
}
}
Grok Build reads Claude Code's .mcp.json and Claude Desktop's config unchanged, so a server you have already set up there needs nothing new. The Grok web app and X integration do not take custom servers. Grok docs