Skip to content

Instantly share code, notes, and snippets.

@Tegath
Tegath / atlas_phase9_combined.sql
Created April 26, 2026 15:21
Atlas Phase 9 + 9.1 — combined migrations (055 systems registry + 056 knowledge base). Paste as one block into Supabase Studio.
-- ============================================================
-- MomentumOS — Atlas Phase 9 / 055 — Systems Registry
-- ============================================================
-- Generalizes the funnel concept into "systems" — every operational
-- process in the business (acquisition, recruitment, training, content
-- production, customer success, finops, ...) is a first-class entity
-- with stages, KPIs, linked Drive assets, metrics history, and
-- experiments. Authored in Google Sheets (one Sheet per system,
-- 6-tab canonical template), parsed daily into these tables.
--
@Tegath
Tegath / 056_atlas_knowledge.sql
Created April 26, 2026 15:13
Atlas Phase 9.1 — Knowledge base migration (atlas_knowledge_folders + atlas_knowledge_assets + tsvector search RPC). Paste into Supabase Studio.
-- ============================================================
-- MomentumOS — Atlas Phase 9.1 / 056 — Knowledge base
-- ============================================================
-- N Drive folders per workspace (markdown / gdocs / sheets / slides).
-- Recursive crawl, full-text search via tsvector, brain access via
-- atlas_search_knowledge tool. Distinct from atlas_systems (which
-- is structured 6-tab template) and from sheets_integrations (which
-- is the existing business_context loader for Telegram/Claude panel).
--
-- Depends on 047 (atlas_workspaces) and 055 (atlas_systems pattern).
@Tegath
Tegath / 055_atlas_systems.sql
Created April 26, 2026 14:08
Atlas Phase 9 — Systems registry migration (7 tables + view, RLS workspace-scoped, idempotent). Paste into Supabase Studio SQL editor.
-- ============================================================
-- MomentumOS — Atlas Phase 9 / 055 — Systems Registry
-- ============================================================
-- Generalizes the funnel concept into "systems" — every operational
-- process in the business (acquisition, recruitment, training, content
-- production, customer success, finops, ...) is a first-class entity
-- with stages, KPIs, linked Drive assets, metrics history, and
-- experiments. Authored in Google Sheets (one Sheet per system,
-- 6-tab canonical template), parsed daily into these tables.
--