Next Chapter OS — Consolidation Status
2026-04-22 · top-to-bottom view after OLD Supabase decommission
The head of the snake is severed.
OLD Supabase rdnnhxhohwjucvjwbwch — the primary source of 13+ months of sprawl — is DELETED.
All 74,021 rows preserved on NEW dwrnfpjcvydhmhnvyzov with full provenance.
Writes frozen. Drift-patch disabled. References scrubbed across ~/.claude/ and ~/repos/.
DELETEDOLD Supabase
74,021Rows preserved
0Gap rows
HTTP 410OLD URL (Gone)
3Lovable apps need repoint
1Primary Supabase going forward
1 · What was preserved
| Outcome | Tables | Notes |
|---|
| migrated live |
21 |
NEW has the full table at current row count — schema carried over. Includes tam_businesses, buyer_dossiers, cowork_enriched, etc. |
| archived |
43 |
NEW has *_archive_2026_04_22 tables with JSONB original_row + provenance (source_project, source_table, frozen_at). Includes call_log (1,395), persons (1,421), deal_research, dossier_cost_log, etc. |
| empty |
17 |
Zero rows on OLD — nothing to lose. Skipped by design. |
| TOTAL |
81 / 81 |
Zero gaps. Full parity check in scripts/full_parity_check.py. |
2 · What is gone
| Thing | Before | Now |
|---|
OLD Supabase project rdnnhxhohwjucvjwbwch |
ACTIVE_HEALTHY |
DELETED — DELETE 200, verify 404/410 |
| Hardcoded Service Role JWT in public-facing docs |
leaked in 3 files |
scrubbed — PROJECT-REFERENCE.md, 2 prompt files (commit e31de20) |
Pipeline writes to OLD (hrcom-deal-room, 5 jobs) |
writing hourly |
frozen — import-time RuntimeError (commit dfbaa23) |
Scheduled task old-supabase-drift-patch |
daily 6:15am |
disabled — was syncing OLD→NEW, unnecessary |
| rdnn references in memory/skills/plans/docs |
dozens |
scrubbed — ~20 files rewritten (commits 09b1738 + e31de20) |
3 · Architecture now
Data plane
| Instance | Purpose | State |
|---|
dwrnfpjcvydhmhnvyzov |
Next Chapter OS DB — sole primary. mark@chapter.guide, East US. |
LIVE — single source of truth |
rdnnhxhohwjucvjwbwch |
AND Call Command (OLD) |
DECOMMISSIONED 2026-04-22 |
lhmuwrlpcdlzpfthrodm |
ColdCall Universe — still backing 2 Lovable apps |
RETIRED — needs Lovable repoint |
asavljgcnresdnadblse |
Phoenix TAM Engine (migrated 2026-03-25) |
RETIRED |
pgoogsxaljtjhwhydqtg |
NYC Outreach Hub — full investor CRM |
consolidation TBD — most valuable |
iumytggxqtfyaxewgghb |
Marks NYC Hunt — investor contacts |
consolidation TBD |
wdhnsbzmcjpqbltkulwe |
NYC Deal Maker — attack_list + AI edge fn |
consolidation TBD |
lsxmnowczekpdjuvrxxt, ginqabezgxaazkhuuvvw, iwcvaowfogpffdllqtld |
Empty / debugger / NYC map — zero tables |
DELETE candidates |
Code plane
| Repo | Role | State |
|---|
nextchapter-crm | Main pipeline (ex–coldcall-universe) | active |
nextchapter-ops | Ops + scheduled tasks | active |
claude-skills | Skill library | active |
next-chapter-os | Consolidation scratchpad + diagnostic (fka hermes-review) | audit phase — will merge into ops |
hrcom-deal-room | HR.com / Debbie deal pipeline | FROZEN — needs rewire to NEW |
Scheduled tasks (Mac Mini)
| Task | State |
|---|
hermes-daily-agent-report — 4:03 PM daily | enabled |
phoenix-tam-engine | manual only |
old-supabase-drift-patch | DISABLED 2026-04-22 |
4 · What's left
3 Lovable apps still hardcode OLD. They load against rdnnhxhohwjucvjwbwch.supabase.co and will return 410 Gone at next page load. Repoint = change VITE_SUPABASE_URL + VITE_SUPABASE_ANON_KEY in each Lovable project's env.
| App | Lovable ID | Action |
|---|
| Debbie Deal Room | a3bf07f3-1c4c-437b-b658-f0d9f86c38dc | repoint |
| Pixel Perfect Clone | 01b7b849-30f8-405f-b057-55974c3baba0 | repoint |
| Next Chapter Reports | 70bfa70e-e847-47d0-abfd-5845c0ba81c1 | repoint |
Progress since 2026-04-22 consolidation
- Obsolete scripts ✅ archived 2026-04-22 —
compare_old_live.py, patch_archive_drift.py, full_parity_check.py, load_archive.py, daily_drift_patch.sh moved to scripts/archived/.
- Phoenix TAM Supabase ✅ fully dead —
asavljgcnresdnadblse returning HTTP 000 (DNS gone).
- 2 of 3 empty Supabases ✅ gone —
ginqabezgxaazkhuuvvw and iwcvaowfogpffdllqtld both return HTTP 000.
- Canonical URL ✅ switched —
chapter.guide primary; legacy Vercel aliases retired.
Still open — requires Ewing input
- hrcom-deal-room rewire — BLOCKED. Unfreeze needs (a) schema restore of
buyer_dossiers + dossier_cost_log from *_archive_2026_04_22 tables, (b) locate missing buyer_lib Python package (was at ~/Projects/dossier-pipeline/, now gone — only .pyc in cache), (c) fix deal_research column drift in b6_sync_to_deal_research.py (writes confidence/call_opener/business_strength columns that don't exist). Archive tables hold 63 + 549 rows safely.
- Delete
lsxmnowczekpdjuvrxxt — verified empty (0 tables), safe to delete. Needs a Supabase Management API token minted at supabase.com/dashboard/account/tokens. One orphaned Lovable app (edd4f327-d711-40ae-bd2b-d51ca55f5424 — Ewing NYC Mobile Map) will 404 afterward.
- Repoint 3 Lovable apps — no Lovable API for secrets, no local repo clones. Must be done via Chrome MCP session driving the Lovable UI (Cloud → Secrets → swap
VITE_SUPABASE_URL + anon key → rebuild). Also: Next Chapter Reports subdomain returns 404 — project may be unpublished.
- 4 lingering Supabases (ColdCall Universe, NYC Outreach Hub, Marks NYC Hunt, NYC Deal Maker) — all still alive, no per-instance keys on this machine. Each backs 1–2 Lovable apps. Merging into primary requires dumping first, which needs their service-role keys or Management token.
- JWT rotation — the old Service Role JWT was leaked in 3 files and is now defunct (OLD project gone). No action required, but noted.
5 · Where we are going
Next arc: kill the rest of the sprawl.
OLD was the biggest offender, but 4 other Supabase instances still hold real data or back live apps. The pattern is the same: archive, verify zero loss, decommission.
- Repoint the 3 Lovable apps off
rdnn to dwrnfpjcvydhmhnvyzov. Fastest to fix visibly-broken things first.
- Audit the 4 discovered instances (NYC Outreach Hub, Marks NYC Hunt, NYC Deal Maker, ColdCall Universe). Decide: merge into
dwrnfpjcvydhmhnvyzov, keep as purpose-built silo, or archive + delete.
- Delete the 3 empty/dead instances (
lsxmnowczekpdjuvrxxt, ginqabezgxaazkhuuvvw, iwcvaowfogpffdllqtld). Zero risk.
- Rewire
hrcom-deal-room to NEW. Unblocks the 5 frozen write jobs.
- Archive the migration scripts in
next-chapter-os. They hardcode a dead URL.