sql-generation

You can generate ready-to-run PostgreSQL SQL queries for retention cohorts and funnels by providing natural language product analytics questions. The skill converts your questions into CTE-based templates with JSON property handling and placeholder substitution for your event-table schema.

Yes, the skill generates PostgreSQL-compatible SQL specifically for event-based analytics schemas exported from tools like Segment, Amplitude, or Mixpanel. It handles JSON properties and event-table structures typical of these platforms to produce valid queries.

To calculate weekly active users and churn detection, you provide the metric and your event names. The skill generates annotated, CTE-based PostgreSQL queries with placeholder substitution and segment filtering, along with suggested validation checks for your results.

Yes, the generated SQL includes simple validation checks for assumptions and suggests sanity checks for your results. This ensures the queries for metrics like activation funnels and feature adoption are reliable before you run them against your warehouse.

The best way to convert a product analytics question into SQL is to specify the metric, event name, and table. The skill then applies schema guidance, replaces placeholders with real event names, adds explanatory comments, and outputs a validated PostgreSQL query.