Skip to content

dbt-plan vs XERJ

dbt-plan is an open-source MCP server for databases. XERJ is an open-source MCP server for knowledge and memory.

  • dbt-plan is best for review a dbt pull request for dropped columns.
  • XERJ is best for search local code and docs from an agent.
What it is
dbt-plan is an open-source MCP server for databases.
XERJ is an open-source MCP server for knowledge and memory.
Best for
Review a dbt pull request for dropped columns
Search local code and docs from an agent
Kind
MCP server
MCP server
Pricing
Open source
Open source
Platforms
CLI, self-hosted
CLI, Linux, macOS, self-hosted, API
Runs
Locally
Locally
GitHub stars
19.2K
Last commit
Nov 2026
License
Apache-2.0
Open source
Good for
Review a dbt pull request for dropped columns; Catch broken downstream refs before a production run; Gate dbt CI on a risk exit code
Search local code and docs from an agent; Give an agent persistent memory notes; Look up real API definitions

What dbt-plan does

  • Pre-run DDL prediction

    Shows which columns will be added or dropped before dbt run executes.

  • Downstream breakage check

    Flags models that read a column being dropped upstream.

  • No warehouse connection

    Reads compiled SQL and manifest files only.

  • Several output formats

    check supports text, GitHub and JSON formats and a --select filter.

  • CI workflow generator

    ci-setup writes a GitHub Actions workflow that runs on every PR.

  • Project stats

    stats reports materialization mix and which models it cannot read columns for.

What XERJ does

  • Single binary

    Search, vectors, facts and memory in one Rust program.

  • Evidence-backed answers

    Answers come with the program and evidence used.

  • Runs locally

    Works offline on a CPU, on a laptop or server.

  • Elasticsearch-compatible API

    Exposes an API compatible with Elasticsearch.

  • Reference coding

    Index open-source repos so agents consult real definitions.

  • MCP integration

    Stdio MCP server connects to a running node.

dbt-plan vs XERJ: questions

Is dbt-plan or XERJ cheaper?

Both are open source. Compare current plans on each official site.

What is the difference between dbt-plan and XERJ?

dbt-plan is an open-source MCP server for databases. XERJ is an open-source MCP server for knowledge and memory.