CtrlK
BlogDocsLog inGet started
Tessl Logo

analyzing-insights-across-teams

Analyze PostHog insights, dashboards, or teams beyond the current project by querying the prod Postgres replicas synced into the dogfood data warehouse (US project 2, "PostHog App + Website"). Use when asked to analyze insights across all teams or projects, another team's insights, or fleet-wide insight/dashboard usage — cases where `system.insights` only returns the current project's rows and the agent would otherwise report the data as inaccessible. Covers the synced table names for US and EU and the column-verification workflow.

73

Quality

90%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

—

The risk profile of this skill

SKILL.md
Quality
Evals
Security

Quality

Content

93%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A tight, highly actionable skill body with executable SQL, clear sequencing, and strong output-handling guardrails. The only gap is the absence of an explicit validate-fix-retry loop, which caps workflow clarity at 4.

DimensionReasoningScore

Conciseness

Lean and efficient: it limits prose to non-obvious internal setup (dogfood replication, repo-locality constraint) and provides tight executable SQL, assuming Claude's competence with no concept padding, matching the 5 anchor.

5 / 5

Actionability

Provides fully executable, copy-paste-ready SQL for catalog discovery, column verification, and a worked insights-by-team query with real table and column names (team_id, deleted, saved, created_at), matching the 5 anchor.

5 / 5

Workflow Clarity

A clear three-step sequence with an explicit column-verification checkpoint and a permission-error stop condition; it lacks a validate-fix-retry feedback loop for these database operations, so it sits at 4 rather than 5.

4 / 5

Progressive Disclosure

No bundle files exist and none are needed; the single-purpose skill is organized into clear, navigable sections (Synced tables, Workflow, Output handling, Related) with one well-signaled related-skill pointer, fitting the 5 anchor for simple well-organized skills.

5 / 5

Total

19

/

20

Passed

Description

87%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong, specific description that clearly states both capability and trigger conditions for a well-scoped internal niche. It loses a point only on specificity and trigger-term breadth, where a few more synonyms/actions would reach full coverage.

DimensionReasoningScore

Specificity

Names the domain and several concrete actions — 'Analyze PostHog insights, dashboards, or teams beyond the current project by querying the prod Postgres replicas' and 'Covers the synced table names for US and EU and the column-verification workflow' — with only minor coverage gaps, so it sits above 3 but below the fully comprehensive 5 anchor.

4 / 5

Completeness

Explicitly answers both what ('Analyze PostHog insights... by querying the prod Postgres replicas synced into the dogfood data warehouse') and when ('Use when asked to analyze insights across all teams or projects, another team's insights, or fleet-wide insight/dashboard usage') with concrete trigger phrases, matching the 5 anchor.

5 / 5

Trigger Term Quality

Includes natural phrases a user would say ('analyze insights across all teams or projects', 'another team's insights', 'fleet-wide insight/dashboard usage') with good coverage, missing only a few synonyms/extensions, fitting the 4 anchor rather than the comprehensive 5.

4 / 5

Distinctiveness Conflict Risk

Occupies a clear niche (cross-team PostHog dogfood-warehouse analysis) with distinct triggers and an explicit fallback condition ('cases where system.insights only returns the current project's rows'), giving minimal conflict risk as in the 5 anchor.

5 / 5

Total

18

/

20

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
PostHog/posthog
Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.