Skip to content

warehouse-mcp in namespace io.github

Local package path declaredNo credentials listedRepository declared by sourceUpdated 2026-05-06

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.

Report data on this entry

At a glance

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

Vendor's own description, untranslated and unverified

Execution location
Local package path declaredMCP-Register · 2026-08-06
Required secrets declared
No credentials listedMCP-Register · 2026-08-06
Declared version and change
0.4.2 · Source-reported change date 2026-05-06MCP-Register · 2026-08-06
Repository as declared
github.com/kalehdoo/warehouse-mcpMCP-Register · 2026-08-06
Configuration
can be built from the disclosed start template

Inspect connection paths and prerequisites

Related categories

6 of 12 categories. All categories in the segment catalogue

Page last changed:

Sources and collection
Runs
Local package path declared
Credentials
No credentials listed
Registry record changed
2026-05-06
Setup
Template available
Registry name
io.github.kalehdoo/warehouse-mcp
Package coordinate
npm:warehouse-mcp
Declared version
0.4.2
Source-reported listing date
2026-05-06
Source-reported change date
2026-05-06
First seen by tracevero
2026-08-06
Vendor's website
https://github.com/kalehdoo/warehouse-mcp

Evidence for this page: The values on this page come from several collections. Each row therefore states its own origin. What the confidence levels mean

Measured values

Measured values
Required secrets declaredNo credentials listed no
Original data – Required secret variables (raw): confirmed absent
Original data – Required secret headers (raw): confirmed absent
Source: MCP-Register · collected on 2026-08-06 · derived
Execution locationLocal package path declared local
Original data – Transports (raw): stdio
Source: MCP-Register · collected on 2026-08-06 · derived
Path argument presentno
Original data – Path arguments (raw): confirmed absent
Original data – Path environment variables (raw): confirmed absent
Source: MCP-Register · collected on 2026-08-06 · derived
Repository URL listedRepository declared by source yes
Original data – Repository (raw): https://github.com/kalehdoo/warehouse-mcp
Source: MCP-Register · collected on 2026-08-06 · derived
Field of use, derived from the vendor descriptionDatabases
Original data – Description (raw): Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.
Source: MCP-Register · collected on 2026-08-26 · derived
Declared version0.4.2
Source: MCP-Register · collected on 2026-08-06 · self-declared

What is measured is what a manifest declares, not what a piece of software does. This registry fetches no repository URL, no endpoint and no package index; nothing here is verified. Which value comes from which source, and by which rule it was formed, is set out in the Methodology.

Source data25

Evidence for this page: The values on this page come from several collections. Each row therefore states its own origin.

Raw values
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
Embed this badge

Paste this line into a README of your own. The badge states how many values the registry holds for the entry and when it last looked, and it links back to this page.

tracevero: number of measured values and date of collection for this registry entry

[![tracevero: number of measured values and date of collection for this registry entry](https://tracevero.com/badge/mcp/io-github-kalehdoo-warehouse-mcp.svg)](https://tracevero.com/mcp/io-github-kalehdoo-warehouse-mcp)

The image is drawn again on every request, so it always reports the current state while the pasted line stays as it is. It carries no rating and no traffic light – only the two measured figures.

Changes

Changes
2026-09-08Connection 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-26Field of use, derived from the vendor description: – → Databases
2026-08-26Description (raw): – → Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.

These are the 3 most recent changes to this entry. Full history

tracevero · https://tracevero.com/mcp/io-github-kalehdoo-warehouse-mcp