posthog
Query PostHog for product analytics, create insights, dashboards, and track AI referral traffic. Auto-activates when user asks about analytics, user behavior, funnels, retention, AI traffic, or dashboards. Trigger words: "check posthog", "create insight", "analytics", "user behavior", "AI traffic", "dashboard", "funnel", "retention"
Informações da origem
- Repositório
- BasedHardware/omi-landing
- Última atividade na origem
- 23 de janeiro de 2026 às 01:54
- Idioma detectado do SKILL.md
- inglês
- Estrelas
- 4
- Forks
- 5
Opções de instalação
Por padrão, está selecionado o prompt que primeiro revisa a origem. Você pode mudar para um comando direto ou baixar uma cópia local.
Revise os arquivos de origem
Leia o SKILL.md e os arquivos complementares exibidos pelo SkillsMP antes de decidir se vai instalar.
Exibindo SKILL.md
SKILL.md
Instruções da origem · Visualização somente leitura- name
- posthog
- description
- Query PostHog for product analytics, create insights, dashboards, and track AI referral traffic. Auto-activates when user asks about analytics, user behavior, funnels, retention, AI traffic, or dashboards. Trigger words: "check posthog", "create insight", "analytics", "user behavior", "AI traffic", "dashboard", "funnel", "retention"
# PostHog Analytics Skill
Query and manage PostHog product analytics for Mediar applications.
## Configuration
**Host:** `https://eu.i.posthog.com`
**Project Key (SDK):** `phc_NFSaZUao49XckpqaeyB3lIEKrFXhhXbKaI81jqZ8yn9`
**Personal API Key:** Required for API operations. Read `POSTHOG_API_KEY` from `.env.local`
### Getting a Personal API Key
1. Go to https://eu.posthog.com/settings/user-api-keys
2. Click "Create personal API key"
3. Name it (e.g., "claude-code")
4. Select scopes: `insight:read`, `insight:write`, `dashboard:read`, `dashboard:write`, `query:read`
5. Add to `.env.local`: `POSTHOG_API_KEY=phx_xxx...`
---
## PowerShell Queries (Windows)
Use PowerShell for all queries to avoid bash escaping issues.
### Get Project ID
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{ 'Authorization' = \"Bearer $token\" }
$response = Invoke-RestMethod -Uri 'https://eu.i.posthog.com/api/projects/' -Headers $headers
$response.results | ForEach-Object { Write-Host \"[$($_.id)] $($_.name)\" }
"
```
### List All Insights
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{ 'Authorization' = \"Bearer $token\" }
$projectId = 'YOUR_PROJECT_ID' # Get from above query
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/insights/?limit=20\" -Headers $headers
$response.results | ForEach-Object {
Write-Host \"[$($_.id)] $($_.name)\"
Write-Host \" Type: $($_.filters.insight) | Created: $($_.created_at)\"
}
"
```
### List All Dashboards
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{ 'Authorization' = \"Bearer $token\" }
$projectId = 'YOUR_PROJECT_ID'
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/dashboards/\" -Headers $headers
$response.results | ForEach-Object {
Write-Host \"[$($_.id)] $($_.name)\"
Write-Host \" Tiles: $($_.tiles.Count) | Created: $($_.created_at)\"
}
"
```
---
## Create Insights
### Create AI Referral Traffic Insight
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
name = 'AI Referral Traffic'
filters = @{
insight = 'TRENDS'
events = @(@{ id = '`$pageview'; type = 'events' })
properties = @{
type = 'OR'
values = @(
@{ key = '`$referrer'; value = 'chatgpt.com'; operator = 'icontains'; type = 'event' }
@{ key = '`$referrer'; value = 'claude.ai'; operator = 'icontains'; type = 'event' }
@{ key = '`$referrer'; value = 'perplexity.ai'; operator = 'icontains'; type = 'event' }
@{ key = '`$referrer'; value = 'gemini.google.com'; operator = 'icontains'; type = 'event' }
)
}
date_from = '-30d'
}
} | ConvertTo-Json -Depth 10
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/insights/\" -Method POST -Headers $headers -Body $body
Write-Host \"Created insight: $($response.id) - $($response.name)\"
"
```
### Create Pageviews by Page Insight
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
name = 'Top Pages'
filters = @{
insight = 'TRENDS'
events = @(@{ id = '`$pageview'; type = 'events' })
breakdown = '`$pathname'
breakdown_type = 'event'
date_from = '-7d'
}
} | ConvertTo-Json -Depth 10
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/insights/\" -Method POST -Headers $headers -Body $body
Write-Host \"Created insight: $($response.id) - $($response.name)\"
"
```
### Create User Funnel Insight
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
name = 'Signup Funnel'
filters = @{
insight = 'FUNNELS'
events = @(
@{ id = '`$pageview'; type = 'events'; name = 'Visit' }
@{ id = 'signup_started'; type = 'events'; name = 'Start Signup' }
@{ id = 'signup_completed'; type = 'events'; name = 'Complete Signup' }
)
date_from = '-30d'
}
} | ConvertTo-Json -Depth 10
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/insights/\" -Method POST -Headers $headers -Body $body
Write-Host \"Created funnel: $($response.id) - $($response.name)\"
"
```
---
## Dashboard Operations
### Create Dashboard
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
name = 'AI Traffic Dashboard'
description = 'Track traffic from AI assistants (ChatGPT, Claude, Perplexity)'
} | ConvertTo-Json
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/dashboards/\" -Method POST -Headers $headers -Body $body
Write-Host \"Created dashboard: $($response.id) - $($response.name)\"
"
```
### Add Insight to Dashboard
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$dashboardId = 'YOUR_DASHBOARD_ID'
$insightId = 'YOUR_INSIGHT_ID'
$body = @{
tiles = @(@{ insight = $insightId })
} | ConvertTo-Json -Depth 5
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/dashboards/$dashboardId/\" -Method PATCH -Headers $headers -Body $body
Write-Host \"Added insight to dashboard: $($response.name)\"
"
```
---
## Query Events (HogQL)
### Query Recent Events
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
query = @{
kind = 'HogQLQuery'
query = 'SELECT event, properties.`$referrer` as referrer, count() as count FROM events WHERE timestamp > now() - INTERVAL 7 DAY GROUP BY event, referrer ORDER BY count DESC LIMIT 20'
}
} | ConvertTo-Json -Depth 5
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/query/\" -Method POST -Headers $headers -Body $body
$response.results | ForEach-Object { Write-Host $_ }
"
```
### Query AI Bot Referrals
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
query = @{
kind = 'HogQLQuery'
query = @'
SELECT
CASE
WHEN properties.`$referrer` LIKE '%chatgpt%' OR properties.`$referrer` LIKE '%openai%' THEN 'ChatGPT'
WHEN properties.`$referrer` LIKE '%claude.ai%' THEN 'Claude'
WHEN properties.`$referrer` LIKE '%perplexity%' THEN 'Perplexity'
WHEN properties.`$referrer` LIKE '%gemini%' THEN 'Gemini'
ELSE 'Other AI'
END as ai_source,
count() as visits,
uniq(distinct_id) as unique_users
FROM events
WHERE event = '$pageview'
AND (
properties.`$referrer` LIKE '%chatgpt%'
OR properties.`$referrer` LIKE '%openai%'
OR properties.`$referrer` LIKE '%claude.ai%'
OR properties.`$referrer` LIKE '%perplexity%'
OR properties.`$referrer` LIKE '%gemini%'
)
AND timestamp > now() - INTERVAL 30 DAY
GROUP BY ai_source
ORDER BY visits DESC
'@
}
} | ConvertTo-Json -Depth 5
Ver no GitHubEste SKILL.md e muito grande, entao o SkillsMP mostra aqui apenas a primeira secao. Ver no GitHub
