Raw values for 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.
What the source declared verbatim, unchanged and uninterpreted. The derived values on the overview page are computed from these.
Evidence for this page: The values on this page come from several collections. Each row therefore states its own origin.
| Description (raw) | Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck. Source: MCP-Register · collected on 2026-08-26 · self-declared |
|---|---|
| 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 Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Required secret variables (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Transports (raw) | stdio Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Path arguments (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Repository (raw) | https://github.com/kalehdoo/warehouse-mcp Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Package registries (raw) | npm Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Required secret headers (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Path environment variables (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Remote URLs (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Remote hosts (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Registry status message (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| First listed in the registry (raw) | 2026-05-06 Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Last changed in the registry (raw) | 2026-05-06 Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Schema version of the raw record (raw) | https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Delivery form (raw) | package Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Repository platform (raw) | github Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Repository subfolder (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Package identifiers (raw) | warehouse-mcp Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Package versions (raw) | 0.4.2 Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Runtime hints (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Environment variable formats (raw) | string Source: MCP-Register · collected on 2026-08-16 · self-declared |
| 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>.) Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Icon formats (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| 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":[]} Source: MCP-Register · collected on 2026-09-08 · self-declared |
Position within the directory
How many of the 42,239 published entries carry the same measured value. A reference figure, not an assessment.
- Required secrets declaredno36,126 of 42,239 carry this value (86 %)View these entries
- Execution locationlocal17,143 of 42,239 carry this value (41 %)View these entries
- Path argument presentno41,736 of 42,239 carry this value (99 %)View these entries
- Repository URL listedyes30,309 of 42,239 carry this value (72 %)View these entries
- Field of use, derived from the vendor descriptionDatabases343 of 42,239 carry this value (0.8 %)View these entries
All 5 values together are carried by 166 of 42,239 entries.
tracevero · https://tracevero.com/mcp/io-github-kalehdoo-warehouse-mcp/rohangaben