PostHog API
Build long-term product analytics with full event history
Pull events, persons, and feature flag data from the PostHog API. Track funnel conversion, retention cohorts, and feature adoption without PostHog's query limits.
Free up to 1M events/month. API access on all plans.
How it works with Loony
Describe it.
Deploy it.
Query it.
Managed database.
Your PostHog data lives in its own Postgres instance. Zero config. Data accumulates over time.
Scheduled syncs.
Cron jobs run on Loony infra. Hourly on free. Your data stays fresh without you thinking about it.
REST + MCP endpoints.
Query from your agent, your dashboard, or connect BI tools directly. Full OpenAPI spec included.
$ "Pull PostHog events for signup, activation, and purchase from the last 6 months. Build weekly cohort retention and funnel conversion rates." ✓ Schema validated ✓ Database provisioned ✓ Scripts deployed ✓ Schedules registered Done. # Your data is now at: REST /data/v1/posthog/query MCP /mcp/v1/posthog/mcp SQL psql $DATABASE_URL
What you get
PostHog is great for real-time product analytics but querying historical data gets slow. Loony syncs your events and persons into Postgres on a schedule so your agent can answer 'What was the signup-to-activation rate by cohort for the last 6 months?' with fast, reliable queries.
mv_weekly_funnel week date -- cohort week signups integer -- new signups activated integer -- completed onboarding converted integer -- made first purchase activation_rate numeric -- activated / signups conversion_rate numeric -- converted / signups median_days numeric -- days signup to purchase
Even better together
Join PostHog product events with Stripe revenue to see which user behaviours predict higher LTV. Add Google Analytics to connect acquisition channels to in-product activation.
