cosmic-mcp

All servers

warehouse-mcp

io.github.kalehdoo/warehouse-mcp · version 0.4.2

Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.

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

https://github.com/kalehdoo/warehouse-mcp

Quick facts

  • Listing: Community
  • Published May 6, 21:52 UTC
  • Transport: stdio
  • Package: npm warehouse-mcp 0.4.2
  • Listed by cosmic-mcp: Nov 9, 04:26 UTC

Data and analytics Databases

Setup snippets

Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.

Run it locally (npm)

npx -y '[email protected]'

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "warehouse-mcp": {
      "args": [
        "-y",
        "[email protected]"
      ],
      "command": "npx",
      "env": {
        "BIGQUERY_PROJECT": "<your bigquery project>",
        "DUCKDB_PATH": "<your duckdb path>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your google application credentials>",
        "GUARDRAIL_PII_MASK": "<your guardrail pii mask>",
        "MCP_API_KEYS": "<your mcp api keys>",
        "MCP_RATE_LIMIT_RPM": "<your mcp rate limit rpm>",
        "MCP_TRANSPORT": "<your mcp transport>",
        "MOTHERDUCK_TOKEN": "<your motherduck token>",
        "ORACLE_CONNECT_STRING": "<your oracle connect string>",
        "ORACLE_PASSWORD": "<your oracle password>",
        "ORACLE_USER": "<your oracle user>",
        "PG_DATABASE": "<your pg database>",
        "PG_HOST": "<your pg host>",
        "PG_PASSWORD": "<your pg password>",
        "PG_USER": "<your pg user>",
        "SNOWFLAKE_ACCOUNT": "<your snowflake account>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<your snowflake private key path>",
        "SNOWFLAKE_USER": "<your snowflake user>",
        "WAREHOUSE_TYPE": "<your warehouse type>"
      }
    }
  }
}

Claude Code

claude mcp add 'warehouse-mcp' -- npx -y '[email protected]'

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "warehouse-mcp": {
      "args": [
        "-y",
        "[email protected]"
      ],
      "command": "npx",
      "env": {
        "BIGQUERY_PROJECT": "<your bigquery project>",
        "DUCKDB_PATH": "<your duckdb path>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your google application credentials>",
        "GUARDRAIL_PII_MASK": "<your guardrail pii mask>",
        "MCP_API_KEYS": "<your mcp api keys>",
        "MCP_RATE_LIMIT_RPM": "<your mcp rate limit rpm>",
        "MCP_TRANSPORT": "<your mcp transport>",
        "MOTHERDUCK_TOKEN": "<your motherduck token>",
        "ORACLE_CONNECT_STRING": "<your oracle connect string>",
        "ORACLE_PASSWORD": "<your oracle password>",
        "ORACLE_USER": "<your oracle user>",
        "PG_DATABASE": "<your pg database>",
        "PG_HOST": "<your pg host>",
        "PG_PASSWORD": "<your pg password>",
        "PG_USER": "<your pg user>",
        "SNOWFLAKE_ACCOUNT": "<your snowflake account>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<your snowflake private key path>",
        "SNOWFLAKE_USER": "<your snowflake user>",
        "WAREHOUSE_TYPE": "<your warehouse type>"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "warehouse-mcp": {
      "args": [
        "-y",
        "[email protected]"
      ],
      "command": "npx",
      "env": {
        "BIGQUERY_PROJECT": "<your bigquery project>",
        "DUCKDB_PATH": "<your duckdb path>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your google application credentials>",
        "GUARDRAIL_PII_MASK": "<your guardrail pii mask>",
        "MCP_API_KEYS": "<your mcp api keys>",
        "MCP_RATE_LIMIT_RPM": "<your mcp rate limit rpm>",
        "MCP_TRANSPORT": "<your mcp transport>",
        "MOTHERDUCK_TOKEN": "<your motherduck token>",
        "ORACLE_CONNECT_STRING": "<your oracle connect string>",
        "ORACLE_PASSWORD": "<your oracle password>",
        "ORACLE_USER": "<your oracle user>",
        "PG_DATABASE": "<your pg database>",
        "PG_HOST": "<your pg host>",
        "PG_PASSWORD": "<your pg password>",
        "PG_USER": "<your pg user>",
        "SNOWFLAKE_ACCOUNT": "<your snowflake account>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<your snowflake private key path>",
        "SNOWFLAKE_USER": "<your snowflake user>",
        "WAREHOUSE_TYPE": "<your warehouse type>"
      },
      "type": "stdio"
    }
  }
}

Related servers

  • spotdb Verified domain
    Ephemeral data sandbox for AI workflows with guardrails and security
  • Analytics Legends — SAP AI & Analytics MCP Server Verified domain
    SAP AI & analytics market data for agents: SAP firms, day rates, jobs, Joule & BDC news
  • Ankra Verified domain
    Deploy and operate Kubernetes: clusters, stacks, apps, logs, metrics and security, with OAuth.
  • AutoRFP.ai Verified domain
    Search AutoRFP.ai projects, requirements, content library, and tags for Q&A and analytics.
  • Dubai Data — Dubai real estate statistics Verified domain
    Dubai property prices, AED/sqft, sales, rents, yields and projects from DLD registered transactions.
  • Reasonbook Verified domain
    Reasonbook: decisions that survive the session, in a local record AI agents keep.