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 reviewReview a pull request that changes a column length
- Kind
- MCP serverMCP server
- Pricing
- Open sourceOpen source
- Platforms
- CLICLI
- Runs
- LocallyLocally
- 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 countersReview 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.