dataops-postmortem-generator

What problem does it solve?

This Skill helps you produce consistent, blameless DataOps postmortems after data platform incidents, including severity assessment, timelines, quantified impact, CAPA action items, and stakeholder-ready communications.

Core Features & Use Cases

• Severity (SEV1–SEV4) decision support: Maps incident conditions to an appropriate response level and postmortem expectation.
• Production-ready postmortem content: Provides a Markdown template covering summary, impact, timeline (UTC), root cause, contributing factors, and CAPA action items.
• Incident examples and practical artifacts: Includes filled-in example postmortems (Kafka rebalance, dbt incremental data loss, ClickHouse schema mutation), impact-quantification SQL patterns, a 60-minute facilitation agenda, and a filing/review checklist.
• Stakeholder communication templates: Supplies initial and resolution email templates tailored to SEV1 scenarios.

Quick Start

Ask the agent to draft a SEV2 blameless postmortem for an incident affecting the gold.fact_orders dataset, using the provided template and including a UTC timeline, root cause section, CAPA action items, and an impact-quantification SQL snippet.