Menu
Procedure for importing fixture rows and computing grouped totals.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
| name | sqlite-import-aggregate |
| description | Procedure for importing fixture rows and computing grouped totals. |
| version | 1 |
Use this when a task asks for CSV import and grouped totals.
fixture.csv with show_fixture.SUM(amount)GROUP BY categoryORDER BY categoryamount.ORDER BY, causing unstable output.dispatch(sql="...") — executes SQL against the task database.probe(skill_ref="...") — reads a skill document by reference key.catalog(path_ref="...") — shows fixture or bootstrap data by path reference.Replay-safe incremental reconcile workflow with dedupe, invalid-amount rejects, and two-pass audit logging.
Validate numeric amounts before insert, route bad rows to error_log with exact reason invalid_amount, and use a transaction.
Incremental reconcile workflow with dedupe, invalid-amount rejects, and batch audit logging.
Lightweight dedupe + reject workflow for nano benchmark transfer runs.
Holdout fluxtool syntax reference with remapped command/operator language
Complete reference for the gridtool data processing CLI