Generate & Insert Sensor Data into Postgres DB

This n8n workflow simulates sensor data ingestion by running every minute via a Cron node, generating randomized humidity readings with timestamps using a Function node, and inserting them into a Postgres table. It requires a Postgres database with a predefined table (n8n: id SERIAL, sensor_id VARCHAR, value INT, time_stamp TIMESTAMP, notification BOOLEAN). Ideal for blog tutorials on database monitoring.

Benefits include easy setup for testing data pipelines, alerting systems, or time-series data simulations without real hardware. It saves time on manual data entry and enables quick prototyping of monitoring workflows.

Use cases: Database activity testing, IoT sensor emulation for development, performance benchmarking, or integration into larger alerting systems as shown in n8n's blog on database monitoring and alerting. Extend by adding more sensors or real data sources.