Does this skill automatically delete my endpoints?

No, the skill is read-only by default. It produces a prioritized report and will only modify or disable endpoints after you provide explicit confirmation.

How does it determine if an endpoint is unused?

It queries the system query_log for personal API key requests and checks the last_executed_at timestamp to see if the endpoint has been called within the last 30 days.

Does it track usage from the PostHog web application?

No, usage tracking is limited to personal API key calls. Runs from the PostHog Playground or within the app dashboard are not counted, so always confirm before disabling an endpoint.

Can it help fix failing materializations?

The audit identifies which materializations are failing and surfaces the error. For deep investigation and fixing, it hands off to the 'diagnosing-endpoint-performance' skill.

PostHog Endpoint Auditor - Claude Code Skill

Name: PostHog Endpoint Auditor
Author: PostHog

The PostHog Endpoint Auditor skill provides a comprehensive diagnostic overview of all endpoints within a PostHog project. It helps developers and data engineers maintain high-performance data pipelines by identifying unused endpoints, tracking call frequency via API keys, and detecting failing materializations. The skill generates prioritized reports categorized by issue severity, allowing users to clean up technical debt and reduce materialization costs while ensuring no destructive changes are made without explicit confirmation.

Key Features

01Identifies stale endpoints unused for over 30 days

02Finds unused materialized versions to reduce storage and compute costs

03Provides prioritized reports grouped by issue type (Stale, Inactive, Failing)

0459 GitHub stars

05Detects failed materializations with specific error logs

06Integrates usage metrics directly from SQL system tables and query logs

Use Cases

01Identifying and disabling abandoned endpoints after product migrations

02Performing periodic maintenance to reduce PostHog materialization costs

03Auditing inherited projects to understand endpoint sprawl and infrastructure

Tieline — product intent grounded in code

PostHog Endpoint Auditor

Key Features

Use Cases

Energy Procurement Specialist

ECC Tools Cost Audit

Energy Procurement & Strategy

Key Features

Use Cases