PostgreSQL
postgresql.orgPostgreSQL is a trusted, open-source relational database known for reliability, strong data integrity, and powerful querying. It’s widely used across production workloads to store structured data with features like transactions, indexing, and flexible SQL. Teams rely on PostgreSQL to keep critical business information accurate and accessible for reporting, automation, and decision-making.
Connecting PostgreSQL gives BOBs direct access to your structured business data, enabling them to write and maintain records reliably (including insert, update, and upsert patterns) while also retrieving the exact data they need via SQL or custom queries. Instead of waiting for manual exports or batch jobs, BOBs can monitor your database and trigger actions when new tables, columns, or rows appear—or when rows are newly created or updated.
This unlocks high-impact automation use cases such as maintaining live customer, order, inventory, or case records; syncing data between internal systems; powering event-driven operations (e.g., “when a new order row arrives, create downstream tasks”); and generating analytics-ready outputs by querying the latest state of your database on demand. BOBs can turn PostgreSQL into the real-time “source of truth” that other tools and processes respond to automatically.
What can BOBs do with PostgreSQL?
Perform actions
- Delete Row(s)
- Execute SQL Query
- Find Row
- Find Row With Custom Query
- Insert Row
- List Schema Options
- Query SQL Database
- Update Row
- Upsert Row
Listen to real-time events
- New Column
- New or Updated Row
- New Row
- New Row Custom Query
- New Table