{"library":"warehouse-mcp","type":"library","category":null,"description":"Production-ready MCP (Model Context Protocol) server for data warehouses. Supports Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, and MotherDuck with read-only enforcement, four-tier role-based access, optional warehouse-role impersonation (SET ROLE for native RLS/CLS), JSONL audit log, and optional output PII masking. Self-host via Docker or npx. Current version 0.4.2, released monthly. Differentiators: dialect-aware read-only validation, per-key RLS mapping, 13 tools including column profiling and time-series bucketing.","language":"javascript","status":"active","version":"0.4.2","tags":["javascript","mcp","model-context-protocol","postgres","oracle","snowflake","bigquery","redshift","duckdb"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install warehouse-mcp","imports":["npx @kalehdoo/warehouse-mcp","docker pull ghcr.io/kalehdoo/warehouse-mcp:latest","WAREHOUSE_TYPE=postgres\nWAREHOUSE_HOST=localhost\nWAREHOUSE_PORT=5432\nMCP_API_KEYS=key1:reader\nMCP_AUDIT_LOG_PATH=/var/log/warehouse-mcp/audit.jsonl"]},{"cmd":"yarn add warehouse-mcp","imports":[]},{"cmd":"pnpm add warehouse-mcp","imports":[]}],"homepage":"https://github.com/kalehdoo/warehouse-mcp#readme","github":"https://github.com/kalehdoo/warehouse-mcp","docs":null,"changelog":null,"pypi":null,"npm":"warehouse-mcp","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}