How about simply having an after insert trigger on an alerts table that calls notify, and then you listen for that in node? It's a simple setup with less moving parts and could probably get you a long way...
with alert as (
select alert_id from alerts
where alert_sent_at is null
)
update alerts set
alert_sent_at = now()
from alert
returning *