This... does not seem like separation of concerns.
Not to mention that the data layer seems like the one where you want to keep things most deterministic.
To decouple this the person would have to broadcast nearly every event and rebuild the observer layers elsewhere.
If you really want to run an agent on each created row, you could run this in a replica and stream the replies back to your system of record.