> Investigates distributed application performance using PostHog APM (OpenTelemetry span) data via MCP. Use when the user asks about service traces, slow HTTP/database spans, error spans, trace IDs, or span
npx skills add https://github.com/PostHog/skills --skill exploring-apm-traces
PostHog captures distributed traces from OpenTelemetry. Each trace is a tree of spans representing a request's path through services.
Disambiguation: This skill is for APM / OpenTelemetry traces. Do not confuse with AI observability traces (agent/model $ai_* events) or logs (posthog:query-logs, posthog:logs-*).
| Tool | Purpose |
| ----------------------------------- | ------------------------------------------------- |
| posthog:query-apm-spans | Search and filter spans (compact list view) |
| posthog:apm-trace-get | Get the full span list for one hex trace_id |
| posthog:apm-spans-aggregate | Per-operation aggregates (count, p50/p95, errors) |
| posthog:apm-spans-tree | Call-tree aggregates per (parent, child) edge |
| posthog:apm-services-list | List distinct service names |
| posthog:apm-attributes-list | List span or resource attribute keys |
| posthog:apm-attribute-values-list | List values for a specific attribute key |
See references/spans-and-fields.md for the response schema and the kind/status_code enums.
posthog:apm-trace-get
{
"trace_id": "<hex_trace_id>"
}
The response is { results: [span, span, …] } — a flat list of every span in the trace.
The list can be very large for fan-out request flows; when it exceeds the inline limit, Claude Code auto-persists it to a file.
From the result you get:
name, service_name, kind, status_code, parent_span_id, duration_nano, is_root_span_posthogUrl — always include this in your response so the user can click through to the UIWhen the result is persisted to a file (traces with hundreds of spans across services), use the parsing scripts to explore it.
Start with the summary to get the full picture, then drill into specifics:
# 1. Overview: services, span count, slowest spans, errors
python3 scripts/print_summary.py /path/to/persisted-file.json
# 2. Indented chronological tree (DFS by parent_span_id)
python3 scripts/print_timeline.py /path/to/persisted-file.json
# 3. Drill into a specific span by name
SPAN="HTTP GET /api/users" python3 scripts/extract_span.py /path/to/persisted-file.json
# 4. Search for a keyword across span names, services, IDs
SEARCH="keyword" python3 scripts/search_spans.py /path/to/persisted-file.json
# 5. When the JSON shape looks unfamiliar
python3 scripts/show_structure.py /path/to/persisted-file.json
All scripts support MAX_LEN=N env var to control truncation (0 = unlimited).
The flat span list is a tree. Each span carries:
trace_id — same on every span in the tracespan_id — this span's unique hex IDparent_span_id — points to the parent's span_id (zero-padded hex 000…000 for the root)is_root_span — convenience flag for the trace entryTo rebuild the tree:
is_root_span is true (or parent_span_id == "00000000…") are root spans.span_id matches its parent_span_id.parent_span_id, walk from each root downward.scripts/print_timeline.py does this for you and prints a DFS-indented tree.
print_summary.py — it surfaces the top-5 slowest spans by duration_nano.print_timeline.py and scan the indented durations — you can see whether time is dominated by one child span or fan-out across many.SPAN="<name>" python3 scripts/extract_span.py FILE.print_summary.py lists every span with status_code == 2 (Error). Each entry shows service, span name, and parent context.parent_span_id to see what request path led there.attributes map (e.g. exception.message, exception.type), which is returned in the trace payload — read it directly off the error span. apm-attribute-values-list is for discovering values across spans, not a prerequisite for reading one span's attributes.print_summary.py — it prints the set of services involved in the trace.apm-services-list to confirm X has emitted spans recently at all).print_timeline.py shows the indentation — wide trees mean parallel calls, deep trees mean sequential dependencies.Client (3) followed by matching Server (2) spans on the called service — that's a synchronous downstream call.http.method=POST)Each span carries an attributes map (span-level OTel attributes like http.method, db.statement) in the payload — so for a span you already have, just read it. Resource attributes (k8s labels, service.version) are not in the payload. To filter the whole dataset by an attribute:
apm-attributes-list / apm-attribute-values-list to discover keys and values (resource attributes especially).query-apm-spans with a filterGroup entry of type span_attribute or span_resource_attribute.apm-trace-get and query-apm-spans return _posthogUrl — always surface this to the user so they can verify in the PostHog UI.
When presenting findings, include the relevant PostHog URL.
Use posthog:query-apm-spans to search and filter spans. Note this returns spans, not a tree — pass query.traceId or grab a trace_id from the results and feed it to apm-trace-get for the tree.
Before constructing filters, discover what's actually in the project:
apm-services-list to see which services have emitted spans.apm-attributes-list with attribute_type: "span" or "resource".apm-attribute-values-list with a key to see the real values in use.Only then construct query-apm-spans filters. Custom attributes vary per project and cannot be guessed.
posthog:query-apm-spans
{
"query": {
"serviceNames": ["api-gateway"],
"dateRange": {"date_from": "-1h"},
"filterGroup": [
{"key": "http.status_code", "operator": "gt", "type": "span_attribute", "value": "499"}
]
}
}
posthog:apm-trace-get
{
"trace_id": "0123456789abcdef0123456789abcdef"
}
1_000_000_000. Filter values in query-apm-spans for duration are also nanoseconds.status_code == 2 is Error. 0 is Unset, 1 is OK. Use OK to match {0, 1} in the UI filter.kind is an integer 0–5: 0 Unspecified, 1 Internal, 2 Server, 3 Client, 4 Producer, 5 Consumer.parent_span_id of a root span is "0000000000000000" (16 zero hex chars, matching the 8-byte span ID width — _not_ the 16-byte trace ID width), not null.Trace tool results are JSON. When too large to read inline, Claude Code persists them to a file.
[{ "type": "text", "text": "{\"results\": [...], \"_posthogUrl\": \"...\"}" }]
Every script in scripts/ unwraps this envelope before parsing.
results (array of span dicts)
└── each span:
├── uuid, trace_id, span_id, parent_span_id (hex strings)
├── name, kind (int 0–5), service_name
├── status_code (int 0–2), is_root_span (bool)
├── timestamp, end_time (ISO 8601)
├── duration_nano (int, nanoseconds)
├── attributes (map of span-level OTel attributes, e.g. db.statement, http.url)
└── matched_filter (0/1 — 1 if this span matched the query-apm-spans filter, 0 if it
only shares a trace with a match; always present, only meaningful from query-apm-spans)
| Script | Purpose | Usage |
| -------------------------------------------------- | ---------------------------------------------------- | -------------------------------------------------- |
| print_summary.py | Trace metadata, services, slowest spans, errors | python3 scripts/print_summary.py FILE |
| print_timeline.py | DFS-indented tree from parent_span_id walk | python3 scripts/print_timeline.py FILE |
| extract_span.py | Full row + parent/children for spans matching a name | SPAN="name" python3 scripts/extract_span.py FILE |
| search_spans.py | Find a keyword across name, service_name, IDs | SEARCH="kw" python3 scripts/search_spans.py FILE |
| show_structure.py | Show JSON keys and types without values | python3 scripts/show_structure.py FILE |
dateRange on query-apm-spans — queries without a time range are slow. Default is -1h; widen only when needed._posthogUrl in your response so the user can click through.apm-trace-get / query-apm-spans payload (each span's attributes map). Resource attributes are not — use apm-attributes-list (type resource) and apm-attribute-values-list for those.is_root_span is the cheap way to find the trace entry — don't string-match 00000000….apm-spans-aggregate for a flat view or apm-spans-tree for parent→child edges — don't reach for SQL.Efficient database search tool for bioRxiv preprint server. Use this skill when searching for life sciences preprints by keywords, authors, date ranges, or categories, retrieving paper metadata, downloading PDFs, or conducting literature reviews.
Access BRENDA enzyme database via SOAP API. Retrieve kinetic parameters (Km, kcat), reaction equations, organism data, and substrate-specific enzyme information for biochemical research and metabolic pathway analysis.
Access ClinPGx pharmacogenomics data (successor to PharmGKB). Query gene-drug interactions, CPIC guidelines, allele functions, for precision medicine and genotype-guided dosing decisions.
Query NCBI ClinVar for variant clinical significance. Search by gene/position, interpret pathogenicity classifications, access via E-utilities API or FTP, annotate VCFs, for genomic medicine.
Access COSMIC cancer mutation database. Query somatic mutations, Cancer Gene Census, mutational signatures, gene fusions, for cancer research and precision oncology. Requires authentication.
Query Ensembl genome database REST API for 250+ species. Gene lookups, sequence retrieval, variant analysis, comparative genomics, orthologs, VEP predictions, for genomic research.
Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.
Query NCBI Gene via E-utilities/Datasets API. Search by symbol/ID, retrieve gene info (RefSeqs, GO, locations, phenotypes), batch lookups, for gene annotation and functional analysis.
Take posthog/exploring-apm-traces from the repository into ~/.claude/skills for personal
use, or into .claude/skills inside a project.
The agent identifies a skill by the name field in its header. Two skills with the
same name cannot sit side by side — one of them will be ignored.