PostgreSQL PR Review
Catch the migration that locks prod for 4 hours.
Before the PR ships.
dbivio reads your real Postgres table stats and predicts lock duration, missing indexes, and slow ALTERs at PR time. GitHub App that posts a verdict on every migration: GO, CAUTION, or BLOCK.
Free for public repos · 50 PR/month free for private · Founding 100: 50% off year 1
Real failures from 2026
These all shipped through PR review. The reviewers couldn't see the table sizes.
ALTER TABLE locked prod for 4 hours
An engineer ran a migration that held an AccessExclusiveLock on the users table. Every endpoint timed out. The migration finished 4 hours and 12 minutes after it started.
Engineering Playbook · Apr 2026
47s prod query, 340ms in dev
The difference was one missing foreign-key index. dev had 1k rows, prod had 240M. The query plan flipped to a seq scan.
Apr 2026 · viral on Medium
Squawk caught nothing
Static lint doesn't know your row counts. A 250M-row ALTER and a 50-row ALTER look the same to it.
Real production incident
How it works
Install the GitHub App
5-minute setup. Pick the repos you want analyzed. Free for public repos.
Connect your Postgres (or MonPG)
Three options: MonPG agent (recommended), read-only connection string, or one-time schema upload. dbivio uses your real row counts and indexes.
Open a PR with SQL
dbivio detects migration files (Alembic, Prisma, Rails, Flyway, raw .sql), runs the risk engine, and posts a verdict comment in 5–15 seconds.
# Example PR comment from dbivio
🔴 dbivio: BLOCK — do not merge as-is 3 migration files analyzed · 2 rules fired · stats source: MonPG | Severity | Rule | File | Issue | |---|---|---|---| | 🔴 BLOCK | R001 | migrations/V42__status.sql:12 | ADD COLUMN NOT NULL on 240M-row table | | 🟡 CAUTION | R005 | migrations/V42__status.sql:8 | Missing FK index on orders.user_id | R001: ADD COLUMN NOT NULL on public.orders (240M rows) will require a full table rewrite under AccessExclusiveLock for ~6.5 minutes. Use the three-step pattern.
Why dbivio
The unique combination: PG-specific + reads real stats + works with whatever migration framework you already use.
| Tool | PG-native | Reads real stats | Migration frameworks | PR-time |
|---|---|---|---|---|
| dbivio | ✅ | ✅ | Alembic / Prisma / Rails / raw SQL | ✅ |
| Squawk | ✅ | ❌ | any | ✅ |
| Atlas | ✅ | ❌ | Atlas DSL only | ✅ |
| CodeRabbit | ❌ | ❌ | any | ✅ |
| GitHub Copilot | ❌ | ❌ | any | ✅ |
| Datafold | ❌ | ❌ | any | ⚠️ |
Pricing
Founding 100: 50% off year 1, lifetime grandfathered.
Free
$0
For trying it out
- ✓Public repos: unlimited
- ✓1 private repo, 50 PR/month
- ✓Top 5 rules
- ✓Raw SQL only
Team
$49/mo
For shipping teams
- ✓5 repos, unlimited PRs
- ✓All 30+ rules
- ✓Alembic / Prisma / Rails / Flyway
- ✓MonPG integration
Business
$149/mo
For larger orgs
- ✓Unlimited repos
- ✓Schema history + deploy block API
- ✓Slack & Linear hooks
- ✓Custom rule overrides
Enterprise
Custom
On-prem / SAML / SSO
- ✓SSO + SAML
- ✓On-prem / VPC deployment
- ✓SOC 2 audit log
- ✓Dedicated Slack channel
FAQ
Does dbivio need access to my production database?
No. Three options: (1) MonPG agent already collects schema/stats, (2) read-only role on staging or replica, (3) one-time schema upload. Production DB is optional.
How is this different from Squawk?
Squawk is a static linter — it doesn't know your table sizes. A 1K-row ALTER and a 240M-row ALTER look the same. dbivio reads real stats and gives you the actual lock duration estimate.
Why not CodeRabbit or Copilot?
They're generic LLM reviewers. They flag SQL injection (security) but can't predict that your migration will lock prod for 4 hours — they don't read your database.
Does it work with Alembic / Prisma / Rails / Flyway?
Yes. Team tier adapters cover all major frameworks. Free tier covers raw .sql files.
Will this slow down my PRs?
Verdict posts in 5–15 seconds for typical migrations. The webhook is async; your CI doesn't wait.
Does dbivio replace my DBA?
No. It catches the 80% of migration risks that show up over and over (missing FK index, ALTER without lock_timeout, full-table rewrites). DBAs handle the 20% that need real judgment.
What's on the roadmap?
Multi-DB (MySQL Q3 2026), schema-drift detection, deploy-gate API. dbivio's vision is a Postgres ship-safety toolkit — PR review is the first product.
Who built this?
Same team behind MonPG (Postgres monitoring, used by 1,000+ developers). We sit one layer up: MonPG watches what's happening, dbivio decides what ships.