Guides

Each guide answers one job. New to the tool? Read your first check first, then come here by what you need to do:

• Set up zero-flag runs — connection profiles
• The app is slow — slow-query triage (works on RDS/managed too)
• Run it on a schedule or in CI — scheduled checks & gating
• Execute the fixes — apply remediation safely
• Move a database — the migrate safe lane
• Prove backups work — restore rehearsal
• Before an upgrade — pre-upgrade assessment
• Let an agent help — agent-driven maintenance
• Inherited a schema — legacy onboarding

• Connection profiles (pgdba-run.toml) — Named connection profiles, zero-flag runs, pooler-aware safety contracts.
• Slow-query triage on production — From 'the app is slow' to a ranked, explainable fix list in one read-only run.
• Recurring checks (cron) — Schedule pgdba with cron or systemd, gate on exit codes, and alert via webhook.
• Apply remediation safely — Review, approve per action, and execute remediation SQL with a full audit trail.
• Migrate: the safe lane — Dry-run first, review the report, then migrate — preflight gates, confirm, verify.
• Rehearse a restore — Prove your backups are restorable, and measure restore throughput against an RTO.
• Pre-upgrade assessment — Know what a PG minor/major upgrade or extension bump will break — before it does.
• Agent-driven maintenance — Let an LLM agent read the JSON report and act through the gated apply path.
• Onboarding onto a legacy schema — First week with an inherited database: the audit that finds what nobody documented.