dryrun vs PostgreSQL MCP Server
dryrun is an open-source MCP server for databases. PostgreSQL MCP Server is an open-source MCP server for databases.
- dryrun is best for catch an alter table that rewrites a busy table during review.
- PostgreSQL MCP Server is best for describe a table and its indexes.
- What it is
- dryrun is an open-source MCP server for databases.PostgreSQL MCP Server is an open-source MCP server for databases.
- Best for
- Catch an ALTER TABLE that rewrites a busy table during reviewDescribe a table and its indexes
- 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 countersDescribe a table and its indexes; Find why a query is slow; Triage a hung app by locks
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 PostgreSQL MCP Server does
Read-only default
Writes require an explicit environment variable.
Schema introspection
Describes columns, keys, constraints and indexes.
Plans with timings
EXPLAIN with actual row counts and timing, plus index advice.
Performance diagnostics
Top queries, unused indexes and seq-scan tables.
Lock inspection
Shows blocked and blocking processes.
Extension checks
Reports whether extensions like pgvector are installed.
dryrun vs PostgreSQL MCP Server: questions
Is dryrun or PostgreSQL MCP Server cheaper?
Both are open source. Compare current plans on each official site.
What is the difference between dryrun and PostgreSQL MCP Server?
dryrun is an open-source MCP server for databases. PostgreSQL MCP Server is an open-source MCP server for databases.