ENGINEERING

File Linear Cleanup Tickets for Aged-Out Feature Flags

On a schedule, identifies flags older than a configurable age threshold and creates a deduplicated Linear issue for each, assigned to the owning team with flag age, rollout…

CategoryEngineering
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNightly schedule triggers the scan
  • ActionQuery Postgres for flags older than 60 days with owner teamPostgreSQLPostgres
  • LogicCheck Linear for existing open issue per flag keyLinearLinear
  • ActionEnrich with GitLab code referencesGitLabGitLab
  • ActionCreate Linear cleanup issue for each new flagLinearLinear
  • OutputReport created vs skipped ticket counts

What it does

Scans the flag registry for flags whose creation date exceeds an age threshold (default 60 days) regardless of rollout percentage, then files a Linear issue per flag in the owning team's backlog. It dedupes against existing open tickets so reruns never spam the board.

When to use it

Use this when you want flag cleanup to live in your normal sprint planning rather than as auto-generated MRs. It is ideal for teams that prefer a human to decide whether a flag should be removed, kept, or escalated before any code changes. The age threshold catches both fully-rolled-out flags and abandoned experiments stuck at low percentages.

How it works

  1. 1A nightly schedule triggers the run.
  2. 2Query Postgres for flags created more than 60 days ago, joining the owner-team mapping.
  3. 3For each flag, check Linear for an existing open issue with the flag key to avoid duplicates.
  4. 4For new flags, look up code references via GitLab search to enrich the ticket.
  5. 5Create a Linear issue per undocumented flag, set the team, priority by age, and paste rollout state plus file references.
  6. 6Emit a summary count of tickets created versus skipped.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect PostgresAny Postgres URL — query, write, migrate.
  2. 2
    Connect LinearIssues, projects, cycles, triage.
  3. 3
    Connect GitLabRepos, MRs, pipelines, registry.
  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.