SERVER

warehouse-mcp

Rank #44,426

io.github.kalehdoo/warehouse-mcp

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

4 versions

by kalehdoo (1 servers)View repository ↗Claim this server

First listed

May 5, 2026

Last publish date

May 6, 2026

OVERVIEW

warehouse-mcp is a Model Context Protocol (MCP) server published by kalehdoo. It ranks #44,426 of 137,492 servers tracked on MCP Toplist. warehouse-mcp is listed across 3 registries — Official MCP, PulseMCP and Glama, with 4 tracked versions. It was first listed on May 5, 2026 and most recently updated on May 6, 2026.

STANDING

#44,426of 137,492 tracked serversTop 50%

Ranks ahead of 93,066 of 137,492 servers on MCP Toplist.

CONNECT

Use warehouse-mcp

API keyNeeds credentials

Requires user-supplied configuration before first use — typically an API key, token or connection string set via environment variables.

npm package

claude mcp add warehouse-mcp -e "MCP_TRANSPORT=<your MCP_TRANSPORT>" -e "WAREHOUSE_TYPE=<your WAREHOUSE_TYPE>" -e "MCP_API_KEYS=<your MCP_API_KEYS>" -e "DUCKDB_PATH=<your DUCKDB_PATH>" -e "MOTHERDUCK_TOKEN=<your MOTHERDUCK_TOKEN>" -e "PG_HOST=<your PG_HOST>" -e "PG_DATABASE=<your PG_DATABASE>" -e "PG_USER=<your PG_USER>" -e "PG_PASSWORD=<your PG_PASSWORD>" -e "ORACLE_USER=<your ORACLE_USER>" -e "ORACLE_PASSWORD=<your ORACLE_PASSWORD>" -e "ORACLE_CONNECT_STRING=<your ORACLE_CONNECT_STRING>" -e "SNOWFLAKE_ACCOUNT=<your SNOWFLAKE_ACCOUNT>" -e "SNOWFLAKE_USER=<your SNOWFLAKE_USER>" -e "SNOWFLAKE_PRIVATE_KEY_PATH=<your SNOWFLAKE_PRIVATE_KEY_PATH>" -e "BIGQUERY_PROJECT=<your BIGQUERY_PROJECT>" -e "GOOGLE_APPLICATION_CREDENTIALS=<your GOOGLE_APPLICATION_CREDENTIALS>" -e "GUARDRAIL_PII_MASK=<your GUARDRAIL_PII_MASK>" -e "MCP_RATE_LIMIT_RPM=<your MCP_RATE_LIMIT_RPM>" -- npx -y start warehouse-mcp

Replace each placeholder with your own value before saving.

npm package

[mcp_servers.warehouse-mcp]
command = "npx"
args = ["-y", "start", "warehouse-mcp"]

[mcp_servers.warehouse-mcp.env]
MCP_TRANSPORT = "<your MCP_TRANSPORT>"
WAREHOUSE_TYPE = "<your WAREHOUSE_TYPE>"
MCP_API_KEYS = "<your MCP_API_KEYS>"
DUCKDB_PATH = "<your DUCKDB_PATH>"
MOTHERDUCK_TOKEN = "<your MOTHERDUCK_TOKEN>"
PG_HOST = "<your PG_HOST>"
PG_DATABASE = "<your PG_DATABASE>"
PG_USER = "<your PG_USER>"
PG_PASSWORD = "<your PG_PASSWORD>"
ORACLE_USER = "<your ORACLE_USER>"
ORACLE_PASSWORD = "<your ORACLE_PASSWORD>"
ORACLE_CONNECT_STRING = "<your ORACLE_CONNECT_STRING>"
SNOWFLAKE_ACCOUNT = "<your SNOWFLAKE_ACCOUNT>"
SNOWFLAKE_USER = "<your SNOWFLAKE_USER>"
SNOWFLAKE_PRIVATE_KEY_PATH = "<your SNOWFLAKE_PRIVATE_KEY_PATH>"
BIGQUERY_PROJECT = "<your BIGQUERY_PROJECT>"
GOOGLE_APPLICATION_CREDENTIALS = "<your GOOGLE_APPLICATION_CREDENTIALS>"
GUARDRAIL_PII_MASK = "<your GUARDRAIL_PII_MASK>"
MCP_RATE_LIMIT_RPM = "<your MCP_RATE_LIMIT_RPM>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "start",
        "warehouse-mcp"
      ],
      "env": {
        "MCP_TRANSPORT": "<your MCP_TRANSPORT>",
        "WAREHOUSE_TYPE": "<your WAREHOUSE_TYPE>",
        "MCP_API_KEYS": "<your MCP_API_KEYS>",
        "DUCKDB_PATH": "<your DUCKDB_PATH>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "PG_HOST": "<your PG_HOST>",
        "PG_DATABASE": "<your PG_DATABASE>",
        "PG_USER": "<your PG_USER>",
        "PG_PASSWORD": "<your PG_PASSWORD>",
        "ORACLE_USER": "<your ORACLE_USER>",
        "ORACLE_PASSWORD": "<your ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<your ORACLE_CONNECT_STRING>",
        "SNOWFLAKE_ACCOUNT": "<your SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<your SNOWFLAKE_USER>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<your SNOWFLAKE_PRIVATE_KEY_PATH>",
        "BIGQUERY_PROJECT": "<your BIGQUERY_PROJECT>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GUARDRAIL_PII_MASK": "<your GUARDRAIL_PII_MASK>",
        "MCP_RATE_LIMIT_RPM": "<your MCP_RATE_LIMIT_RPM>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "start",
        "warehouse-mcp"
      ],
      "env": {
        "MCP_TRANSPORT": "<your MCP_TRANSPORT>",
        "WAREHOUSE_TYPE": "<your WAREHOUSE_TYPE>",
        "MCP_API_KEYS": "<your MCP_API_KEYS>",
        "DUCKDB_PATH": "<your DUCKDB_PATH>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "PG_HOST": "<your PG_HOST>",
        "PG_DATABASE": "<your PG_DATABASE>",
        "PG_USER": "<your PG_USER>",
        "PG_PASSWORD": "<your PG_PASSWORD>",
        "ORACLE_USER": "<your ORACLE_USER>",
        "ORACLE_PASSWORD": "<your ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<your ORACLE_CONNECT_STRING>",
        "SNOWFLAKE_ACCOUNT": "<your SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<your SNOWFLAKE_USER>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<your SNOWFLAKE_PRIVATE_KEY_PATH>",
        "BIGQUERY_PROJECT": "<your BIGQUERY_PROJECT>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GUARDRAIL_PII_MASK": "<your GUARDRAIL_PII_MASK>",
        "MCP_RATE_LIMIT_RPM": "<your MCP_RATE_LIMIT_RPM>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

npm package

{
  "servers": {
    "warehouse-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "start",
        "warehouse-mcp"
      ],
      "env": {
        "MCP_TRANSPORT": "<your MCP_TRANSPORT>",
        "WAREHOUSE_TYPE": "<your WAREHOUSE_TYPE>",
        "MCP_API_KEYS": "<your MCP_API_KEYS>",
        "DUCKDB_PATH": "<your DUCKDB_PATH>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "PG_HOST": "<your PG_HOST>",
        "PG_DATABASE": "<your PG_DATABASE>",
        "PG_USER": "<your PG_USER>",
        "PG_PASSWORD": "<your PG_PASSWORD>",
        "ORACLE_USER": "<your ORACLE_USER>",
        "ORACLE_PASSWORD": "<your ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<your ORACLE_CONNECT_STRING>",
        "SNOWFLAKE_ACCOUNT": "<your SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<your SNOWFLAKE_USER>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<your SNOWFLAKE_PRIVATE_KEY_PATH>",
        "BIGQUERY_PROJECT": "<your BIGQUERY_PROJECT>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GUARDRAIL_PII_MASK": "<your GUARDRAIL_PII_MASK>",
        "MCP_RATE_LIMIT_RPM": "<your MCP_RATE_LIMIT_RPM>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "start",
        "warehouse-mcp"
      ],
      "env": {
        "MCP_TRANSPORT": "<your MCP_TRANSPORT>",
        "WAREHOUSE_TYPE": "<your WAREHOUSE_TYPE>",
        "MCP_API_KEYS": "<your MCP_API_KEYS>",
        "DUCKDB_PATH": "<your DUCKDB_PATH>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "PG_HOST": "<your PG_HOST>",
        "PG_DATABASE": "<your PG_DATABASE>",
        "PG_USER": "<your PG_USER>",
        "PG_PASSWORD": "<your PG_PASSWORD>",
        "ORACLE_USER": "<your ORACLE_USER>",
        "ORACLE_PASSWORD": "<your ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<your ORACLE_CONNECT_STRING>",
        "SNOWFLAKE_ACCOUNT": "<your SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<your SNOWFLAKE_USER>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<your SNOWFLAKE_PRIVATE_KEY_PATH>",
        "BIGQUERY_PROJECT": "<your BIGQUERY_PROJECT>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GUARDRAIL_PII_MASK": "<your GUARDRAIL_PII_MASK>",
        "MCP_RATE_LIMIT_RPM": "<your MCP_RATE_LIMIT_RPM>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

npm package

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "start",
        "warehouse-mcp"
      ],
      "env": {
        "MCP_TRANSPORT": "<your MCP_TRANSPORT>",
        "WAREHOUSE_TYPE": "<your WAREHOUSE_TYPE>",
        "MCP_API_KEYS": "<your MCP_API_KEYS>",
        "DUCKDB_PATH": "<your DUCKDB_PATH>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "PG_HOST": "<your PG_HOST>",
        "PG_DATABASE": "<your PG_DATABASE>",
        "PG_USER": "<your PG_USER>",
        "PG_PASSWORD": "<your PG_PASSWORD>",
        "ORACLE_USER": "<your ORACLE_USER>",
        "ORACLE_PASSWORD": "<your ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<your ORACLE_CONNECT_STRING>",
        "SNOWFLAKE_ACCOUNT": "<your SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<your SNOWFLAKE_USER>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<your SNOWFLAKE_PRIVATE_KEY_PATH>",
        "BIGQUERY_PROJECT": "<your BIGQUERY_PROJECT>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your GOOGLE_APPLICATION_CREDENTIALS>",
        "GUARDRAIL_PII_MASK": "<your GUARDRAIL_PII_MASK>",
        "MCP_RATE_LIMIT_RPM": "<your MCP_RATE_LIMIT_RPM>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.kalehdoo%2Fwarehouse-mcp.svg)](https://mcptoplist.com/server/io.github.kalehdoo%2Fwarehouse-mcp)

HTML

<a href="https://mcptoplist.com/server/io.github.kalehdoo%2Fwarehouse-mcp"><img src="https://mcptoplist.com/badge/io.github.kalehdoo%2Fwarehouse-mcp.svg" alt="MCP Toplist: Top 50% of 137,492" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

REGISTRIES

Listed on 3 registries

Official MCP

PulseMCP

Glama

ORGANIZATION

kalehdoo

Organization

kalehdoo

Servers in org

Versions across org

VERSIONS

Available versions (4)

Version	Published
0.4.2	May 6, 2026
0.4.1	May 6, 2026
0.4.0	May 6, 2026
0.3.4	May 6, 2026

FAQ

Frequently asked questions

Who maintains warehouse-mcp?: warehouse-mcp is maintained by kalehdoo, which publishes 1 MCP server (4 total versions) tracked on MCP Toplist.
Is warehouse-mcp listed on the Official MCP Registry?: Yes — warehouse-mcp is listed on the Official MCP Registry, alongside PulseMCP and Glama.
How many versions does warehouse-mcp have?: MCP Toplist tracks 4 versions of warehouse-mcp, most recently published on May 6, 2026.
Where can I find the source code for warehouse-mcp?: The source code for warehouse-mcp is hosted at github.com/kalehdoo/warehouse-mcp.

Used in projects

Do you run this server?

Add to a project

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers