DEVOPS

Lead-Time Bottleneck Finder for Open Pull Requests

Daily, scans open GitHub pull requests, flags ones stuck in review or awaiting deploy beyond your lead-time target.

CategoryDevOps
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily morning schedule
  • ActionList open PRs with review state and timestampsGitHubGitHub
  • LogicFlag PRs over lead-time threshold, dedupe
  • ActionCreate or update Linear task per stuck PRLinearLinear
  • OutputPost new-bottleneck summary to SlackSlack

What it does

Instead of measuring lead time after the fact, this workflow attacks it while it's still accruing. Each day it scans open pull requests, calculates how long each has been waiting since first review-ready, and flags any exceeding your lead-time target. For each laggard it opens a Linear task assigned to the right owner, so review and deploy bottlenecks get cleared before they hurt your DORA numbers.

When to use it

Use it when lead time for changes is your weak DORA metric and you want a proactive nudge on stuck PRs rather than a postmortem. Ideal for teams that triage work in Linear.

How it works

  1. 1A daily schedule fires each morning.
  2. 2The flow lists all open PRs across tracked repos with their review state and timestamps.
  3. 3A logic step computes age-since-ready per PR and keeps those over the lead-time threshold, deduping ones already flagged.
  4. 4For each flagged PR it creates or updates a Linear task tagged with the PR link and stuck reason.
  5. 5The final step posts a short summary of new bottlenecks to the team's Slack channel.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect GitHubRepos, issues, pull requests, actions.
  2. 2
    Connect LinearIssues, projects, cycles, triage.
  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.