DEVOPS

Daily build-cache hit-rate scorecard across pipelines

Runs every morning to roll up the prior day's CI cache hit rates per project and job, writes a trend snapshot to Postgres.

CategoryDevOps
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily morning schedule
  • ActionPull prior-day pipelines and job cache statsGitLabGitLab
  • ActionWrite daily hit-rate snapshot to PostgresPostgreSQLPostgres
  • LogicRank largest declines vs trailing week
  • OutputPost ranked cache scorecard to SlackSlack

What it does

Once a day it aggregates the previous 24 hours of CI pipeline cache stats, computes per-project and per-job hit rates, and compares them to the trailing week. It stores the daily snapshot in Postgres for trend history and posts a Slack scorecard ranking the caches that lost the most ground.

When to use it

Use it as a standing health report so cache degradation is visible before it becomes a fire. Unlike the real-time detectors, this is the slow-moving dashboard that surfaces gradual erosion, newly added jobs with no caching, and which teams' pipelines are quietly getting more expensive.

How it works

  1. 1A scheduled trigger fires each morning.
  2. 2The flow pulls the prior day's pipeline and job records from GitLab and parses cache restore/save outcomes.
  3. 3It computes per-job hit rates and writes the daily snapshot to Postgres.
  4. 4It reads the trailing-week history from Postgres and ranks the largest declines.
  5. 5It posts a ranked scorecard, with sparkline-style deltas, to the team Slack channel.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect GitLabRepos, MRs, pipelines, registry.
  2. 2
    Connect PostgresAny Postgres URL — query, write, migrate.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  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.