Database Event Triggers

Database event triggers activate agents when rows are inserted, updated, or deleted in a Supabase table via Realtime.

Configuration

{
  "trigger_type": "db_event",
  "trigger_config": {
    "connection_id": "uuid",
    "table_name": "public.contracts",
    "events": ["INSERT", "UPDATE"],
    "filter": {
      "column": "status",
      "op": "eq",
      "value": "active"
    },
    "query_template": "New contract created: {{record.id}} - {{record.name}}"
  }
}

Config Fields

Field	Type	Required	Description
connection_id	UUID	Yes	Reference to a Supabase database connection
table_name	string	Yes	Fully qualified table name (e.g., public.contracts)
events	string[]	Yes	Events to listen for: INSERT, UPDATE, DELETE
filter	object	No	Filter condition (column, op, value)
query_template	string	Yes	Template for the agent query

Template Placeholders

Placeholder	Description
{{record.field}}	Current record field value
{{new.field}}	New value (INSERT/UPDATE)
{{old.field}}	Previous value (UPDATE/DELETE)

Authentication

Database event execution is internal — no external authentication needed. The connection uses credentials stored in Vault.