Docs Hub
Start here if you want to install pgfence, run it in your editor or CI, understand the rule set, or see how the cloud beta and trust pages relate to the OSS package.
Start Here
Quick start
Run the analyzer against your first migration in under a minute.
PR review demo
See a realistic before-and-after migration review with the GitHub markdown reporter.
Install
Install globally, with npx, or as a pre-push guardrail.
CI mode
Fail builds only when the risk threshold is exceeded.
Editor support
Use the bundled LSP server in VS Code or any other LSP-capable editor.
ORM migrations
See exactly how TypeORM, Knex, Sequelize, Prisma, and Drizzle are analyzed.
Trace mode
Verify static predictions against a disposable Docker Postgres container.
Learn the core
- Introduction for the product story and trust contract.
- PR review demo for a concrete example of a dangerous migration getting rewritten before merge.
- Lock and safety checks for the rule matrix.
- Output formats for CLI, JSON, GitHub, SARIF, and GitLab output.
- ORM migrations for extractor and transpiler behavior.
- Editor support for the VS Code extension and bundled LSP server.
- Plugins if you want to extend the analyzer locally.
Buying and trust
- Cloud beta overview for the design partner program around approvals, policy, and review history.
- Pricing for the free OSS plus design-partner governance path.
- Security for data handling, trust boundaries, and disclosure.
- Contact for early access, enterprise questions, or security review.
Related work
The ecosystem proof is already public, and this is where we keep it easy to browse.
- strong_migrations vs pgfence for the Rails migration safety comparison.
- Eugene vs pgfence for the trace-mode comparison.
- Squawk vs pgfence for the SQL-only linter comparison.
- TypeORM Migrations Are Dangerous for a concrete pain-point post.
- pglt + pgfence for the PostgreSQL language server companion story.
Want the product pitch instead of the docs tree? Start at the homepage.