reconcile-vector-store

Verify Qdrant vector store is in sync with PostgreSQL extraction state by comparing counts and optionally re-indexing missing vectors.

SKILL.md

GitHub

reconcile-vector-store Specification

ID: reconcile-vector-store Version: 1.0.0 Status: Active Owner: CIC Pipeline Team


Purpose

Compare vector store with PostgreSQL extraction state:

  • Check mode: Detect drift and report status
  • Repair mode: Re-index missing vectors from PostgreSQL

Trigger

reconcile-vector-store [check | repair]

Input Schema

interface SkillInput {
  mode: "check" | "repair";  // Required. check (default) or repair
}

Output Schema

interface SkillOutput {
  status: "success" | "error";
  mode: string;
  postgresRecords: number;
  qdrantVectors: number;
  driftCount: number;
  driftPercentage: number;
  syncTimestamp: string;
  operationDuration: string;
  timestamp: string;
}

Error Handling

See Skill Operator Guide — Error Handling for standard error codes.

Additional errors:

Code Message Handler
DRIFT_DETECTED Vector store out of sync (check mode only) Run repair mode or investigate
REPAIR_FAILED Re-indexing failed Check PostgreSQL availability

Full Reference

For Setup, Requirements, Testing, Configuration, and Troubleshooting:

→ See Skill Operator Guide