Codex Suneido Queries for Grouped Totals
Draft grouped gSuneido queries and give aggregation results explicit column names that can be checked against sample records.
中文Install in Codex
Use a Suneido query environment or test project with confirmed column names. The example uses temporary fixture data.
- Review `.agents/skills/suneido-database/SKILL.md` and its requirements at the pinned GitHub commit.
- Create `.agents/skills/suneido-database/` in your project and save the reviewed file as `.agents/skills/suneido-database/SKILL.md`.
- Start Codex from that project's root, then type `$suneido-database` and select the matching skill.
Example task
Write a grouped totals query for this example inventory.
{"table":"stock","group":"zone","column":"units","rows":[["east",2],["east",5],["west",3]]}What to check
Draft `stock summarize zone, zone_units = total units`. The supplied records produce `east=7` and `west=3`.
Original SKILL.md on GitHub · Updated
Frequently asked question
What column name does Suneido use without an alias?
It combines the aggregation function name and source column. In this case the default is total_units.