pickfit

BrowseDeveloper CLIs

DryRun PostgreSQL MCP

Offline PostgreSQL schema CLI and MCP server for linting, migration safety, and query validation.

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.6 Compress/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

Linux x86_64

You need first

  • Runtimes: Go 1.26+
  1. Install dryrun globally via npm

    npm install -g @boringsql/dryrun

Check that it works

dryrun --version 2>&1

The 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>&1

From a project folder that contains a dryrun schema snapshot, run dryrun lint to check the schema.

What it does

  • Lint PostgreSQL schemas offline
    How to use it
    1. Open a terminal in your project folder that holds the schema snapshot.
    2. Run dryrun lint to list errors and warnings for each table.
    Tested
  • Check how safe a migration is
    How to use it
    1. Write your migration SQL to a file such as <migration.sql>.
    2. Run dryrun check migration <migration.sql> to see the lock type and how long it is held.
    Tested
  • Check queries against your schema
    How to use it
    1. Save your query to a file such as <query.sql>.
    2. Run dryrun check query <query.sql> to confirm it is valid for the schema.
    Tested
  • Compare schema snapshots to find drift
    How to use it
    1. Run dryrun snapshot diff <snapshot1> <snapshot2> with two snapshot IDs to list the changes between them.
    Tested

How far pickfit got

Linux x86_64

  1. Installs
  2. Starts
  3. 4 of 4 features work
  4. 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

How to read a tool card

Stitching
pickfit installed this tool itself. Everything under the stitches comes from that run. A tool pickfit has not run never gets stitches.
Verified on your OS
The install steps ran on the system you chose. “Ran on Linux only” means it has not been run on yours yet.
macOS, Linux and WindowsWhere it ran
Green OS marks: pickfit ran the install steps there. Grey ones: the README says it runs there, and pickfit has not tried.
How far the run got
Installs and starts, its main function works, its service answers, it produces model output. A window means a desktop app opened; a plug, an MCP client used it. The mark sits beside the run’s result, under “Why it fits and how we know” and in “How pickfit tested it”.
Visual check
pickfit looked at screenshots of the app. Green: it looks right. Amber with a number: things that look wrong; open it to see them. Grey and dashed: not checked yet.
Known vulnerabilities
Known high or critical vulnerabilities (OSV.dev) in what it installs. Green: none known. Red with a number: how many; open it for the list, and read it before you install. Grey and dashed: not checked, which does not mean safe.
About the run
The day it ran, and the version that ran.
Source of a reason
Every reason a pick fits rests on one profile field. Open the reason to see the field and the value it relies on.
Hidden gem
High quality, little known.
Quality and popularity
Two scores out of 100. Quality: how well it installed and worked when pickfit tried it, and how good its install docs and upkeep are. Popularity: from stars, downloads and Hacker News.
Features checked
Of the main features the README advertises, how many the run actually exercised (green), and how many failed (red). Grey ones were not checked, and the card says why.
Not verified
A well-known tool Fitz mentions from general knowledge. No run record, no steps, no score.