adding-warehouse-perso…
Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data becomes usable anywhere person and group properties…
Connect a real Slack workspace to local PostHog Conversations (the SupportHog Slack app) so Slack messages become support tickets and replies post back. Use when the user wants to test the conversations Slack integration locally, hits "Support Slack OAuth client ID is not
$ npx -y skills add PostHog/ai-plugin --skill setting-up-support-slack-locally --agent claude-codeHow it fires
How this skill gets triggered: by you, by Claude, or both.
/setting-up-support-slack-locallyContext preview
The summary Claude sees to decide when to auto-load this skill.
Connect a real Slack workspace to local PostHog Conversations (the SupportHog Slack app) so Slack messages become support tickets and replies post back. Use when the user wants to test the conversations Slack integration locally, hits "Support Slack OAuth client ID is not
name: setting-up-support-slack-locally description: > Connect a real Slack workspace to local PostHog Conversations (the SupportHog Slack app) so Slack messages become support tickets and replies post back. Use when the user wants to test the conversations Slack integration locally, hits "Support Slack OAuth client ID is not configured", gets a white screen or "Network error" on the OAuth callback, or asks how to set SUPPORT_SLACK_APP_CLIENT_ID / a tunnel for supporthog Slack events. Covers the Slack app + scopes, the SUPPORT_SLACK_* dynamic settings, and the key split: localhost for OAuth and the UI, a public tunnel only for inbound events.
Slack is SaaS-only, so "local" means a throwaway Slack workspace + app whose OAuth and events reach your laptop. The job has one non-obvious idea that avoids almost every wall: **the OAuth connect and the event webhook have opposite reachability needs, so you point them at different places.**
No tunnel needed.
cloud. Slack cannot reach `localhost`, so this one needs a public tunnel.
Keep the whole app and the OAuth flow on `localhost`, and point only Event Subscriptions (and Interactivity) at the tunnel. This also sidesteps free-tier tunnel rate limits, since the tunnel then carries only Slack's low-volume event POSTs rather than the entire SPA.
This is the conversations/SupportHog variant of the general [Slack local setup guide](../../../../docs/internal/slack-local-setup-guide.md); that guide covers the PostHog Desktop / notifications Slack app (`SLACK_APP_*`, `/integrations/slack/callback`). Conversations uses its own `SUPPORT_SLACK_*` credentials and `/api/conversations/v1/slack/*` routes, but the tunnel and `SITE_URL` mechanics are identical.
All under `products/conversations/backend/api/urls.py`, prefixed `/api/conversations/`:
| Route | Purpose | Reachability | | ------------------------ | ------------------------------------------------------------- | ------------------------ | | `v1/slack/authorize` | returns the Slack OAuth URL (auth-gated) | browser (localhost) | | `v1/slack/callback` | OAuth redirect target; built from `SITE_URL`, no forced https | browser (localhost) | | `v1/slack/events` | inbound event webhook | Slack's servers (tunnel) | | `v1/slack/interactivity` | interactive component callbacks | Slack's servers (tunnel) |
The callback requires an authenticated session on whatever origin `SITE_URL` resolves to, because the session cookie is per-origin. Keep `SITE_URL` on `localhost` and log in there, and the callback keeps your session.
`SUPPORT_SLACK_APP_CLIENT_ID`, `SUPPORT_SLACK_APP_CLIENT_SECRET`, and `SUPPORT_SLACK_SIGNING_SECRET` are django-constance dynamic settings (`posthog/settings/dynamic_settings.py`) that default to the matching env var. Empty client id is what produces "Support Slack OAuth client ID is not configured". Put your Slack app's values in `.env.local` (gitignored) and restart the backend:
SUPPORT_SLACK_APP_CLIENT_ID=<client id> SUPPORT_SLACK_APP_CLIENT_SECRET=<client secret> SUPPORT_SLACK_SIGNING_SECRET=<signing secret>
Constance stores values in the DB, and a stored value overrides the env default. If it still reads as unconfigured after a restart, check `/admin/constance/config/` for a blank stored value and set it there instead.
At [api.slack.com/apps](https://api.slack.com/apps), create an app in a throwaway workspace, then:
1. **App Home** → enable a **bot user** (give it a display name). Without this, install fails with "requesting permission to install a bot ... but it's not currently configured with a bot". 2. **OAuth & Permissions → Bot Token Scopes** — the flow requests these (from `SUPPORTHOG_SLACK_SCOPES` in `products/conversations/backend/api/slack_oauth.py`): `channels:history`, `channels:read`, `chat:write`, `chat:write.customize`, `files:read`, `files:write`, `groups:history`, `groups:read`, `reactions:read`, `users:read`, `users:read.email`. Attachments need the two `files:` scopes in both directions, so a workspace installed without them shows a "reconnect" banner in support settings. 3. **OAuth & Permissions → Redirect URLs** — add `http://localhost:8010/api/conversations/v1/slack/callback` and Save. If Slack refuses a plain-http localhost URL, use the tunnel URL for the callback too and log in once on the tunnel origin (see [references/troubleshooting.md](references/troubleshooting.md)). 4. Copy the Client ID, Client Secret, and Signing Secret from Basic Information into `.env.local` (Step 1).
Run any HTTPS tunnel pointed at Caddy on **8010**, rewriting the upstream `Host` header to `localhost` (the dev Caddy only answers for the `localhost` host; without the rewrite you get an empty `200` and a white page):
ngrok http --host-header=localhost 8010 # or, free with no rate limit: cloudflared tunnel --url http://localhost:8010 --http-host-header localhost
Verify it reaches Django, not just Caddy:
curl -sS https://<tunnel-host>/_preflight | head -c 120 # want JSON, server: granian
Then in the Slack app set **Event Subscriptions → Request URL** (and **Interactivity → Request URL** if testing buttons) to `https://<tunnel-host>/api/conversations/v1/slack/events` (and `.../interactivity`). Slack sends a synchronous `url_verification` challenge on save, so the backend must be up; the handler echoes it back automatically.
The Request URL alone only passe
Official PostHog plugin for AI clients. Access PostHog products directly from your AI coding tool.
Repo: PostHog/ai-plugin
Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data becomes usable anywhere person and group properties…
Analyze the most expensive users in AI observability and explain why they cost so much. Use when the user asks about top spenders, expensive users, per-user…
Analyze session replay patterns across experiment variants to understand user behavior differences. Use when the user wants to see how users interact with…
Split a completed PostHog task run into activity records — what the agent tried, whether it worked, what blocked it — and record each one through the…
Assesses what a page's heatmap is telling you and recommends concrete changes. Pulls click / rageclick / scroll-depth data for a URL, names the hot elements by…
Audit every endpoint in a PostHog project for staleness, failed materialisations, and unused materialised versions. Use when the user asks "what endpoints can…