Menü
Procedure for importing fixture rows and computing grouped totals.
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Basierend auf der SOC-Berufsklassifikation
| 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