IT OPS
Certificate and Secret Inventory Snapshot to Postgres
Collects all TLS certs and rotating secrets across sources into a normalized daily snapshot in Postgres, building an expiry history you can query and chart for trend reporting.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily snapshot schedule
- ActionPull certificate packs from CloudflareCloudflare
- ActionRead secrets inventory manifest from S3AWS S3
- LogicNormalize sources into common snapshot schema
- ActionUpsert dated rows into Postgres snapshot tablePostgres
- OutputPost expiry-bucket rollup to SlackSlack
What it does
Aggregates certificate and secret metadata from your Cloudflare zones and a tracked secrets manifest, normalizes it into a single schema, and writes a dated snapshot row per credential to Postgres. Over time this produces a queryable history of expiry dates, rotation ages, and how the estate is trending.
When to use it
When you need reporting and dashboards rather than just alerts — for example, a quarterly board metric on credential hygiene, or a Grafana panel showing how many certs are within 30 days of expiry over time. The Postgres table becomes the source of truth other tools read from.
How it works
- 1A daily schedule kicks off the snapshot job.
- 2The flow pulls certificate packs from Cloudflare and the secrets inventory manifest from S3.
- 3It normalizes both sources into a common record: resource, type, owner, expiry, days remaining.
- 4Each record is upserted into a Postgres `cert_secret_snapshots` table keyed by date and resource.
- 5A short rollup query counts items by expiry bucket and posts the daily totals to Slack so trends are visible without opening a dashboard.
Set it up
What you configure once, before turning it on.
- 1Connect CloudflareWorkers, Pages, R2, KV — the edge stack.
- 2Connect AWS S3Buckets, objects, signed URLs.
- 3Connect PostgresAny Postgres URL — query, write, migrate.
- 4Connect SlackChannels, DMs, threads, mentions.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More IT Ops workflows
Daily Building Anomaly Digest to MS Teams
Each morning queries BigQuery for the prior day's flagged sensor anomalies, summarizes them by site and system into a ranked briefing.
Indoor Air Quality Breach to Tenant Notice and Work Order
Listens for CO2, VOC, or humidity sensor alerts via webhook, and when a zone exceeds occupant-safety limits it emails affected tenants, opens a Monday remediation task.
Self-Service Reclaim Email for Idle Users
Detects users idle in a SaaS app past the threshold and emails each one a keep-or-release link; unanswered seats after the deadline are auto-flagged for removal.
Outlook Room Conflict Resolver with Approval Gate in Teams
When an Outlook room clashes, proposes a rebooking and asks the bumped meeting's organizer to approve the move in Microsoft Teams before any change is made.
Outlook Room Double-Booking Resolver with Auto-Rebook
Detects when two meetings claim the same Outlook room resource and automatically relocates the lower-priority meeting to a comparable free room.
Monthly Wasted-License Cost Report
Aggregates inactive-seat data across all tracked SaaS apps each month, computes total reclaimable spend, and delivers a ranked cost report to leadership in Notion and Slack.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.