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 ServerCatch an ALTER TABLE that rewrites a busy table during review
- Kind
- MCP serverMCP server
- Pricing
- FreeOpen source
- Platforms
- Windows, Linux, CLICLI
- Runs
- LocallyLocally
- 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 loginCatch 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.