Guides you through transforming HogQL queries and PostHog insights into high-performance, callable API endpoints. It helps you make critical architectural decisions upfront—such as query kind selection, variable mapping, cache freshness settings (`data_freshness_seconds`), and view materialization—ensuring low latency, cost efficiency, and clean external integration while avoiding common pitfalls like unbounded date ranges or improper query materialization.
主要功能
01Step-by-step HogQL and insight-to-API endpoint configuration
02Dynamic variable mapping and parameter validation with safe defaults
03Cache TTL and data freshness optimization via data_freshness_seconds
04Materialization readiness checks and latency vs. staleness guidance
05Version pinning and URL-safe naming convention enforcement
0672 GitHub stars
使用场景
01Converting complex HogQL aggregations into reusable, cached API routes
02Exposing PostHog product analytics to client apps and external partner dashboards
03Optimizing query performance and reducing warehouse compute through endpoint materialization