APIANT.aiApp
PostgreSQL
Connect directly to a PostgreSQL database and run SQL statements from your automations.
What your agent can do with PostgreSQL
Triggers and actions 4 triggers · 6 actions
- TriggerNew or Updated Row
Triggers when a new row is added or modified.
- TriggerNew or Updated Row (Custom Query)
Fires for each new or changed row returned by a SELECT statement you write against the connected PostgreSQL database.
- TriggerNew Row
Triggers when you add a new row.
- TriggerNew Table
Fires when a new table appears in the connected PostgreSQL database.
- ActionAdd Row
Adds a new row.
- ActionDelete Row
Delete the rows in a table whose chosen column equals a value.
- ActionFind Row
Finds a row in a table via a lookup column.
- ActionFind Rows via Custom Query
Runs a SELECT statement you write against the connected PostgreSQL database and returns every row it matches.
- ActionFind Row via Custom Query
Runs a SELECT statement you write against the connected PostgreSQL database and returns the first row it matches.
- ActionUpdate Row
Updates an existing row.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Not listed?
Need a trigger or action that is not here?
Ask your agent. Describe what you need in plain language and it reads the PostgreSQL API documentation, builds the operation at whatever depth the API allows, tests every branch and ships it. The list above is what exists today, not the limit.