Developer & DevOps
Execute Timescale Database Queries on a Scheduled Cron Interval
4 nodes
175
95
Scheduled trigger
Workflow Description
A periodic automation that runs on a predefined schedule to query Timescale databases and send results via HTTP requests, enabling continuous monitoring and automated processing of time-series data without manual intervention.
How it works
- 1.Trigger the workflow at specified times using a Cron expression
- 2.Connect to Timescale database and execute the configured query
- 3.Transform and map the returned data into usable variables
- 4.Send the processed results to a designated HTTP endpoint
Use cases
- Monitor performance metrics and time-series data at regular intervals
- Execute automated data cleanup or archival tasks at specific times
- Generate and distribute scheduled database reports automatically
Requirements
- Valid Timescale database connection credentials and connection details
- Accurate Cron expression that reflects your desired execution schedule
- Correct HTTP endpoint URL configured to receive the data payload
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Timescale Db
Schedule
Details
Trigger
Scheduled trigger
Nodes
4
Apps
2
Views
175
Downloads
95
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (4)
TimescaleDB
Set
Set
Set
HTTP Request
HTTP Request
Cron
Cron