HTTP and MySQL: SSL Certificate Expiry Tracker Template
A daily Spojit workflow that checks the SSL certificate expiry date for each of your domains, records the days remaining in MySQL, and flags any certificate approaching renewal.
What It Builds
A Schedule trigger runs the workflow once a day. A Loop walks your list of domains, and for each one a Connector node in Direct mode uses the http connector to read the certificate's expiry date. A Transform node calculates the days remaining, a MySQL node writes that figure to a tracking table, and a Condition node flags any certificate inside your renewal window.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a daily scheduled workflow that loops over my list of domains, checks each domain's SSL certificate expiry date over HTTPS, calculates the number of days remaining until expiry, writes the domain, expiry date, and days-remaining into a MySQL table called cert_tracking, and flags any certificate expiring within 30 days.Connectors Used
- Schedule trigger - runs the check once a day on a cron you set.
- http - reads each domain's certificate expiry date over HTTPS.
- MySQL - stores the domain, expiry date, and days remaining for tracking.
Customize It
Change the 30-day flag to match your renewal lead time, point the prompt at a different table name, or have it pull the domain list from a MySQL query instead of a fixed list. You can also add the email address or Slack channel where flags should land.
Tips
- Set the Schedule trigger's cron and IANA time zone so the check runs during your working hours.
- Keep the certificate-reading step in Direct mode for a predictable, no-AI-cost run.
- Use a unique key on the domain column so each daily run updates the existing row rather than duplicating it.