Skip to content

codeDB Lens vs dryrun

codeDB Lens is a free MCP server for databases. dryrun is an open-source MCP server for databases.

  • codeDB Lens is best for ask what to fix first on a production sql server.
  • dryrun is best for catch an alter table that rewrites a busy table during review.
What it is
codeDB Lens is a free MCP server for databases.
dryrun is an open-source MCP server for databases.
Best for
Ask what to fix first on a production SQL Server
Catch an ALTER TABLE that rewrites a busy table during review
Kind
MCP server
MCP server
Pricing
Free
Open source
Platforms
Windows, Linux, CLI
CLI
Runs
Locally
Locally
Open source
Good for
Ask what to fix first on a production SQL Server; Find out what caused yesterday's slowdown; Answer sales questions from a PostgreSQL table with a read-only login
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

What codeDB Lens does

  • Graded health check

    Runs rules and returns an A to F grade with a coverage seal.

  • Evidence for findings

    Each finding shows collected values, the query behind it and when it ran.

  • Run comparison

    Compares saved runs for new, resolved and persisting findings.

  • Recordings

    Reports on a period recorded from an instance, such as an earlier slowdown.

  • Two login modes

    A minimal login for diagnosis, or a table-reading login for data questions.

  • Redaction

    A flag masks host, database, object, login and file names in results.

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.

codeDB Lens vs dryrun: questions

Is codeDB Lens or dryrun cheaper?

Both are free. Compare current plans on each official site.

What is the difference between codeDB Lens and dryrun?

codeDB Lens is a free MCP server for databases. dryrun is an open-source MCP server for databases.

Keep comparing