Integration

Connect PostgreSQL to Postali

When something happens in PostgreSQL, your agent does the next thing in Postali. Describe it in plain language and the automation is built, tested on every branch and kept running.

PostgreSQL4 triggersPostgreSQL6 actionsPostali8 actions

Browse all apps

Build it

What do you want PostgreSQL and Postali to do together?

Describe it and your agent reads both APIs, builds the automation, tests every branch and ships it. The list below is what exists today, not the limit.

Ask the assistant

You'll sign in before anything runs. What you typed comes with you.

Or work from Claude Code

Install the APIANT plugin for Claude Code and build, edit, test and read run history from your terminal. Every plan gets this, including free, and it spends no assistant credits.

Connect Claude Code

Everything your agent can do with PostgreSQL and Postali

Triggers and actions 4 triggers · 14 actions

Trigger
New or Updated Row
Triggers when a new row is added or modified.
Trigger
New or Updated Row (Custom Query)
Fires for each new or changed row returned by a SELECT statement you write against the connected PostgreSQL database.
Trigger
New Row
Triggers when you add a new row.
Trigger
New Table
Fires when a new table appears in the connected PostgreSQL database.
Action
Add Row
Adds a new row.
Action
Delete Row
Delete the rows in a table whose chosen column equals a value.
Action
Find Row
Finds a row in a table via a lookup column.
Action
Find Rows via Custom Query
Runs a SELECT statement you write against the connected PostgreSQL database and returns every row it matches.
Action
Find Row via Custom Query
Runs a SELECT statement you write against the connected PostgreSQL database and returns the first row it matches.
Action
Update Row
Updates an existing row.
Action
Find postal codes in bulk
Batch lookup of multiple postal codes in one call. POST /api/v1/{country}/bulk — send a list of codes, get back the per-code results (same shape as Get postal code).
Action
Find postal locations by query
Fuzzy search over settlement names, municipalities, and postal codes for a country. GET /api/v1/{country}/search?q=...&limit=. Useful for autocomplete.
Action
Get municipality
Get detail for one municipality identified by state + municipality path segments. GET /api/v1/{country}/municipio/{estado}/{municipio}.
Action
Get postal code
Look up a postal code (CP) for a country (mx/co/es). GET /api/v1/{country}/cp/{codigo} — returns estado, municipio, and all asentamientos (settlements) tied to the code.
Action
Get state
Get detail (with totals) for one state/department/province by slug. GET /api/v1/{country}/estado/{slug}.
Action
List municipalities
List municipalities belonging to a given state, by state slug. GET /api/v1/{country}/estado/{slug}/municipios.
Action
List states
List level-1 administrative divisions (states/departments/provinces) for a country, with precomputed totals. GET /api/v1/{country}/estados.
Action
Validate postal code
Quick validation of a postal code — returns whether it exists and how many asentamientos it covers, without the full list. GET /api/v1/{country}/validate/{codigo}. Useful for checkout form gating.

Each app on its own

The other way round: Postali to PostgreSQL