AgentHubAgentHub

warehouse-mcp

MCP ServerMCP Registry官方收录

io.github.kalehdoo/warehouse-mcp · v0.4.2

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

源仓库 ↗

概览

warehouse-mcp 是一个MCP Server，收录自 官方 MCP Registry。支持 stdio 传输。本页提供 Cursor、Claude Code 等客户端的安装配置片段。

安装

选择你的平台查看安装方式

{
  "mcpServers": {
    "warehouse-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "warehouse-mcp"
      ],
      "env": {
        "WAREHOUSE_TYPE": "<WAREHOUSE_TYPE>"
      }
    }
  }
}

环境变量

MCP_TRANSPORT可选

Set to 'stdio' for desktop AI clients (Claude Desktop, Cursor). Defaults to 'http'.

WAREHOUSE_TYPE必填

Which warehouse to connect to. One of: postgres, oracle, redshift, snowflake, bigquery, duckdb. (DuckDB also handles MotherDuck via DUCKDB_PATH=md:<db>.)

MCP_API_KEYS可选secret

Comma-separated bearer keys with role and optional warehouse-role impersonation: 'key1:reader,key2:admin', 'key3:reader:set_role=alice'. Leave empty for stdio (OS process boundary is the trust boundary). Required for HTTP.

DUCKDB_PATH可选

DuckDB file path, ':memory:', or 'md:<database>' for MotherDuck. Required when WAREHOUSE_TYPE=duckdb.

MOTHERDUCK_TOKEN可选secret

MotherDuck service token. Required when DUCKDB_PATH starts with 'md:'.

PG_HOST可选

Postgres host. Required when WAREHOUSE_TYPE=postgres. (Use REDSHIFT_HOST for Redshift.)

PG_DATABASE可选

Postgres database name.

PG_USER可选

Postgres user.

PG_PASSWORD可选secret

Postgres password.

ORACLE_USER可选

Oracle user. Required when WAREHOUSE_TYPE=oracle.

ORACLE_PASSWORD可选secret

Oracle password.

ORACLE_CONNECT_STRING可选

Oracle Easy Connect (e.g. host:1521/SERVICE), TNS descriptor, or alias.

SNOWFLAKE_ACCOUNT可选

Snowflake account identifier (e.g. xy12345.us-east-1). Required when WAREHOUSE_TYPE=snowflake.

SNOWFLAKE_USER可选

Snowflake username.

SNOWFLAKE_PRIVATE_KEY_PATH可选

Path to PKCS8 private key (.p8). Snowflake auth is key-pair only; password auth is not supported.

BIGQUERY_PROJECT可选

GCP project id. Required when WAREHOUSE_TYPE=bigquery.

GOOGLE_APPLICATION_CREDENTIALS可选

Path to BigQuery service-account JSON. Omit on GKE / Cloud Run with workload identity.

GUARDRAIL_PII_MASK可选

Set to 'on' to enable role-aware PII masking on result rows (emails, SSNs, phones, IPs, Luhn-validated CCs). Off by default.

MCP_RATE_LIMIT_RPM可选

Per-principal token-bucket rate limit on tool invocations. 0 = disabled. Recommend 60 for production.

相关资源

统一 Manifest

{
  "id": "io.github.kalehdoo/warehouse-mcp",
  "type": "mcp-server",
  "version": "0.4.2",
  "displayName": "warehouse-mcp",
  "description": "Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.",
  "repository": {
    "url": "https://github.com/kalehdoo/warehouse-mcp",
    "source": "github"
  },
  "homepage": "https://github.com/kalehdoo/warehouse-mcp",
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "warehouse-mcp",
        "version": "0.4.2",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "MCP_TRANSPORT",
            "description": "Set to 'stdio' for desktop AI clients (Claude Desktop, Cursor). Defaults to 'http'."
          },
          {
            "name": "WAREHOUSE_TYPE",
            "description": "Which warehouse to connect to. One of: postgres, oracle, redshift, snowflake, bigquery, duckdb. (DuckDB also handles MotherDuck via DUCKDB_PATH=md:<db>.)",
            "isRequired": true
          },
          {
            "name": "MCP_API_KEYS",
            "description": "Comma-separated bearer keys with role and optional warehouse-role impersonation: 'key1:reader,key2:admin', 'key3:reader:set_role=alice'. Leave empty for stdio (OS process boundary is the trust boundary). Required for HTTP.",
            "isSecret": true
          },
          {
            "name": "DUCKDB_PATH",
            "description": "DuckDB file path, ':memory:', or 'md:<database>' for MotherDuck. Required when WAREHOUSE_TYPE=duckdb."
          },
          {
            "name": "MOTHERDUCK_TOKEN",
            "description": "MotherDuck service token. Required when DUCKDB_PATH starts with 'md:'.",
            "isSecret": true
          },
          {
            "name": "PG_HOST",
            "description": "Postgres host. Required when WAREHOUSE_TYPE=postgres. (Use REDSHIFT_HOST for Redshift.)"
          },
          {
            "name": "PG_DATABASE",
            "description": "Postgres database name."
          },
          {
            "name": "PG_USER",
            "description": "Postgres user."
          },
          {
            "name": "PG_PASSWORD",
            "description": "Postgres password.",
            "isSecret": true
          },
          {
            "name": "ORACLE_USER",
            "description": "Oracle user. Required when WAREHOUSE_TYPE=oracle."
          },
          {
            "name": "ORACLE_PASSWORD",
            "description": "Oracle password.",
            "isSecret": true
          },
          {
            "name": "ORACLE_CONNECT_STRING",
            "description": "Oracle Easy Connect (e.g. host:1521/SERVICE), TNS descriptor, or alias."
          },
          {
            "name": "SNOWFLAKE_ACCOUNT",
            "description": "Snowflake account identifier (e.g. xy12345.us-east-1). Required when WAREHOUSE_TYPE=snowflake."
          },
          {
            "name": "SNOWFLAKE_USER",
            "description": "Snowflake username."
          },
          {
            "name": "SNOWFLAKE_PRIVATE_KEY_PATH",
            "description": "Path to PKCS8 private key (.p8). Snowflake auth is key-pair only; password auth is not supported."
          },
          {
            "name": "BIGQUERY_PROJECT",
            "description": "GCP project id. Required when WAREHOUSE_TYPE=bigquery."
          },
          {
            "name": "GOOGLE_APPLICATION_CREDENTIALS",
            "description": "Path to BigQuery service-account JSON. Omit on GKE / Cloud Run with workload identity."
          },
          {
            "name": "GUARDRAIL_PII_MASK",
            "description": "Set to 'on' to enable role-aware PII masking on result rows (emails, SSNs, phones, IPs, Luhn-validated CCs). Off by default."
          },
          {
            "name": "MCP_RATE_LIMIT_RPM",
            "description": "Per-principal token-bucket rate limit on tool invocations. 0 = disabled. Recommend 60 for production."
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.kalehdoo/warehouse-mcp",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.kalehdoo%2Fwarehouse-mcp/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}
warehouse-mcp — MCP Server 安装与配置 · AgentHub