Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.
To add warehouse-mcp to Claude, run the install command below or copy the ready-made config for Claude Code, Claude Desktop, Cursor and VS Code further down. Restart your client after adding it and its tools show up in your next conversation. It needs 19 environment variables, listed below.
Install
npx -y warehouse-mcp@0.4.2Environment variables
MCP_TRANSPORTSet in your MCP configWAREHOUSE_TYPESet in your MCP configMCP_API_KEYSSet in your MCP configDUCKDB_PATHSet in your MCP configMOTHERDUCK_TOKENSet in your MCP configPG_HOSTSet in your MCP configPG_DATABASESet in your MCP configPG_USERSet in your MCP configPG_PASSWORDSet in your MCP configORACLE_USERSet in your MCP configORACLE_PASSWORDSet in your MCP configORACLE_CONNECT_STRINGSet in your MCP configSNOWFLAKE_ACCOUNTSet in your MCP configSNOWFLAKE_USERSet in your MCP configSNOWFLAKE_PRIVATE_KEY_PATHSet in your MCP configBIGQUERY_PROJECTSet in your MCP configGOOGLE_APPLICATION_CREDENTIALSSet in your MCP configGUARDRAIL_PII_MASKSet in your MCP configMCP_RATE_LIMIT_RPMSet in your MCP configInstall with your client
claude mcp add warehouse --env MCP_TRANSPORT=<YOUR_MCP_TRANSPORT> --env WAREHOUSE_TYPE=<YOUR_WAREHOUSE_TYPE> --env MCP_API_KEYS=<YOUR_MCP_API_KEYS> --env DUCKDB_PATH=<YOUR_DUCKDB_PATH> --env MOTHERDUCK_TOKEN=<YOUR_MOTHERDUCK_TOKEN> --env PG_HOST=<YOUR_PG_HOST> --env PG_DATABASE=<YOUR_PG_DATABASE> --env PG_USER=<YOUR_PG_USER> --env PG_PASSWORD=<YOUR_PG_PASSWORD> --env ORACLE_USER=<YOUR_ORACLE_USER> --env ORACLE_PASSWORD=<YOUR_ORACLE_PASSWORD> --env ORACLE_CONNECT_STRING=<YOUR_ORACLE_CONNECT_STRING> --env SNOWFLAKE_ACCOUNT=<YOUR_SNOWFLAKE_ACCOUNT> --env SNOWFLAKE_USER=<YOUR_SNOWFLAKE_USER> --env SNOWFLAKE_PRIVATE_KEY_PATH=<YOUR_SNOWFLAKE_PRIVATE_KEY_PATH> --env BIGQUERY_PROJECT=<YOUR_BIGQUERY_PROJECT> --env GOOGLE_APPLICATION_CREDENTIALS=<YOUR_GOOGLE_APPLICATION_CREDENTIALS> --env GUARDRAIL_PII_MASK=<YOUR_GUARDRAIL_PII_MASK> --env MCP_RATE_LIMIT_RPM=<YOUR_MCP_RATE_LIMIT_RPM> -- npx -y warehouse-mcp@0.4.2
Run this in a terminal to add the server to Claude Code.
What this does
warehouse-mcp exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation.
Requirements
This server needs the following environment variables to be set before it can run:
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
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Frequently asked questions
How do I install warehouse-mcp?
Run the Claude Code command in the install section to add warehouse-mcp to Claude Code, or copy the ready-made config for your client from the install section on this page. Restart your client afterwards and the tools appear in your next conversation.
Which clients work with warehouse-mcp?
This page carries setup and config for Claude Code, Claude Desktop, Cursor and VS Code. Any other MCP client that accepts a standard server config can connect to warehouse-mcp as well.
Does warehouse-mcp need an API key?
Yes. Before it can run, set these environment variables: 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. They go in the env block of your MCP config.
Imported from the Official MCP Registry. The details above come from the registry entry; the maker can claim this listing to correct them, add docs, and see its traffic.
Is this your MCP server?
Claim this listing to see its traffic, fix details yourself, and skip the review queue on future updates.
Add this badge to your README
Show visitors this server is listed in the ClaudeRules directory. The badge links straight to this listing.
[](https://clauderules.net/mcp/io-github-kalehdoo-warehouse-mcp)<a href="https://clauderules.net/mcp/io-github-kalehdoo-warehouse-mcp" target="_blank" rel="noopener noreferrer"><img src="https://clauderules.net/api/badge/io-github-kalehdoo-warehouse-mcp" alt="Listed on clauderules.net" /></a>More Database MCP servers
GitHub
Connect AI assistants to GitHub - manage repos, issues, PRs, and workflows through natural language.
Serena MCP: the IDE for your agent
A powerful toolkit for coding, providing semantic retrieval and editing capabilities.
MCP Toolbox for Databases
MCP Toolbox for Databases enables your agent to connect to your database.
Figma-Context-MCP
Give your coding agent access to your Figma data. Implement designs in any framework in one-shot.