DEVOPS

Log every CVE scan to Postgres and report weekly staging-gate trends

Records each container image CVE scan result into a Postgres table as it happens.

CategoryDevOps
Enginesim
Difficultyintermediate
Triggerwebhook
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWebhook: completed scan resultHTTP webhook
  • ActionUpsert scan record into Postgres historyPostgreSQLPostgres
  • LogicWeekly: aggregate block rate + recurring CVEs
  • ActionRead Postgres and build trend digestPostgreSQLPostgres
  • OutputPost weekly trend report to TeamsMicrosoft Teams

What it does

Turns one-off scan results into a durable record and a weekly signal. Individual gate decisions are ephemeral; this captures them so you can see whether your block rate is rising, which CVEs keep reappearing, and which images repeatedly fail.

When to use it

Use it when you need evidence for security reviews or want to spot a base image that keeps dragging in the same vulnerabilities week after week.

How it works

  1. 1A webhook trigger fires once per completed scan with image, severities, CVE IDs, and the gate verdict.
  2. 2An action upserts the result into a Postgres scan-history table keyed by image digest and timestamp.
  3. 3A weekly schedule branch later reads the table and aggregates block rate, mean time-to-fix, and the most frequent recurring CVEs.
  4. 4An action formats the aggregates into a readable weekly digest.
  5. 5An output posts the trend report to Microsoft Teams for the platform and security teams.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HTTP webhookTrigger any URL on agent actions.
  2. 2
    Connect PostgresAny Postgres URL — query, write, migrate.
  3. 3
    Connect Microsoft TeamsChannels, chats, files.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.