Skip to main content

PostgresSQL

PostgreSQL Plugin​

Summary (SEO Meta Description):
The PostgreSQL Plugin in WeHub allows workflows to connect directly to PostgreSQL databases.
Use it to query, insert, update, delete, or upsert records with full schema support and flexible configuration.

Overview​

The PostgreSQL Plugin provides direct integration with Postgres databases.
It enables workflows to perform SQL operations such as queries, inserts, updates, deletes, and upserts.

This plugin is essential for workflows that require persistent storage, relational queries, and transaction handling.
By combining PostgreSQL actions with other WeHub plugins, you can build end-to-end automation pipelines that seamlessly interact with structured data.

Typical Use Cases:

  • Store workflow results in relational tables
  • Run custom SQL queries inside workflows
  • Sync application data with external Postgres databases
  • Automate inserts, updates, and deletes for business logic
  • Ensure idempotent operations with the Upsert action

Available Actions​

  • Delete – Remove records from a table with conditions.
  • Custom – Run custom SQL queries and map inputs/outputs.
  • Insert – Add new rows into a table.
  • Select – Query records with filters, ordering, and limits.
  • Update – Modify existing rows in a table.
  • Upsert – Insert or update rows depending on conflicts.

FAQ​

Q: Do I need to write SQL manually for every action?
A: No. Most actions like Insert, Update, Delete, and Upsert provide structured configuration panels. For more complex logic, use the Custom action with raw SQL.

Q: Does the plugin support schema validation?
A: Yes. You can attach schemas to both inputs and outputs to ensure data consistency across workflows.

Q: Can I run transactions in workflows?
A: Yes. Transaction support depends on the connection configuration. Multiple SQL operations can be executed in order within workflows.

Keywords: WeHub PostgreSQL Plugin, Postgres Workflow Automation, SQL Plugin, Insert Update Delete Upsert Postgres