Skip to content

culiops/culiops-skills / skills/sre-investigate

sre-investigate

Unverified

FileKindSize
SKILL.mdskill md71.5 KB
access/standalone.mdmarkdown19.0 KB
agents/evidence.mdmarkdown8.1 KB
agents/helper.mdmarkdown3.9 KB
analytics/bin/logs-fetchexecutablescript229 B
analytics/bin/logs-inventoryexecutablescript209 B
analytics/bin/logs-statusexecutablescript192 B
analytics/bin/sqlqexecutablescript212 B
analytics/lib/s3logs/__init__.pyscript62 B
analytics/lib/s3logs/awscli.pyscript10.0 KB
analytics/lib/s3logs/budget.pyscript9.6 KB
analytics/lib/s3logs/cli_fetch.pyscript34.0 KB
analytics/lib/s3logs/cli_inventory.pyscript7.0 KB
analytics/lib/s3logs/cli_sqlq.pyscript18.4 KB
analytics/lib/s3logs/cli_status.pyscript3.0 KB
analytics/lib/s3logs/config.pyscript7.4 KB
analytics/lib/s3logs/convert.pyscript23.6 KB
analytics/lib/s3logs/duck.pyscript11.4 KB
analytics/lib/s3logs/layout.pyscript8.8 KB
analytics/lib/s3logs/paths.pyscript4.9 KB
analytics/lib/s3logs/redact.pyscript22.1 KB
analytics/lib/s3logs/s5.pyscript9.1 KB
analytics/lib/s3logs/sqlguard.pyscript11.8 KB
analytics/lib/s3logs/validate.pyscript4.4 KB
analytics/logs.env.exampleother4.2 KB
analytics/sql/alb/by_minute.sqlother918 B
analytics/sql/alb/lb_vs_target_status.sqlother629 B
analytics/sql/alb/status_by_target.sqlother887 B
analytics/sql/alb/summary.sqlother1.2 KB
analytics/sql/alb/target_latency_pct.sqlother1.4 KB
analytics/sql/alb/top_clients.sqlother429 B
analytics/sql/alb/top_paths_5xx.sqlother673 B
analytics/sql/cloudfront/aborted.sqlother1.1 KB
analytics/sql/cloudfront/by_day.sqlother499 B
analytics/sql/cloudfront/by_hour.sqlother489 B
analytics/sql/cloudfront/by_object.sqlother544 B
analytics/sql/cloudfront/bytes_per_viewer.sqlother1.1 KB
analytics/sql/cloudfront/cache_results.sqlother823 B
analytics/sql/cloudfront/client_concentration.sqlother707 B
analytics/sql/cloudfront/edges.sqlother434 B
analytics/sql/cloudfront/object_by_day.sqlother599 B
analytics/sql/cloudfront/range_requests.sqlother528 B
analytics/sql/cloudfront/referer_pages.sqlother393 B
analytics/sql/cloudfront/status_codes.sqlother342 B
analytics/sql/cloudfront/summary.sqlother719 B
analytics/sql/cloudfront/top_clients.sqlother353 B
analytics/sql/cloudfront/top_objects.sqlother349 B
analytics/sql/cloudfront/top_referers.sqlother492 B
analytics/sql/cloudfront/user_agents.sqlother533 B
analytics/sql/waf/asns.sqlother378 B
analytics/sql/waf/by_day.sqlother453 B
analytics/sql/waf/by_minute.sqlother314 B
analytics/sql/waf/client_keys.sqlother443 B
analytics/sql/waf/clients.sqlother521 B
analytics/sql/waf/compare_days.sqlother924 B
analytics/sql/waf/concentration.sqlother775 B
analytics/sql/waf/count_rules.sqlother556 B
analytics/sql/waf/countries.sqlother373 B
analytics/sql/waf/fingerprints.sqlother424 B
analytics/sql/waf/header_shape.sqlother425 B
analytics/sql/waf/labels.sqlother347 B
analytics/sql/waf/matched_data.sqlother530 B
analytics/sql/waf/rules_by_minute.sqlother497 B
analytics/sql/waf/summary.sqlother735 B
analytics/sql/waf/top_rules.sqlother361 B
analytics/sql/waf/uris.sqlother402 B
analytics/sql/waf/user_agents.sqlother557 B
analytics/tests/conftest.pyscript4.7 KB
analytics/tests/gen_fixtures.pyscript19.7 KB
analytics/tests/stubs/awsexecutablescript4.9 KB
analytics/tests/stubs/s5cmdexecutablescript4.5 KB
analytics/tests/test_awscli.pyscript16.0 KB
analytics/tests/test_budget.pyscript13.3 KB
analytics/tests/test_config.pyscript9.1 KB
analytics/tests/test_convert.pyscript25.9 KB
analytics/tests/test_duck.pyscript10.6 KB
analytics/tests/test_fetch.pyscript42.8 KB
analytics/tests/test_gen_fixtures.pyscript1.9 KB
analytics/tests/test_inventory.pyscript12.9 KB
analytics/tests/test_layout.pyscript9.8 KB
analytics/tests/test_named_queries.pyscript26.7 KB
analytics/tests/test_paths.pyscript3.2 KB
analytics/tests/test_redact.pyscript32.0 KB
analytics/tests/test_s5.pyscript17.8 KB
analytics/tests/test_sqlguard.pyscript10.8 KB
analytics/tests/test_sqlq.pyscript37.2 KB
analytics/tests/test_status.pyscript5.8 KB
analytics/tests/test_validate.pyscript2.9 KB
environment.template.mdmarkdown7.1 KB
playbooks/changes.mdmarkdown37.2 KB
playbooks/errors.mdmarkdown10.4 KB
playbooks/external.mdmarkdown15.4 KB
playbooks/infra-state.mdmarkdown13.7 KB
playbooks/logs-s3.mdmarkdown29.5 KB
playbooks/logs.mdmarkdown21.3 KB
playbooks/metrics.mdmarkdown39.0 KB
playbooks/other-backends.mdmarkdown7.2 KB
playbooks/traces.mdmarkdown16.2 KB
playbooks/waf.mdmarkdown17.2 KB
templates/incident.mdmarkdown3.9 KB
templates/ledger.mdmarkdown9.7 KB
templates/lesson.mdmarkdown2.7 KB
templates/profile.mdmarkdown4.5 KB
templates/report.mdmarkdown6.5 KB

templates/report.md

View on GitHub
# Investigation: <service> <env>: <one-line symptom>

The report is the reader-facing result of one run. It lives at `<output root>/runs/<service>-<env>-<YYYYMMDD-HHMM>/report.md`. Everything in it comes from the ledger; if a statement has no query ID or code reference behind it, it is `Assumed` and says so.

How to fill it in:

- Local time appears beside UTC (UTC first) for the incident window, the onset and every Timeline row, in the zone from `environment.md` or the one the user gave; everywhere else UTC alone is fine. If no zone is known, ask; do not guess. Use two columns, or `HH:MM UTC (HH:MM local)`.
- Labels are `Confirmed`, `Likely`, `Assumed` and `Ruled out`. A cause is never labelled more strongly than its weakest causal link, and the TL;DR names that link.
- Fast mode writes the TL;DR first (also printed inline), then Impact, Causal chain, Gaps, To confirm, Follow-ups and Cost. Deep mode fills every section.
- The run changed nothing it investigated. Wherever a mutation would be needed, describe it in prose. Never paste a runnable command that changes state into `## To confirm, a human would…` or `## Follow-ups`. Only `## Gaps` may carry a command, and only a read-only one or a re-auth step the user runs themselves (see there). `## To confirm, a human would…` and `## Follow-ups` are prose only.
- Delete the guidance lines when you copy the file; keep the headings exactly as written.

Run: <run directory name> · Mode: <Fast | Deep> · Window: <incident window in UTC> (<same window in local zone>) · Onset: <UTC> (<local>)
Access: <profile or context>: <write-check result in the check's own words, copied from the ledger's Access table: "write-capable: <action>, <action> allowed", "write-capable: <verb> on <resource>, <verb> on <resource>" (Kubernetes), "read-only confirmed (simulation): none of the 10 broad write actions is allowed", "partly checked (gap): no listed action is allowed, but <action>, <action> returned no usable result", "no write verbs in <namespace>" or "write capability unknown (gap)">, one entry per profile and context

## TL;DR

| Field | Value |
|---|---|
| Cause | <one sentence> · label: <label> |
| Weakest link | <the least certain step of the causal chain and its label; this caps the cause's label> |
| Impact | <who or what, for how long, current status> |
| Severity | <suggested level> because <criterion met>. The incident owner decides. |
| Pattern | <scheduled, chronic, recurring, sudden or unclassified> · <basis> · <label> |
| Recommended action | <what a human should do first, in prose> |
| Time to cause | <minutes from start to the first Likely, and to Confirmed if reached> |
| Similar past incidents | <files from `incidents/` that matched, or "none", or "no history yet"> |

If a similar incident has happened before, say which occurrence this is and over what period, and make a permanent fix the first follow-up.

## Impact

<Symptom, affected population or flows, start and end, how it was measured (SLO burn, request metrics against baseline, or Assumed), and the third party in the path if there is one, with the route to contact it. Cite query IDs.>

## Recurrence

| Source | Window | Occurrences | When (UTC) | Normal vs incident |
|---|---|---|---|---|
| <trigger alarm> | 30d | <count> | <times> | <not applicable> |
| <sibling alarms> | 30d | <count> | <times> | <not applicable> |
| <signal> | 14d at 1h | <hours above normal> | <times> | <median/p95/max vs incident value> |

A recurring pattern names its count in the follow-ups. A chronic one adds an alert-tuning item.

## Timeline

| Time (UTC) | Time (local) | Event | Evidence |
|---|---|---|---|
| <UTC> | <local> | <change, signal, alarm or mitigation> | <query ID and deeplink for a human> |

## Causal chain

Trigger, then mechanism, then symptom. One line per step, each with its label and the query ID that supports it.

1. Trigger: <what started it> · <label> · <query IDs>
2. Mechanism: <how the trigger produced the failure> · <label> · <query IDs>
3. Symptom: <what users or callers saw> · <label> · <query IDs>

Deep mode adds why it became an incident: <what delayed detection, which limit or protection was missing, which capacity was short>. If several explanations are still standing, list them all in rank order and do not pick one for the sake of sounding decisive.

## Evidence

One entry per claim in the chain: what was observed, at what time and scope, the query ID, and a deeplink a human can open. Do not paste more than a few log lines; cut each to 300 characters and remove secrets.

## Ruled out

| Hypothesis | Why | Query |
|---|---|---|
| <statement> | <what the data showed instead> | <query ID> |

## Open hypotheses

| Hypothesis | Label | What would settle it |
|---|---|---|
| <statement> | <Likely or Assumed> | <the query or data that is missing, and why it could not be run> |

## Gaps

| Gap | Impact on claims | How a human could fill it |
|---|---|---|
| <source not read> | <which statements it weakens> | <a variable name, a person to ask, or a re-auth step the user runs themselves, written exactly as `! aws sso login --profile <p>` (a login is not a change to an investigated system)> |

The last column never holds a command that changes an investigated system. Open items that need the user go in the run's `Next:` line (SKILL.md Phase 6), not at the end of the printed summary.

## To confirm, a human would…

A numbered list of checks the run could not do because they would touch the system (reproducing the failure, calling an endpoint, opening a database session, looking at a vendor console, asking a vendor). The run never opens a database session; read-only database queries it handed to the operator and whose results came back are evidence, marked `operator-supplied`, not items here. Describe each check in prose with what result would confirm or refute the cause. The investigation runs none of these; a check that would change state is described in prose for its owner, never as a command to paste.

1. <…>

## Follow-ups

Prose only, and never a runnable command that changes state. A new session with the right tool and approvals does any change.

| Kind | Item |
|---|---|
| Fix | <what should change to remove the cause> |
| Prevention | <the alert, limit, test or rollout step that would have stopped or shortened this> |
| Observability gap | <the signal that was missing or too coarse> |

## Cost

<data queries run> queries (plus <n> free control-plane reads) · <log GB scanned> GB of logs · <CloudWatch metric requests> metric requests · <other metered units> · about <amount> in metered charges

This line is last in the report and is always printed.
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 196kUpdated Claude CodeCodexVerifiedInstall