I built a tool that runs your Postgres migrations before they hit production

pgfence is a CLI tool that statically analyzes Postgres migration files to predict lock modes and suggest safe rewrites. Its new trace mode spins up an ephemeral Docker container, executes each statement against real Postgres, and compares actual lock behavior to static predictions—catching table rewrites and implicit locks that static analysis misses. Notably, it uses a polling observer connection to verify CONCURRENTLY statements, which other tools skip.