Skip to content

dryrun vs XERJ

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

  • dryrun is best for catch an alter table that rewrites a busy table during review.
  • XERJ is best for search local code and docs from an agent.
What it is
dryrun is an open-source MCP server for databases.
XERJ is an open-source MCP server for knowledge and memory.
Best for
Catch an ALTER TABLE that rewrites a busy table during review
Search local code and docs from an agent
Kind
MCP server
MCP server
Pricing
Open source
Open source
Platforms
CLI
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
Catch an ALTER TABLE that rewrites a busy table during review; Give a coding agent accurate table, index and constraint context; Spot unused or duplicate indexes from captured counters
Search local code and docs from an agent; Give an agent persistent memory notes; Look up real API definitions

What dryrun does

  • Offline schema snapshots

    Captures the catalogue once so agents never need production credentials.

  • Migration guardrail

    Reports lock type, duration and rewrite risk, with a safer SQL form.

  • Query validation

    Parses SQL and checks columns against the real schema.

  • Linting and audits

    20+ convention rules and 13 structural checks such as duplicate indexes.

  • Query stats diffing

    Collapses ORM variants into shapes and diffs captures to find slowed queries.

  • One-step agent setup

    dryrun setup writes MCP config for Claude Code, Cursor, Codex and Zed.

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.

dryrun vs XERJ: questions

Is dryrun or XERJ cheaper?

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

What is the difference between dryrun and XERJ?

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