PostHog / posthog

🦔 PostHog provides open-source web & product analytics, session recording, feature flagging and A/B testing that you can self-host. Get started - free.
https://posthog.com
Other
22.34k stars 1.35k forks source link

Gen AI for HogQL #26368

Open joshpxyne opened 1 week ago

joshpxyne commented 1 week ago

Feature request

Is your feature request related to a problem?

It's unclear to new / infrequent users how to properly use HogQL. Can onboard if technical, but easier solution would be to have a prompt-to-hogQL solution.

Describe the solution you'd like

I'd like a prompt-to-hogQL feature (similar to https://clickhouse.com/blog/announcing-genai-powered-query-suggestions-clickhouse-cloud).

Describe alternatives you've considered

Using Claude to prompt HogQL doesn't work properly.

Additional context

Debug info

Location: https://us.posthog.com/project/93221/settings/project-surveys
Session: https://us.posthog.com/project/sTMFPsFhdP1Ssg/replay/01935d55-7a8e-7b07-9222-a087fe83f67d?t=1188
Admin: http://go/adminOrgUS/0192267c-8e16-0000-f05b-5a225eca46ba (project ID 93221)
Sentry: http://go/sentryUS/93221