Operations · Intermediate
Reconcile linked business tables and flag broken records
Cross-check related tables for missing keys and mismatched totals
Opens BotBento with this bot ready to create. You check it, create it in one click, then connect its apps. Nothing runs until you do.
- On a scheduleWeekly data sweep
- ThenCheck keys and totals across tables
- ResultReconciliation report with breaks
A bot walks a relational dataset spanning sales, billing, warehouse and support. It checks that every foreign key resolves, that ledger totals agree with invoice lines, and that records for the same buyer share one identity. It lists each break with the tables and rows involved so someone can decide on a fix.
Quick answers
What does it do?
Cross-check related tables for missing keys and mismatched totals. Result: Reconciliation report with breaks.
What does it need?
Tools: PostgreSQL, Slack, Database, Spreadsheet. Intermediate: some setup.
How do I run it?
On a schedule: Weekly data sweep. Copy the prompt below into a bot in BotBento.
Prompt to start with
BotBentoRecommended
Run scheduled consistency sweeps over the connected database. Start from the tables named in the run config, verify that each foreign key resolves, compare ledger and invoice totals, and flag duplicate customer identities that share an address or contact detail. Record every finding with table name, row count and a short description, then post the run summary to the ops channel. Never delete or overwrite rows, and hold any outbound message or payment adjustment until the user approves it.