Warehouse Mcp

This is a production-grade read-only gateway to seven major data warehouses: Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, and MotherDuck. It exposes 16 tools for querying, catalog browsing, column profiling, and time-series bucketing with dialect-aware SQL validation. The five-tier role system (semantic_only, metadata_only, reader_restricted, reader, admin) maps cleanly to per-key authorization, and you can delegate to native warehouse roles for RLS and column-level security. JSONL audit logs and optional PII masking are built in. Deploy the Docker image or run via npx. Reach for this when you want LLMs querying your warehouse without writing infrastructure or duplicating access policies.