Skip to content

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 review
Describe a table and its indexes
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
Describe 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.

Keep comparing