원클릭으로 Manus에서 모든 스킬 실행

시작하기

sqlite-incremental-reconcile

스타2

포크0

업데이트2026년 2월 14일 17:01

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

설치

Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.

Manus에서 실행

출처

artemgetmann

artemgetmann/Cortex

GitHub 저장소 열기 Creator 저장소 보기

다운로드

Manus에서 실행

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.

이 저장소의 다른 Skills

같은 저장소

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.