تخطَّ إلى المحتوى
TakoAPI
العودة إلى المهارات

posthog-query

بواسطة quinlanjager

Marketing & Sales
—لم يُقيَّم بعد
تقييمك

موجز

Run SQL queries against PostHog product analytics data using the PostHog CLI.

الوصف

ما الذي تفعله هذه المهارة

Runs HogQL (ClickHouse-compatible SQL) queries against PostHog product analytics data via the CLI. Returns results as JSON lines to stdout. Supports filtering by event type, URL, timestamp, and any stored event properties.

Queries analytics data from the terminal without opening the PostHog dashboard, making it straightforward to pipe results into scripts or agents.

متى تستخدمها

  • Count pageviews for a specific URL over the past week
  • Check which browsers users are on for a given event
  • Pull the 10 most recent events from your PostHog project
  • Track daily signups or feature-click trends over a date range
  • Audit event volume around a product change or deploy

مثال على سير العمل

الإدخال

User asks: How many pageviews did we get per day over the last 7 days?

الوكيل
  1. 1

    Authenticate with PostHog using posthog-cli login

  2. 2

    Construct a HogQL query grouping pageview events by date over the last 7 days

  3. 3

    Run the query with posthog-cli exp query run

  4. 4

    Parse the JSON lines output and format the daily counts

الإخراج

A list of dates with corresponding pageview counts, e.g. {"date": "2026-03-11", "pageviews": 4821}

المتطلبات

  • PostHog account
  • PostHog API key with query:read scope
  • posthog-cli installed globally via npm install -g posthog-cli

التثبيت

clawhub install quinlanjager/posthog-query

شغّل أمر واجهة سطر الأوامر، أو الصق النص في Claude Code أو Cursor أو Codex أو أي وكيل برمجة تستخدمه.

الروابط