generate-sql
Installation
SKILL.md
Key Input Parameters
- project_id:
- The project ID to query, obtained from context. If not found, ask the user. Do not guess or randomly generate
- By default, only one project's query SQL can be generated at a time. If multiple project IDs need to be queried, generate and execute them one by one
- $part_date:
- The date range to query, limiting the query scope based on date partitions
- If querying data for the date range from 2026-01-01 to 2026-01-07, the generated filter condition fragment example is: "$part_date" between '2026-01-01' and '2026-01-07'
- Only required for
- $part_event:
- The event range to query. Confirm valid event names by combining context or using
ae-cli analysis-meta event list. Do not guess or randomly generate - If querying a single event 'register', the filter condition fragment example is: "$part_event" in ('register')
- If querying multiple events like 'login' and 'logout', the filter condition fragment example is: "$part_event" in ('login', 'logout')
- Only required for
- The event range to query. Confirm valid event names by combining context or using