Skip to main content
skill CX Codex

postmortem-aggregator — Claude Code skill for incident analysis

postmortem-aggregator turns Post Mortem files in a folder into incident statistics and updates POMO_AGGREGATED.md. Use it to spot recurring causes across incidents.

Apache-2.0 ★ 151 updated 2026-10-12

Install into Claude Code · Plugin marketplace All methods and platforms ↓
/plugin marketplace add gemini-cli-extensions/sre
/plugin install sre-extension@sre
Open on GitHub

What postmortem-aggregator does

The skill reads Post Mortem files from a chosen folder and creates pomo_stats.csv, with one row per incident. It records outage start and end, detection and mitigation times, root-cause class, and outage size. It then calculates outage duration, time to detect, time to mitigate, and the detection-time ratio.

It writes or updates POMO_AGGREGATED.md with breakdowns by year and product. The instructions also call for a subjective review of detection rates and sections on recurring patterns and conclusions. Image-generation scripts can be considered for charts.

One Post Mortem is not enough: the skill refuses to run with a single file, and suggests using more when given two or three. For external reports, it advises copying Markdown into a new local folder, with a warning that this could lose information. Detection and mitigation timestamps are optional fields in the extraction.

What it helps with

  • combine incident details from multiple Post Mortem files
  • calculate outage duration and detection time
  • compare incidents by year and product
  • identify recurring root-cause patterns
  • write findings to POMO_AGGREGATED.md

Example prompts for the agent

  • Review the Post Mortem files in incidents/ and update POMO_AGGREGATED.md.
  • Create pomo_stats.csv from these reports and break down incidents by year and product.
  • Look for repeated outage causes in postmortems/ and add the findings to the aggregated report.

How to install postmortem-aggregator

1Plugin marketplace

/plugin marketplace add gemini-cli-extensions/sre
/plugin install sre-extension@sre

This installs the whole sre-extension plugin with all its skills

2Skills CLI (Vercel)

npx skills add gemini-cli-extensions/sre --skill postmortem-aggregator -a claude-code

3Manually: put the files in place

~/.claude/skills/postmortem-aggregator/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/postmortem-aggregator/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about postmortem-aggregator

How do I install postmortem-aggregator in Claude Code?

Add the marketplace with /plugin marketplace add gemini-cli-extensions/sre, then install the skill with /plugin install sre-extension@sre.

What does postmortem-aggregator do?

It extracts incident details from Post Mortem files, creates pomo_stats.csv, and updates POMO_AGGREGATED.md with calculations and pattern analysis.

How many Post Mortem files does it need?

It refuses to run on a single report. With two or three reports, it suggests using a larger set.

Source text

SKILL.md · Apache-2.0
---
name: postmortem-aggregator
description: 🐉 To be used when you have a folder containing N Post Mortem files. This will help crunch data and maintain/update a POMO_AGGREGATED.md file.
metadata:
  author: Riccardo Carlesso
  version: 0.0.1
  status: draft
# CHANGELOG
#   10mar26 v0.0.1 Initial idea dump
# /CHANGELOG

# TODO -> refine this base idea
# The base idea is to do what I've done with numerous customers
# 1. Enforce a JSON/FrontMatter schema for the PostMortem, with at least date started, date ended, datetime detected, product area, and
# 2. This skill must have in input a folder with 3+ PoMos
# 3. => Crates a small graph / statistics of "How many bad minutes you had this year" and create a few graphs, and tables and document in a `pomo-statistics.md`
# TODO(ricc): ensure to patch the PoMo creator to also add a FrontMatter to make life easier here. Also add a PoMoGenerator version like 1.1 to be used later on. Damn I didn't envision cross-markdown-version-dependencies until today! :)
# TODO(ricc/Gemini): add scripts to create the CSV here, and also to create graphs with the numbers given. Script should be able to work on test data.
---

# Identify the PoMos

* If the pomos are local in a folder, use those.
* If they're external, create a new folder called `YYYYMMDD_POSTMORTEMS/` and copy their MD version there. This might lose information, but ensure the relevant info is transported here, locally. You could run the "postmortem generator" skill on a locally curled page.
* If there is ONE, refuse to run this.
* If there is 2-3, suggest the user it's worth using a plurality of these.

## Action

Check all the Post Mortems in the folder and identify these informations:

1. Timestamp of outage start.
1. Timestamp of outage identified by human and being worked on (if available).
1. Timestamp of first Mitigation going into place (if available)
1. Timestamp of outage end.
1. Product used (eg Cloud, Youtube). Products could have a taxonomy (eg `Cloud::GCE::PersistentDisk`, `Youtube::Playlists`)
1. RootCause class (HUMAN_ERROR, CONFIG_CHANGE, EXTERNAL_CAUSE, ..).
1. Outage size, how bad it was (TEST, NEGLIGIBLE, SMALL, MEDIUM, BIG, CATASTROPHIC).

Build a `pomo_stats.csv` with this data, one line per incident

```
filename,title,outage_start,outage_detected,outage_mitigated,outage_ended,root_cause,size
folder/20260101-millennium-bug.md,Millennium Bug hit us!,20260101-09:00:00,,,20260101-12:42:00,HUMAN_ERROR,NEGLIGIBLE
```

## Crunching the data

Once you have the CSV with raw data, you can write some simple code which does the following:

1. Decide what YOUR_DESIGNATED_FOLDER is.
1. Create or Update `POMO_AGGREGATED.md` under YOUR_DESIGNATED_FOLDER/.
1. Caculate for every incident:
   * `outage_duration` (end - start)
   * `time_to_detect` (detect - start)
   * `time_to_mitigate` (mitigate - detect).
   * `detection_rate` (ratio between time_to_detect / outage_duration ). This is indicative of how fast we're to OBSERVE an outage vs FIX it and tells us a lot about our organization.
1. Do an aggregation of all stats except detection_rate (its a percentage on varying numbers, so it's comparing watermellons to cherries).
1. Do a subjective analysis of the detection_rate.
1. Create breakdown by YEAR and PRODUCT.
1. Consider using image generation scripts to create simple graphs.

## Lessons learnt

* See recurring patterns and add a H2 paragraph on `## recurring patterns`: Is there anything we can learn from this aggregation? Is this a mistake we keep on doing? Is there a bug which looks like we're not prioritizing? Is there a number of bugs who all look like the same? This is the step where we can actually identify schemas in this plurality.
* Is there some other lesson we learn from this plurality? Write about it in the `## Conclusions`.

© Riccardo Carlesso · Apache-2.0 · gemini-cli-extensions/sre

Similar skills

All skills for DevOps and infrastructure →

From the same set17

The whole set →
gcp-playbooks gcp-playbooks is a Claude Code skill with SRE playbooks for investigating GCP incidents and running mitigations across GKE and Cloud Run. CX Codex +1 ★ 151repo stars pre-publish-checker pre-publish-checker audits project files for profanity, internal links, sensitive paths, and unfinished development markers. Use it when preparing code or an extension for public release. CX Codex +1 ★ 151repo stars safe-sre-investigator safe-sre-investigator creates dedicated read-only service accounts for GCP and Kubernetes, then hands you gcloud and kubectl commands with a risk rating attached. CX Codex +1 ★ 151repo stars cloud-monitoring Interacts with Google Cloud Monitoring through MCP, rendering ASCII sparklines and concise CSV summaries to prevent context bloat. CX Codex +1 ★ 151repo stars gcp-mcp-setup gcp-mcp-setup — a skill for Claude Code, Codex, and Gemini CLI that wires up Google Managed MCP servers (OneMCP) to your CLI environment. It enables APIs, generates an API key, and writes the MCP config to the right settings file. CX Codex +1 ★ 151repo stars generic-mitigations generic-mitigations guides your agent to halt production outages quickly using standard SRE strategies before diving into root-cause analysis. CX Codex +1 ★ 151repo stars monitoring-graphs monitoring-graphs — a skill for Claude Code, Codex and Gemini CLI that generates annotated incident graphs in Python. Use it to visualize outages, plot error spikes, or correlate metrics with incident milestones. CX Codex +1 ★ 151repo stars anomaly-detection anomaly-detection detects outliers in time-series metrics from CSV, cloud monitoring, and other sources. Chooses smoothing and algorithms automatically, or accepts your tuning parameters. CX Codex +1 ★ 151repo stars

Project sponsors

Companies that keep this analytics open