Skip to main content
skill CX Codex

turning-engineering-analytics-into-insights — Claude Code skill

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.

no license 189 installs ★ 101 updated 2026-11-16

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add PostHog/ai-plugin --skill turning-engineering-analytics-into-insights -a claude-code
Open on GitHub

What turning-engineering-analytics-into-insights 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.

What it helps with

  • 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 for the agent

  • 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

How to install turning-engineering-analytics-into-insights

1Skills CLI (Vercel)

npx skills add PostHog/ai-plugin --skill turning-engineering-analytics-into-insights -a claude-code

2Manually: put the files in place

~/.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/

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

Questions about turning-engineering-analytics-into-insights

How to install turning-engineering-analytics-into-insights in Claude Code?

Run npx skills add PostHog/ai-plugin --skill turning-engineering-analytics-into-insights -a claude-code in your terminal.

What does turning-engineering-analytics-into-insights do?

It directs the agent to query GitHub warehouse tables with HogQL, format SQL insights properly, and organize them into PostHog dashboards or subscriptions.

What is required for turning-engineering-analytics-into-insights to work?

It requires synced GitHub workflow runs and jobs within PostHog warehouse storage alongside tools like engineering-analytics-sources and insight-create.

Similar skills

All skills for DevOps and infrastructure →

From the same set82

The whole set →
signals-scout-mcp-tool-calls signals-scout-mcp-tool-calls — a PostHog Signals skill that sifts $mcp_tool_call telemetry for MCP tools agents struggle with, then files one report per product category. CX Codex +1 194installs signals-scout-web-vitals signals-scout-web-vitals tracks page p75 LCP, INP, CLS, and FCP from PostHog events, spots performance degradation against Google thresholds, and links regressions to deploys. CX Codex +1 194installs signals-scout-skills-store signals-scout-skills-store audits shared PostHog agent skills for vague descriptions, oversized bodies, broken links, and leaked secrets. Produces reports with copy-ready fixes. CX Codex +1 193installs analyzing-expensive-users analyzing-expensive-users — a skill for Claude Code, Codex, Cursor and other agents that finds the top spenders in PostHog AI observability and explains what drives their costs. CX Codex +1 192installs investigating-logs The investigating-logs Claude Code skill investigates logs in a PostHog project, checks service health and traces error spikes. It runs for deploy checks, incident triage, change analysis, or a search around one trace or run. CX Codex +1 188installs investigating-ci-failures The investigating-ci-failures Claude Code skill traces an individual CI failure to its likely cause. It separates PR-specific problems from default-branch breaks and flaky tests. CX Codex +1 188installs review-hog-validation-criteria review-hog-validation-criteria serves as a final PR review gate, filtering candidate findings to keep real defects while discarding speculative noise. CX Codex +1 187installs review-hog-blind-spots-general The review-hog-blind-spots-general skill looks for concrete problems that earlier reviewers missed in a PR chunk. Use it as a final pass after other review perspectives have reported their findings. CX Codex +1 187installs

Project sponsors

Companies that keep this analytics open