Install dbivio

Set up dbivio on a GitHub repository in under 5 minutes. dbivio runs on every Postgres migration PR and posts a verdict comment.

1. Install the GitHub App

Visit the App page and pick the repositories you want analyzed.

2. Connect a stats source

dbivio uses your real Postgres table statistics to predict lock duration. Pick one:

• MonPG agent (recommended). If you already use MonPG, it already collects schema/stats. dbivio reads via the MonPG API. Connect MonPG →
• Read-only connection string. Provide a connection URL to a staging replica or a read-only role on production. dbivio only reads catalog tables.
• Manual schema upload. Run a provided introspection query on your DB and paste the JSON output. Refresh weekly.

3. Open a PR with SQL

dbivio detects migration files in your PR (Alembic, Prisma, Rails, Flyway, raw SQL) and posts a verdict comment in 5–15 seconds.

# In your repo:
git checkout -b add-status-column
echo "ALTER TABLE orders ADD COLUMN status VARCHAR(20) NOT NULL;" \
  > migrations/V42__add_status.sql
git add migrations/V42__add_status.sql
git commit -m "Add status column to orders"
gh pr create --title "Add status column"
# dbivio comments on the PR within ~10 seconds

4. Configure (optional)

Manage rules, severity overrides, and migration paths from the dashboard.