HTTP and MySQL: Service Response Time Trend Recorder Template
This Spojit template samples an endpoint's response time on a schedule and records each measurement in MySQL, building a time-series you can chart for performance trends.
What It Builds
A Schedule trigger fires at a fixed interval. A Connector node in Direct mode uses the http connector to call your endpoint and capture how long it took to respond. A second Direct-mode Connector node uses the mysql connector to insert that measurement, the timestamp, and the returned status code into a table you can later chart.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that runs every 5 minutes, sends an HTTP GET request to https://api.example.com/health, measures the response time in milliseconds, and inserts a row into the MySQL table response_times with the columns checked_at, endpoint, status_code, and response_ms.Connectors Used
- Schedule trigger - runs the check on a fixed cron interval in your timezone.
- http - calls the endpoint and captures status and timing.
- mysql - inserts each measurement as a new row.
Customize It
Change the interval (every minute, hourly), swap the URL for any endpoint you monitor, and rename the table or columns to match your schema. Add an endpoint label per row so one table can track several services. You can also point the http connector at an authenticated URL by adding the required header in the prompt.
Tips
- Keep the mysql connection scoped to a write-enabled user on just the metrics table.
- Store
checked_atas a real datetime so charting tools can plot trends cleanly. - Direct mode is ideal here: each step is one exact action, so there is no AI cost on every run.