Postgres

Read and update PostgreSQL data from workflows used for reporting, synchronization, and operational automation.

What this integration does

Read and update PostgreSQL data from workflows used for reporting, synchronization, and operational automation. Use restricted database credentials to inspect schemas, run bounded queries, generate reports, or synchronize reviewed records with another service.

Available workflow actions

4 actions are available to tools and agents.

  • List tables and inspect schemas Bring current Postgres data into the run before its next decision.
  • Read filtered rows Bring current Postgres data into the run before its next decision.
  • Insert, update, or upsert rows Create Postgres data from a controlled workflow or agent action.
  • Delete rows or run SQL Apply this cleanup through an explicit, controlled Postgres action.

Before you connect

Category

Developer

Authentication

Username and password

What you'll need

The database host, port, database name, and a restricted database user.