Skip to content

dryrun vs orm-preflight

dryrun is an open-source MCP server for databases. orm-preflight is an open-source MCP server for developer tools.

  • dryrun is best for catch an alter table that rewrites a busy table during review.
  • orm-preflight is best for review a pull request that changes a column length.
What it is
dryrun is an open-source MCP server for databases.
orm-preflight is an open-source MCP server for developer tools.
Best for
Catch an ALTER TABLE that rewrites a busy table during review
Review a pull request that changes a column length
Kind
MCP server
MCP server
Pricing
Open source
Open source
Platforms
CLI
CLI
Runs
Locally
Locally
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
Review a pull request that changes a column length; Stop an agent from writing a data-losing migration; Gate CI on migration safety

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 orm-preflight does

  • Drop-and-recreate detection

    Catches a column dropped and re-added in one migration.

  • NOT NULL checks

    Flags new NOT NULL columns without a default.

  • Lock hazards

    Warns about index builds that block writes.

  • Fix guidance

    Each finding gives the reason and a safe alternative.

  • File-only analysis

    Needs no database or network and never runs migrations.

  • Init for legacy projects

    Lets teams adopt it without fixing past migrations.

dryrun vs orm-preflight: questions

Is dryrun or orm-preflight cheaper?

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

What is the difference between dryrun and orm-preflight?

dryrun is an open-source MCP server for databases. orm-preflight is an open-source MCP server for developer tools.

Keep comparing