Ejecuta cualquier Skill en Manus
con un clic

Ejecuta cualquier Skill en Manus con un clic

Comenzar

sqlite-incremental-reconcile

Estrellas2

Forks0

Actualizado14 de febrero de 2026 a las 17:01

Stateful ingest workflow with dedupe, rejects, and checkpoint logging.

Instalación

Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.

Ejecutar en Manus

Fuente

artemgetmann

artemgetmann/Cortex

Abrir repositorio de GitHub Ver repositorios del creador

Descarga

Ejecutar en Manus

Ocupaciones relacionadasSOC

Basado en la clasificación ocupacional SOC

Arquitectos de bases de datosOcupaciones informáticas y matemáticas·SOC 15-1243

Explorador de archivos

2 archivos

SKILL.md

readonly

name	sqlite-incremental-reconcile
description	Stateful ingest workflow with dedupe, rejects, and checkpoint logging.
version	1

Incremental Reconcile

Use this skill for incremental_reconcile tasks.

Critical Semantics

Use checkpoint tag: CKP-APR-01
Source rows are available in fixture_seed.
event_id is the idempotency key.
Duplicate rows must be written to rejects with reason duplicate_event.

Required Flow

Start transaction (BEGIN TRANSACTION).
Insert first-seen rows from fixture_seed into ledger with checkpoint tag CKP-APR-01.
Insert duplicate rows into rejects with reason duplicate_event.
Upsert one row in checkpoint_log with checkpoint tag and inserted row count.
Commit transaction (COMMIT).
Verify aggregate output with deterministic ordering:

SELECT category, SUM(amount) AS total FROM ledger GROUP BY category ORDER BY category;

Guardrails

Never delete from ledger to satisfy dedupe.
Never drop ledger.
Keep behavior idempotent across reruns.

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.

Más de este repositorio

mismo repositorio

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-incremental-reconcile
description	Stateful ingest workflow with dedupe, rejects, and checkpoint logging.
version	1

Incremental Reconcile

Use this skill for incremental_reconcile tasks.

Critical Semantics

Use checkpoint tag: CKP-APR-01
Source rows are available in fixture_seed.
event_id is the idempotency key.
Duplicate rows must be written to rejects with reason duplicate_event.

Required Flow

Start transaction (BEGIN TRANSACTION).
Insert first-seen rows from fixture_seed into ledger with checkpoint tag CKP-APR-01.
Insert duplicate rows into rejects with reason duplicate_event.
Upsert one row in checkpoint_log with checkpoint tag and inserted row count.
Commit transaction (COMMIT).
Verify aggregate output with deterministic ordering:

SELECT category, SUM(amount) AS total FROM ledger GROUP BY category ORDER BY category;

Guardrails

Never delete from ledger to satisfy dedupe.
Never drop ledger.
Keep behavior idempotent across reruns.

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.