AcademyWorkflowsOperations

SMS alerts from Postgres queries with Twilio

Operations and support teams who need a text message when a database reading looks unusual.

  • Recommendedour rating
  • 3,185views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

send-sms-alerts-based-on-database-queries-twilio-and-postgres.json

Loading the file...

What it does

An n8n workflow that runs every minute and queries a Postgres database for outlier readings that have not triggered an alert yet. For each one, it sends an SMS through Twilio and then marks the reading as notified, so it is not sent twice. It is the second workflow in a database monitoring tutorial.

Use cases

  1. 01Get an SMS when a sensor reading is an outlier
  2. 02Send each alert once and mark it as notified
  3. 03Monitor a Postgres table every minute

Connects

Postgres · Twilio

Questions about
SMS alerts from Postgres queries with Twilio.

What is SMS alerts from Postgres queries with Twilio used for?

Operations and support teams who need a text message when a database reading looks unusual. An n8n workflow that runs every minute and queries a Postgres database for outlier readings that have not triggered an alert yet. For each one, it sends an SMS through Twilio and then marks the reading as notified, so it is not sent twice. It is the second workflow in a database monitoring tutorial.

How do I import SMS alerts from Postgres queries with Twilio into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is SMS alerts from Postgres queries with Twilio safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.