SECOPS
Log Every Security MR Decision to a Postgres Review Ledger
When a security-labeled GitLab MR is approved, merged, or closed, records the outcome, reviewer, risk tier, and time-to-decision into a Postgres audit ledger for compliance…
How it runs
The automated pipeline, trigger to output.
- TriggerGitLab MR approved, merged, or closedGitLab
- LogicKeep only security-labeled MRs
- ActionExtract reviewer, tier, decision, time-to-decision
- OutputUpsert row into Postgres review ledgerPostgres
What it does
Builds an immutable record of how each security-flagged merge request was handled, who approved it, at what risk tier, and how long it took, so you can answer auditors and track review throughput over time.
When to use it
Run this when you need evidence for SOC 2 / ISO change-management controls, or simply want metrics on security review volume, approval rates, and SLA adherence per reviewer.
How it works
- 1A GitLab webhook fires on merge request `approved`, `merge`, and `close` events.
- 2A branch filters to MRs that carry a `sec/*` label, dropping non-security MRs.
- 3The flow extracts the MR ID, risk tier, assigned reviewer, decision type, and computes time-from-label-to-decision.
- 4It upserts a row into the Postgres `security_review_ledger` table keyed by MR ID.
- 5The final step confirms the write and emits the ledger row for downstream BI, giving you a queryable compliance trail.
Set it up
What you configure once, before turning it on.
- 1Connect GitLabRepos, MRs, pipelines, registry.
- 2Connect PostgresAny Postgres URL — query, write, migrate.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More SecOps workflows
Compile a weekly WAF tuning review with trends to Confluence
Every week an agent rolls up Cloudflare WAF block clusters by rule and ASN, compares them to prior weeks for trend direction.
Sensitive Dropbox Link Owner Remediation Loop
When a newly created Dropbox shared link points to a sensitive file, this workflow DMs the file owner, gives them a deadline to justify or revoke it.
Post-Revocation Verification and Audit Logging
After a key is revoked, it confirms the old credential actually fails, verifies the replacement works.
Exposed-Secret Incident Triage and Remediation Agent
An agent-driven workflow that investigates a reported leaked secret end to end, decides revoke-versus-escalate, executes the rotation.
Page on-call when a WAF rule mass-blocks legitimate traffic
On demand or every few minutes, it detects a single Cloudflare WAF rule suddenly blocking a broad spread of ASNs and paths (a likely false-positive storm).
PII Content Scan on New Dropbox External Share
When a file gets an external Dropbox link, it reads the file content, uses an AI classifier to detect PII or secrets.
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.