fdb-go

Review the SPFresh vector index (RFC-094, pkg/recordlayer/spfresh_*.go) against the SPANN and SPFresh papers — the algorithmic spec. The papers' authors are the reviewer persona, exactly as Graefe is for Cascades and the FDB C++ dev is for the client. Use for any change to the SPFresh index (write path, search path, rebalancer lifecycles, RaBitQ usage, config defaults), for recall/latency regressions, and for periodic "are we still faithful to the paper?" audits.

End-to-end engineering workflow for the pure-Go FoundationDB client (pkg/fdbgo — transport, transaction, commit path, RYW, key selectors, retry/ctx, GRV, wire encoding, the libfdb_c differential). Use for ANY client/wire change: drives RFC → review (FDB C++ maintainer + Torvalds + /code-review) → implement → review again → PR gauntlet (codex + @claude) → merge. The client analog of todo-worker: the FDB C++ dev substitutes for Graefe, C++ (libfdb_c 7.3.77) is the spec, wire compatibility is the hard line. Composes fdb-client-review (the review gate) and hunt-divergences (the differential method).

Work on the pure-Go FoundationDB client (pkg/fdbgo — transport, transaction, commit path, RYW, key selectors, retry/ctx, wire encoding). Includes mandatory review by the FDB C++ client developer (validates Go against the 7.3.77 C++ source — the spec) and Torvalds (code quality). The client/wire analog of the query-engine skill: the FDB C++ dev substitutes for Graefe on client/wire items.

Find behavioral divergences between the pure-Go FDB client (pkg/fdbgo) and libfdb_c via differential + fuzz testing, root-cause each against the C++ source, fix Go to match (C++ is the spec), and pin with a red→green differential. Use when auditing client correctness, when a differential/fuzz run mismatches, or when asked to "prove we're identical to the C client."

Work on the Cascades query planner/optimizer and SQL execution engine. Includes mandatory architectural review by Graefe (Cascades alignment) and Torvalds (code quality).

Pick the next unchecked TODO.md item, write an RFC, get it reviewed by Graefe+Torvalds, implement, review again, open PR, iterate with @claude reviewer until LGTM.

Bump pinned versions of (A) Java fdb-record-layer / fdb-relational artifacts or (B) the FDB C++ wire protocol. Captures every spot the version is pinned, the codegen steps, and the conformance gotchas. Pass `java` or `fdb-cpp` to pick which procedure to run.

Start or continue a shift in the Vollkonti 24/7 shift system. Determines shift type (day/swing/night) from current time, reads handover, creates branch+PR.