# turning-engineering-analytics-into-insights

turning-engineering-analytics-into-insights — a skill for Claude Code and Codex: converts PR and CI metrics into saved PostHog insights, dashboards, and automated subscriptions. Triggers when visualizing engineering team performance.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 189 installs · ★ 101 repo stars
- Author: PostHog
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/PostHog/ai-plugin/tree/HEAD/skills/turning-engineering-analytics-into-insights/SKILL.md
- Updated: 2026-11-16
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/turning-engineering-analytics-into-insights

## What it does

This skill guides the assistant in transforming repository and pipeline records into persistent PostHog charts via HogQL. Because MCP tool responses cannot be directly converted into saved insights, the workflow locates relevant warehouse tables using `engineering-analytics-sources`, tests the SQL via `execute-sql`, and registers the result through `insight-create`.

Queries respect PostHog data conventions. Timestamps arrive as strings requiring `parseDateTimeBestEffort`, nullable JSON fields require `ifNull`, and PR associations rely on run metadata instead of head SHA joins. Pre-built views like `engineering_analytics_job_costs` cover runner expenses, including runs processed by Depot CI.

Standard threshold alerts in PostHog only function with trend insights rather than SQL charts, so automated checks require scheduled deliveries or AI subscriptions. Specialized metrics such as flaky test rankings belong exclusively to dedicated MCP tools and must not be reconstructed manually in HogQL.

## Requirements
- Works with: GitHub

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill turning-engineering-analytics-into-insights -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/turning-engineering-analytics-into-insights/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/turning-engineering-analytics-into-insights/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill turning-engineering-analytics-into-insights -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/turning-engineering-analytics-into-insights/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill turning-engineering-analytics-into-insights -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/turning-engineering-analytics-into-insights/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install PostHog/ai-plugin skills/turning-engineering-analytics-into-insights
```

2. **Manually: put the files in place**
- File: `.github/skills/turning-engineering-analytics-into-insights/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill turning-engineering-analytics-into-insights -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/PostHog/ai-plugin --path skills/turning-engineering-analytics-into-insights
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/turning-engineering-analytics-into-insights/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill turning-engineering-analytics-into-insights -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/PostHog/ai-plugin/tree/HEAD/skills/turning-engineering-analytics-into-insights/SKILL.md

## When to use it
- Build a dashboard tracking PR review times and merge durations
- Schedule weekly email updates for team pull request throughput
- Construct validated HogQL queries against GitHub warehouse sources
- Save custom charts tracking pytest failure signatures over recent runs

## Example prompts
- Put CI health and merge times on a new dashboard
- Save this pull request throughput metric as an insight
- Set up a weekly subscription for CI job costs

## Similar
- [querying-posthog-data](https://affpapa.org/en/nevibecode/skills/querying-posthog-data.md) — skill · 890 installs
- [analyzing-experiment-session-replays](https://affpapa.org/en/nevibecode/skills/analyzing-experiment-session-replays.md) — skill · 463 installs
- [seo-posthog](https://affpapa.org/en/nevibecode/skills/seo-posthog.md) — skill · 141 installs
- [posthog-webhooks-events](https://affpapa.org/en/nevibecode/skills/posthog-webhooks-events.md) — skill · 1 install
- [posthog](https://affpapa.org/en/nevibecode/skills/posthog.md) — skill · ★ 8052 repo stars
- [infrastructure-cicd-data-engineering](https://affpapa.org/en/nevibecode/skills/infrastructure-cicd-data-engineering.md) — skill · 1600 installs

From the same set: [posthog/ai-plugin](https://affpapa.org/en/nevibecode/by/posthog/ai-plugin.md) — 82 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
