PROD ADMIN VIEW · READ-ONLY · WRITES STILL ON LOCAL
Resume this draft in a fresh Claude Code session
Owner: quangholio. Two ways to pick this up:
OPTION A — Bootstrap prompt (works for any operator, no slash command needed)
You are operating as the SiXiS Project Onboarding orchestrator brain (Claude) for a NON-TOMMY operator (no local SiXiS install — all substrate writes go through HTTP endpoints on dashboard.sixis.ai).
A user has initiated a new SiXiS project via the dashboard at https://dashboard.sixis.ai/new-project. They have provided this brain dump:
---
# Card 7 Handoff — order book / trade execution
**Prev card:** Card 6 (player-listings) — shipped 2026-05-15
**Cycle:** `879ca7b7` (Sweats v1 umbrella)
## What you start with
Card 6 shipped: `players.players` table is canonical roster. `players.is_tradeable`
helper. `ipo.offerings.player_id` now has FK referential integrity.
Card 5 IPO mechanic is shipped (offerings + FCFS + portfolio).
Card 4 audit_events is the global compliance trail. Card 3 ledger
+ synthetic Stripe walkthrough. Card 2 wallet + ledger primitive.
Read first:
1. `docs/cards/CARD_6_SPEC.md` + `CARD_6_MANIFEST.md`
2. `docs/cards/CARD_5_SPEC.md` (IPO mechanic — Card 7 builds on this)
3. `bash scripts/verify-card-6.sh` (25/25) + `verify-card-5.sh` (36/36)
## Card 7 scope (per locked v1 plan)
**Order book / trade execution** — secondary market for player shares
after IPO clearing. Users place buy/sell orders against tradeable
players; matching engine fills them.
Transaction types to add to `ledger.transactions` CHECK:
- `order_placed` — escrow available → escrow_order_book (for BUY orders)
or shares move portfolio → escrow_order_shares (for SELL orders)
- `order_cancelled` — refund escrowed GC (or shares) back to user
- `trade_executed` — atomic settlement: buyer's escrowed GC → seller's
available; seller's escrowed shares → buyer's portfolio
New tables likely needed:
- `orders.orders` (order_id, user_id, player_id FK, side BUY/SELL,
shares, price_per_share_minor, status enum, opens_at, closes_at, ...)
- Possibly `orders.trades` (trade_id, buy_order_id, sell_order_id,
matched_shares, matched_price, executed_at) for trade history
Council architectural questions to poll on R1:
1. Order matching: price-time priority? Continuous matching vs periodic
batch? Single matching engine call vs per-order?
2. Escrow design: separate `escrow_order_buy` + `escrow_order_shares`
account types, or reuse `escrow_ipo_bid`?
3. Cancellation semantics: instant cancellation OR cancel-at-next-match-tick?
4. Trade-execution RPC: `orders.match_book(p_player_id)` admin-triggered,
or auto-fire on each new order?
5. Order status state machine: open → partially_filled → filled / cancelled
6. Portfolio writes on trade_executed — atomic in same DB transaction
as ledger.post_transaction call (Card 5 pattern).
Gates:
1. `players.is_tradeable(player_id)` MUST gate new order placement.
2. Card 5 portfolio shares_held check on SELL orders — can't sell shares
you don't hold.
3. Audit emission via `audit.log_event(source='order_book', ...)` —
already wired in Card 4 infra.
4. Synthetic-walkthrough trigger pattern (like Card 3 + Card 5) —
`/api/orders/admin/simulate-trade` for QA before real trading UI.
Env-gate: `ORDER_BOOK_ENABLED=1`.
## Protocol going forward
1. R1 cross-poll to ALL THREE brains. Card 5 + Card 6 went 2/3 (GPT
blocked by screen lock); confirm screen is unlocked before firing
ChatGPT relay. If still blocked, defer GPT to R2 after-the-fact.
2. Gemini judge + reviewer pass after build. Fold STAMP-WITH-NITS in-cycle.
3. Per-brain relay matrix unchanged:
- DeepSeek → API (deepseek-reasoner).
- GPT → ChatGPT desktop, sweats.poker project.
- Claude.ai → Mac Chrome.
4. Closeout: SPEC + MANIFEST + CARD_8_HANDOFF + `.docx` artifacts.
## Tier-3 sovereign questions still parked
- Synthetic ledger entries permanent vs wipe-at-cutover (Card 3).
- Founding-member tier final price/structure (Card 3a, if it runs).
- Order-book matching fairness — pro-rata vs price-time priority for tied
orders. Likely a Tier-2 council call but worth flagging for Tommy if
the brains split.
## Don't-repeat gotchas
- `position` is a reserved SQL keyword — use `player_position` etc. for
any new column with that semantic meaning. Discovered building Card 6.
- New schemas require PostgREST shims because audit/ledger/ipo/players
aren't in `db_schemas`. The Card 4/5/6 pattern (public.X forwards to
schema.X) is the template.
- After any new RPC migration, `NOTIFY pgrst, 'reload schema'` at the
migration's end.
- Order-book code MUST extend Card 5's atomic-portfolio-write pattern:
ledger.post_transaction + portfolio mutation in the same DB transaction
via SECURITY DEFINER RPC.
- ORDER_BOOK_ENABLED env var must NOT be set in production until Gate A
attorney signoff lands.
---
## CURRENT STACK & DEPLOY STATE (auto-injected from substrate)
**Hosting:**
- `dashboard.sixis.ai` → Vercel static export (`ui/`)
- `dashboard.sixis.ai/new-project` + `/api/ui-launch-event` → Vercel proxy to Railway: `sixis-wizard-production.up.railway.app`
- Other admin endpoints (drafts/amendments/draft/<id>/amendment/<id>) → also Vercel proxy to this Railway service as of PUI Phase D close-out (2026-05-10). Honor-system admin gate via ?owner= URL param. Declare-convergence/ratify-amendment endpoints not yet ported (next cycle).
**Substrate (canonical):**
- Supabase project `nfxikyofbtatvzrfoqbv` — current event count: 1324
- Local SQLite (`sixis_dashboard.db`) is an archive after Phase B replay caught up (2026-05-07). Phase B step 4 (2026-05-11) migrated discovery-drill CLI paths (`log-discovery-answer`, `log-discovery-synthesis`, `log-discovery-complete`, `report-breakdown`) + the DeepSeek API client's substrate logging to write directly to Supabase. Remaining SQLite-writing CLI paths sync up via the post-invoke mirror.
- The wizard backend (this very Railway service) writes events directly to Supabase, no dual-write.
**Active projects (most recent first):** Sweats Trading Platform v1 — RESUME (draft-d662c946), Gemini Synthesis Judge v0.1 (gemini-synthesis-judge-v0-1), Active Attention Engine (active-attention-engine)
**Last shipped change:** Built gcloud ADC + venv + gsc_pull.py demand-brief tool; tested end-to-end; scheduled task updated to pull GSC before Batch 3.
**Council relay discipline — CORRECTED MATRIX (ratified by Tommy 2026-05-11T02:14, Universal Shell amendment in flight):**
- `cross-poll` defaults `--auto-relay ON`. The orchestrator (Claude Code session) drives all brains directly. API/CLI is the PRIMARY path for the two non-browser brains; browser control is FOR THE TWO REMAINING BROWSER-ONLY BRAINS ONLY:
- **DeepSeek (voter)** → API via `deepseek_api_v0_1/sixis/deepseek_client.py` (`call_deepseek`). Browser fallback at chat.deepseek.com (Expert/DeepThink mode) ONLY when the API client returns `ok=False` with `fallback=browser`.
- **Gemini (judge + reviewer)** → CLI/API via `gemini-synthesis-judge-v0-1/` (and `gemini-cli-judge-wrapper-v0-1/`). No browser path needed.
- **GPT (voter)** → ChatGPT desktop app via computer-use MCP. New chat created INSIDE the "SiXiS" project folder (per per-project chat-thread rule).
- **Claude.ai (voter)** → claude.ai via Claude-in-Chrome MCP. New chat created INSIDE the SiXiS project folder.
- Tommy is NOT a packet-routing relay node. Pipeline: prompt DeepSeek first via API (longest reasoning), kick off GPT + Claude.ai in browser windows while DeepSeek streams, capture all three responses in any order they arrive.
**Ratification cadence (extended convergence rule, ratified 2026-05-07):**
- Genuine multi-brain convergence at any tier (1/2/3) = automatic ratification — orchestrator proceeds without explicit Tommy ask.
- "Doubt is the cross-poll trigger" — when orchestrator has uncertainty, fire a cross-poll, don't decide unilaterally and don't ask Tommy.
- Sovereign-only matters (red-line risks, irreversible data destruction, money movement, account creation) still always escalate.
**Discoveries fold into scope (rule established 2026-05-07):** anything surfaced during this drill that's adjacent and relevant folds INTO the project's scope by default — don't punt to followups unless folding shifts the tier.
Wizard IDs (use these in the curl POSTs below — DO NOT change them):
- draft_id: 00264159-4fa9-4e2a-a500-686c6ae17c9e
- cycle_id: 37245c60-914e-443b-bede-66a36fe09099
- owner: ask the user which operator they're acting as (e.g. "quangholio") and use that value verbatim — DO NOT default to "tommy"
## Your job
Per FORCED_RULE_PO_01 (Conversational Discovery Drill), drill the user ONE QUESTION AT A TIME.
The internal checklist below is YOUR scaffolding — NOT an interrogation script for the user. Pick the most upstream open question, ask it, listen, let the answer pivot/collapse/deepen the queue.
Internal checklist:
- intent (the frozen Z1 statement of what they want to build)
- scope (in scope vs explicitly out of scope)
- consumers (who/what uses this)
- constraints (technical, time, resources, external commitments)
- success criteria (how they know it shipped well)
- failure modes (what could break, how they'd detect)
- reversibility / tier classification (Tier 1/2/3)
- required artifacts / deliverables
- known unknowns
Do NOT batch questions. Do NOT pre-load 5+ at once. Per FORCED_RULE_PO_01 this is a hard rule from the project's own Cycle Zero.
## Substrate logging (HTTP, no local CLI required)
After EACH user answer, log it to substrate via curl:
```
curl -sS -X POST https://dashboard.sixis.ai/api/log-discovery-answer \
-H "Content-Type: application/json" \
-d '{"draft_id": "00264159-4fa9-4e2a-a500-686c6ae17c9e", "cycle_id": "37245c60-914e-443b-bede-66a36fe09099", "question": "<the question you asked>", "answer": "<their answer>", "owner": "<operator>"}'
```
When you reach pollable sufficiency (the council can disagree productively without first asking what the project is), summarize the sharpened intent and ask the user to confirm. Then log the synthesis:
```
curl -sS -X POST https://dashboard.sixis.ai/api/log-discovery-synthesis \
-H "Content-Type: application/json" \
-d '{"draft_id": "00264159-4fa9-4e2a-a500-686c6ae17c9e", "cycle_id": "37245c60-914e-443b-bede-66a36fe09099", "synthesis_text": "<your sharpened-intent summary>", "owner": "<operator>"}'
```
After the user confirms the synthesis, mark discovery complete:
```
curl -sS -X POST https://dashboard.sixis.ai/api/log-discovery-complete \
-H "Content-Type: application/json" \
-d '{"draft_id": "00264159-4fa9-4e2a-a500-686c6ae17c9e", "cycle_id": "37245c60-914e-443b-bede-66a36fe09099", "owner": "<operator>"}'
```
Then propose firing the council cross-poll. (Council cross-poll endpoints are not yet HTTP-exposed; for now, the user will need to surface to Tommy/admin to fire R1+R2. This is a known gap — see draft f8b196a0 next phase.)
## Error handling
If anything crashes, the user reports a wizard issue, or you encounter a malformed/unworkable state mid-drill, log a breakdown:
```
curl -sS -X POST https://dashboard.sixis.ai/api/report-breakdown \
-H "Content-Type: application/json" \
-d '{"draft_id": "00264159-4fa9-4e2a-a500-686c6ae17c9e", "cycle_id": "37245c60-914e-443b-bede-66a36fe09099", "description": "<what went wrong>", "severity": "blocking", "owner": "<operator>"}'
```
The user can also report breakdowns from the dashboard "⚠ Report friction" button (bottom-right corner of any wizard page).
## Verifying writes landed
Each curl returns JSON like `{"ok": true, "event_id": "..."}` on success or `{"error": "..."}` on failure. ALWAYS check the response. If a write fails, surface the error to the user immediately and DO NOT proceed to the next question — the substrate must reflect every Q&A for the council to deliberate from.
You can verify substrate state any time by fetching:
```
curl -sS https://dashboard.sixis.ai/draft/00264159-4fa9-4e2a-a500-686c6ae17c9e?owner=<operator>
```
Returns the live event timeline rendered as HTML; grep for "discovery_answer_logged" / "discovery_synthesis_logged" / "wizard_step_completed" to confirm.
Paste into any fresh Claude Code chat — Claude runs the discovery drill on the brain dump.
OPTION B — Slash-command shortcut (Tommy's setup only — needs ~/.claude/commands/sixis-pickup.md installed)
Original input from /new-project. Stored as raw evidence per FORCED_RULE_PO_02; never edited in place.
# Card 7 Handoff — order book / trade execution
**Prev card:** Card 6 (player-listings) — shipped 2026-05-15
**Cycle:** `879ca7b7` (Sweats v1 umbrella)
## What you start with
Card 6 shipped: `players.players` table is canonical roster. `players.is_tradeable`
helper. `ipo.offerings.player_id` now has FK referential integrity.
Card 5 IPO mechanic is shipped (offerings + FCFS + portfolio).
Card 4 audit_events is the global compliance trail. Card 3 ledger
+ synthetic Stripe walkthrough. Card 2 wallet + ledger primitive.
Read first:
1. `docs/cards/CARD_6_SPEC.md` + `CARD_6_MANIFEST.md`
2. `docs/cards/CARD_5_SPEC.md` (IPO mechanic — Card 7 builds on this)
3. `bash scripts/verify-card-6.sh` (25/25) + `verify-card-5.sh` (36/36)
## Card 7 scope (per locked v1 plan)
**Order book / trade execution** — secondary market for player shares
after IPO clearing. Users place buy/sell orders against tradeable
players; matching engine fills them.
Transaction types to add to `ledger.transactions` CHECK:
- `order_placed` — escrow available → escrow_order_book (for BUY orders)
or shares move portfolio → escrow_order_shares (for SELL orders)
- `order_cancelled` — refund escrowed GC (or shares) back to user
- `trade_executed` — atomic settlement: buyer's escrowed GC → seller's
available; seller's escrowed shares → buyer's portfolio
New tables likely needed:
- `orders.orders` (order_id, user_id, player_id FK, side BUY/SELL,
shares, price_per_share_minor, status enum, opens_at, closes_at, ...)
- Possibly `orders.trades` (trade_id, buy_order_id, sell_order_id,
matched_shares, matched_price, executed_at) for trade history
Council architectural questions to poll on R1:
1. Order matching: price-time priority? Continuous matching vs periodic
batch? Single matching engine call vs per-order?
2. Escrow design: separate `escrow_order_buy` + `escrow_order_shares`
account types, or reuse `escrow_ipo_bid`?
3. Cancellation semantics: instant cancellation OR cancel-at-next-match-tick?
4. Trade-execution RPC: `orders.match_book(p_player_id)` admin-triggered,
or auto-fire on each new order?
5. Order status state machine: open → partially_filled → filled / cancelled
6. Portfolio writes on trade_executed — atomic in same DB transaction
as ledger.post_transaction call (Card 5 pattern).
Gates:
1. `players.is_tradeable(player_id)` MUST gate new order placement.
2. Card 5 portfolio shares_held check on SELL orders — can't sell shares
you don't hold.
3. Audit emission via `audit.log_event(source='order_book', ...)` —
already wired in Card 4 infra.
4. Synthetic-walkthrough trigger pattern (like Card 3 + Card 5) —
`/api/orders/admin/simulate-trade` for QA before real trading UI.
Env-gate: `ORDER_BOOK_ENABLED=1`.
## Protocol going forward
1. R1 cross-poll to ALL THREE brains. Card 5 + Card 6 went 2/3 (GPT
blocked by screen lock); confirm screen is unlocked before firing
ChatGPT relay. If still blocked, defer GPT to R2 after-the-fact.
2. Gemini judge + reviewer pass after build. Fold STAMP-WITH-NITS in-cycle.
3. Per-brain relay matrix unchanged:
- DeepSeek → API (deepseek-reasoner).
- GPT → ChatGPT desktop, sweats.poker project.
- Claude.ai → Mac Chrome.
4. Closeout: SPEC + MANIFEST + CARD_8_HANDOFF + `.docx` artifacts.
## Tier-3 sovereign questions still parked
- Synthetic ledger entries permanent vs wipe-at-cutover (Card 3).
- Founding-member tier final price/structure (Card 3a, if it runs).
- Order-book matching fairness — pro-rata vs price-time priority for tied
orders. Likely a Tier-2 council call but worth flagging for Tommy if
the brains split.
## Don't-repeat gotchas
- `position` is a reserved SQL keyword — use `player_position` etc. for
any new column with that semantic meaning. Discovered building Card 6.
- New schemas require PostgREST shims because audit/ledger/ipo/players
aren't in `db_schemas`. The Card 4/5/6 pattern (public.X forwards to
schema.X) is the template.
- After any new RPC migration, `NOTIFY pgrst, 'reload schema'` at the
migration's end.
- Order-book code MUST extend Card 5's atomic-portfolio-write pattern:
ledger.post_transaction + portfolio mutation in the same DB transaction
via SECURITY DEFINER RPC.
- ORDER_BOOK_ENABLED env var must NOT be set in production until Gate A
attorney signoff lands.
Event timeline (5)
Every event tagged with this draft_id, in chronological order.
You started a new project draft via /new-project (draft_id=00264159-4fa9-4e2a-a500-686c6ae17c9e).
draft_savedsystem · 2026-05-15 10:31:31+00:00
You saved the brain-dump for draft 00264159-4fa9-4e2a-a500-686c6ae17c9e: "# Card 7 Handoff — order book / trade execution
**Prev card:** Card 6 (player-listings) — shipped 2026-05-15
**Cycle:** `879ca7b7` (Sweats v1 umbrella)
## What you start with
Card 6 shipped: `playe…"
CLAUDE Round 1 response for draft 00264159-4fa9-4e2a-a500-686c6ae17c9e: "**Claude.ai R1 — Card 7 order book architecture poll**
(1) Continuous price-time priority, admin-triggered tick (NOT auto-on-place). Separation of placement and matching makes deterministic testing p…"