Skip to main content
Glama
Crestward

Warehouse Graph MCP Server

by Crestward

warehouse-graph

Shared foundation for two linked projects:

This package will build a metadata/lineage graph from dbt artifacts, compile one policies.yml to database access controls (Postgres RLS / Unity Catalog), and serve the graph over an MCP server.

Status: Phase 0 (setup). So far: repo tooling, local Postgres, and the LLM wrapper that every model call goes through (response cache, cost ledger, hard budget cap, Batch API rounds, prompt caching).

Quick start

cp .env.example .env      # add ANTHROPIC_API_KEY for real model calls
uv sync
make up                   # Postgres 16 via Docker Compose
make check                # lint, format check, type-check, tests
make llm-smoke            # one cheap real call; logs a row to costs.csv

Related MCP server: dagsmith

Docs

Licence

MIT

Related MCP Connectors

Related MCP Servers

  • A
    license
    B
    quality
    C
    maintenance
    A read-only MCP server that exposes dbt project artifacts and data quality result tables (BigQuery/Postgres) to LLM clients, enabling deep introspection, run-history analysis, source freshness, test coverage, and lineage walks.
    27
    34 npm
    MIT
  • A
    license
    Not graded
    quality
    C
    maintenance
    MCP server providing read-only Snowflake metadata tools (schemas, tables, queries, lineage) for agentic data pipeline generation, enabling natural-language-to-pipeline workflows with dbt, Airflow, and Great Expectations.
    1
    MIT
  • A
    license
    A
    quality
    C
    maintenance
    Exposes a governed semantic layer to AI agents so they select metrics and dimensions from a closed, engineer-declared vocabulary instead of writing SQL. Validates every typed call against the contract, rejects out-of-contract requests with structured errors and suggestions, and returns query rows together with the compiled SQL and dbt lineage for auditing.
    4
    MIT