History of warehouse-mcp in namespace io.github
io.github.kalehdoo/warehouse-mcp · Registry status: active
No name of its own reaches this register for this entry. The heading therefore carries the trailing segment of the identifier; the identifier itself is listed below as a coordinate.
Every published change to this entry, most recent first.
| 2026-09-08 | Connection paths (source structure): – → {"packages":[{"registryType":"npm","identifier":"warehouse-mcp","version":"0.4.2","transport":"stdio","environment":[{"name":"MCP_TRANSPORT","description":"Set to 'stdio' for desktop AI clients (Claude Desktop, Cursor). Defaults to 'http'.","required":false,"secret":false},{"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>.)","format":"string","required":true,"secret":false},{"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.","format":"string","required":false,"secret":true},{"name":"DUCKDB_PATH","description":"DuckDB file path, ':memory:', or 'md:<database>' for MotherDuck. Required when WAREHOUSE_TYPE=duckdb.","format":"string","required":false,"secret":false},{"name":"MOTHERDUCK_TOKEN","description":"MotherDuck service token. Required when DUCKDB_PATH starts with 'md:'.","format":"string","required":false,"secret":true},{"name":"PG_HOST","description":"Postgres host. Required when WAREHOUSE_TYPE=postgres. (Use REDSHIFT_HOST for Redshift.)","required":false,"secret":false},{"name":"PG_DATABASE","description":"Postgres database name.","required":false,"secret":false},{"name":"PG_USER","description":"Postgres user.","required":false,"secret":false},{"name":"PG_PASSWORD","description":"Postgres password.","required":false,"secret":true},{"name":"ORACLE_USER","description":"Oracle user. Required when WAREHOUSE_TYPE=oracle.","required":false,"secret":false},{"name":"ORACLE_PASSWORD","description":"Oracle password.","required":false,"secret":true},{"name":"ORACLE_CONNECT_STRING","description":"Oracle Easy Connect (e.g. host:1521/SERVICE), TNS descriptor, or alias.","required":false,"secret":false},{"name":"SNOWFLAKE_ACCOUNT","description":"Snowflake account identifier (e.g. xy12345.us-east-1). Required when WAREHOUSE_TYPE=snowflake.","required":false,"secret":false},{"name":"SNOWFLAKE_USER","description":"Snowflake username.","required":false,"secret":false},{"name":"SNOWFLAKE_PRIVATE_KEY_PATH","description":"Path to PKCS8 private key (.p8). Snowflake auth is key-pair only; password auth is not supported.","required":false,"secret":false},{"name":"BIGQUERY_PROJECT","description":"GCP project id. Required when WAREHOUSE_TYPE=bigquery.","required":false,"secret":false},{"name":"GOOGLE_APPLICATION_CREDENTIALS","description":"Path to BigQuery service-account JSON. Omit on GKE / Cloud Run with workload identity.","required":false,"secret":false},{"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.","required":false,"secret":false},{"name":"MCP_RATE_LIMIT_RPM","description":"Per-principal token-bucket rate limit on tool invocations. 0 = disabled. Recommend 60 for production.","required":false,"secret":false}],"additional_arguments_declared":true}],"remotes":[]} |
|---|---|
| 2026-08-26 | Field of use, derived from the vendor description: – → Databases |
| 2026-08-26 | Description (raw): – → Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck. |
| 2026-08-16 | Last changed in the registry (raw): – → 2026-05-06 |
| 2026-08-16 | First listed in the registry (raw): – → 2026-05-06 |
| 2026-08-16 | Registry status message (raw): – → – |
| 2026-08-16 | Schema version of the raw record (raw): – → https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json |
| 2026-08-16 | Icon formats (raw): – → – |
| 2026-08-16 | Environment variable descriptions (raw): – → BIGQUERY_PROJECT=GCP project id. Required when WAREHOUSE_TYPE=bigquery. · DUCKDB_PATH=DuckDB file path, ':memory:', or 'md:<database>' for MotherDuck. Required when WAREHOUSE_TYPE=duckdb. · 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_API_KEYS=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. · MCP_RATE_LIMIT_RPM=Per-principal token-bucket rate limit on tool invocations. 0 = disabled. Recommend 60 for production. · MCP_TRANSPORT=Set to 'stdio' for desktop AI clients (Claude Desktop, Cursor). Defaults to 'http'. · MOTHERDUCK_TOKEN=MotherDuck service token. Required when DUCKDB_PATH starts with 'md:'. · ORACLE_CONNECT_STRING=Oracle Easy Connect (e.g. host:1521/SERVICE), TNS descriptor, or alias. · ORACLE_PASSWORD=Oracle password. · ORACLE_USER=Oracle user. Required when WAREHOUSE_TYPE=oracle. · PG_DATABASE=Postgres database name. · PG_HOST=Postgres host. Required when WAREHOUSE_TYPE=postgres. (Use REDSHIFT_HOST for Redshift.) · PG_PASSWORD=Postgres password. · PG_USER=Postgres user. · SNOWFLAKE_ACCOUNT=Snowflake account identifier (e.g. xy12345.us-east-1). Required when WAREHOUSE_TYPE=snowflake. · SNOWFLAKE_PRIVATE_KEY_PATH=Path to PKCS8 private key (.p8). Snowflake auth is key-pair only; password auth is not supported. · SNOWFLAKE_USER=Snowflake username. · WAREHOUSE_TYPE=Which warehouse to connect to. One of: postgres, oracle, redshift, snowflake, bigquery, duckdb. (DuckDB also handles MotherDuck via DUCKDB_PATH=md:<db>.) |
| 2026-08-16 | Environment variable formats (raw): – → string |
| 2026-08-16 | Delivery form (raw): – → package |
| 2026-08-16 | Remote hosts (raw): – → – |
| 2026-08-16 | Remote URLs (raw): – → – |
| 2026-08-16 | Runtime hints (raw): – → – |
| 2026-08-16 | Package versions (raw): – → 0.4.2 |
| 2026-08-16 | Package identifiers (raw): – → warehouse-mcp |
| 2026-08-16 | Repository subfolder (raw): – → – |
| 2026-08-16 | Repository platform (raw): – → github |
| 2026-08-16 | Path environment variables (raw): – → – |
| 2026-08-16 | Required secret headers (raw): – → – |
| 2026-08-06 | Declared version: – → 0.4.2 |
| 2026-08-06 | Repository URL listed: – → yes |
| 2026-08-06 | Path argument present: – → no |
| 2026-08-06 | Execution location: – → local |
| 2026-08-06 | Required secrets declared: – → no |
| 2026-08-06 | Package registries (raw): – → npm |
| 2026-08-06 | Repository (raw): – → https://github.com/kalehdoo/warehouse-mcp |
| 2026-08-06 | Path arguments (raw): – → – |
| 2026-08-06 | Transports (raw): – → stdio |
| 2026-08-06 | Required secret variables (raw): – → – |
| 2026-08-06 | Environment variables (raw): – → 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 |
tracevero · https://tracevero.com/mcp/io-github-kalehdoo-warehouse-mcp/aenderungen