DryRun PostgreSQL MCP
Offline PostgreSQL schema CLI and MCP server for linting, migration safety, and query validation.
Tested on LinuxKnown vulnerabilities
Use it
Before you install: known vulnerabilities
pickfit found 3 known high or critical vulnerabilities in the packages a fresh install brings (OSV.dev, 3 Nov 2026). Weigh this before you install it.
go:github.com/klauspost/compress v1.18.6Compress/s2: Integer Overflow or Wraparound and Out-of-bounds Write in compress (GHSA-259r-337f-4rfw, high, fixed in 1.18.7)go:oras.land/oras-go/v2 v2.6.1`oras-go` tar extraction: Hardlink entry with relative Linkname escapes extract dir via process CWD resolution (GHSA-fxhp-mv3v-67qp, high, fixed in 2.6.2)
See 1 more
go:oras.land/oras-go/v2 v2.6.1— GHSA-m37j-52j7-pjw7 (high), fixed in 2.6.2
Linux x86_64
You need first
- Runtimes:
Go 1.26+
Install dryrun globally via npm
npm install -g @boringsql/dryrun
Check that it works
dryrun --version 2>&1The output should contain “v0.20.0”.
First thing to try
git clone --depth 1 https://github.com/boringsql/dryrun.git /tmp/dryrun-src 2>&1 && ls /tmp/dryrun-src/examples/demo/cd /tmp/dryrun-src/examples/demo && dryrun lint 2>&1From a project folder that contains a dryrun schema snapshot, run dryrun lint to check the schema.
What it does
- Lint PostgreSQL schemas offlineTested
How to use it
- Open a terminal in your project folder that holds the schema snapshot.
- Run
dryrun lintto list errors and warnings for each table.
- Check how safe a migration isTested
How to use it
- Write your migration SQL to a file such as <migration.sql>.
- Run
dryrun check migration <migration.sql>to see the lock type and how long it is held.
- Check queries against your schemaTested
How to use it
- Save your query to a file such as <query.sql>.
- Run
dryrun check query <query.sql>to confirm it is valid for the schema.
- Compare schema snapshots to find driftTested
How to use it
- Run
dryrun snapshot diff <snapshot1> <snapshot2>with two snapshot IDs to list the changes between them.
- Run
How far pickfit got
Linux x86_64
- Installs
- Starts
- 4 of 4 features work
- Works offline
macOS and Windows: the project says it runs there; pickfit hasn’t tried it.
Good for
- lint PostgreSQL schema offline
- validate queries against actual schema
- check migration safety with lock analysis
- explore foreign key graphs
- diff snapshots and detect drift
How pickfit tested it
Each run starts from a clean machine and follows the steps above. How pickfit verifies
Linux x86_64
Its main function works
- Replayed from scratch
- Works offline
- Checked on 30 Oct 2026
- Version v0.20.0