Integration

Connect PostgreSQL to Open Government, Ireland

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

PostgreSQL4 triggersPostgreSQL6 actionsOpen Government, Ireland8 actions

Browse all apps

Build it

What do you want PostgreSQL and Open Government, Ireland 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 Open Government, Ireland

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 datasets by search criteria
Search the Ireland open-data catalog for datasets matching a Solr query. Endpoint: GET /api/3/action/package_search with params q, fq, sort, rows, start. Returns count + list of matching dataset dicts (package_search).
Action
Find records in a resource
Query the structured data (DataStore) of a specific published resource (CSV/table), returning matching rows. Endpoint: GET /api/3/action/datastore_search?resource_id={resource_id}&q={query}&limit={limit}&offset={offset}.
Action
Get dataset
Fetch full metadata for one dataset (package) by id or name, including its resources. Endpoint: GET /api/3/action/package_show?id={id}.
Action
List datasets
List the names/ids of all datasets in the catalog, paginated. Endpoint: GET /api/3/action/package_list?limit={limit}&offset={offset}.
Action
List groups
List thematic groups/categories datasets can belong to. Endpoint: GET /api/3/action/group_list.
Action
List organizations
List all publishing organizations (government bodies) registered in the catalog. Endpoint: GET /api/3/action/organization_list.
Action
List tags
List all tags used across datasets in the catalog, for discovery/filtering. Endpoint: GET /api/3/action/tag_list.
Action
Run SQL against a resource
Run a read-only SQL query against one or more DataStore resources for advanced filtering/aggregation. Endpoint: GET /api/3/action/datastore_search_sql?sql={sql}.

Each app on its own

The other way round: Open Government, Ireland to PostgreSQL