Exécutez n'importe quel Skill dans Manus
en un clic

Exécutez n'importe quel Skill dans Manus en un clic

Commencer

sqlite-import-aggregate

Étoiles2

Forks0

Mis à jour13 février 2026 à 20:39

Procedure for importing fixture rows and computing grouped totals.

Installation

Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.

Exécuter dans Manus

Source

artemgetmann

artemgetmann/Cortex

Ouvrir le dépôt GitHub Voir les dépôts du créateur

Téléchargement

Exécuter dans Manus

Métiers associésSOC

Basé sur la classification professionnelle SOC

Architectes de bases de donnéesProfessions informatiques et mathématiques·SOC 15-1243

SKILL.md

readonly

name	sqlite-import-aggregate
description	Procedure for importing fixture rows and computing grouped totals.
version	1

Import + Aggregate

Use this when a task asks for CSV import and grouped totals.

Procedure

Read fixture.csv with show_fixture.
Build target table with strict column types.
Insert all fixture rows exactly once.
Run aggregate query with:

SUM(amount)
GROUP BY category
ORDER BY category

Re-run the final aggregate query to verify deterministic output.

Common Failures

Missing one fixture row.
Incorrect numeric parsing for amount.
Forgetting ORDER BY, causing unstable output.

Tool Reference

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.

Plus depuis ce dépôt

même dépôt

sqlite-incremental-reconcile-replay-safe

artemgetmann/Cortex

Replay-safe incremental reconcile workflow with dedupe, invalid-amount rejects, and two-pass audit logging.

2026-03-082

sqlite-partial-failure-recovery-strict

artemgetmann/Cortex

Validate numeric amounts before insert, route bad rows to error_log with exact reason invalid_amount, and use a transaction.

2026-03-082

sqlite-incremental-reconcile-audit-transfer

artemgetmann/Cortex

Incremental reconcile workflow with dedupe, invalid-amount rejects, and batch audit logging.

2026-03-072

sqlite-incremental-reconcile-nano

artemgetmann/Cortex

Lightweight dedupe + reject workflow for nano benchmark transfer runs.

2026-02-262

fluxtool-basics

artemgetmann/Cortex

Holdout fluxtool syntax reference with remapped command/operator language

2026-02-252

gridtool-basics

artemgetmann/Cortex

Complete reference for the gridtool data processing CLI

2026-02-252

name	sqlite-import-aggregate
description	Procedure for importing fixture rows and computing grouped totals.
version	1

Import + Aggregate

Use this when a task asks for CSV import and grouped totals.

Procedure

Read fixture.csv with show_fixture.
Build target table with strict column types.
Insert all fixture rows exactly once.
Run aggregate query with:

SUM(amount)
GROUP BY category
ORDER BY category

Re-run the final aggregate query to verify deterministic output.

Common Failures

Missing one fixture row.
Incorrect numeric parsing for amount.
Forgetting ORDER BY, causing unstable output.

Tool Reference

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.