Keyflow

Search Keyflow

Find a shortcut, workflow, MCP server or skill

Generate and insert data into a Postgres database

n8n template #356
This is Workflow 1 in the blog tutorial Database activity monitoring and alerting. Prerequisites A Postgres database set up and credentials. Basic knowledge of JavaScript and SQL. Nodes Cron node starts the workflow every minute. Function node generates sensor data (sensor id (preset), a randomly generated value, timestamp, and notification (preset as false) ) Postgres node inserts the data into a Postgres database. You can create the database for this workflow with the following SQL statement: CREATE TABLE n8n (id SERIAL, sensorid VARCHAR, value INT, timestamp TIMESTAMP, notification BOOLEAN);

Hand off to your agent

Prompt

Help me set up the n8n workflow "Generate and insert data into a Postgres database" (https://n8n.io/workflows/356). It uses: Postgres. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Similar workflows

NameViews
  1. Generate Instagram Content from Top Trends with AI Image Generation72K
  2. AI Agent for realtime insights on meetings16K
  3. Insert Excel data to Postgres12K
  4. WordPress - AI Chatbot to enhance user experience - with Supabase and OpenAI11K
  5. 🤖 Advanced Slackbot with n8n9,377
  6. ETL pipeline for text processing8,734
  7. Query Google Sheets/CSV data through an AI Agent using PostgreSQL8,069
  8. Suspicious Login Detection6,442
Buy me a coffee