Skip to content

feat: Supabase Exit Plan — Full Migration to Cortex #26

@DarlingtonDeveloper

Description

@DarlingtonDeveloper

Summary

Complete migration off Supabase. Once PromptForge, Dredd, and Dispatch data live in Cortex, cancel the Supabase subscription.

Current Supabase Dependencies

PromptForge (→ Cortex, Issue #20)

  • prompts: 19 rows
  • prompt_versions: 52 rows
  • prompt_branches: 5 rows
  • prompt_subscriptions: 5 rows
  • prompt_effectiveness: 0 rows (empty)
  • prompt_usage_log: 0 rows (empty)

Alexandria (→ Already migrated to Cortex)

  • vault_entities: 29 rows → IN CORTEX (149 nodes total)
  • vault_people: 6 rows → IN CORTEX
  • vault_knowledge: 54 rows → IN CORTEX
  • vault_relationships: ~50 rows → IN CORTEX (198 edges)
  • vault_devices: 10 rows → IN CORTEX
  • vault_secrets: 24 rows → KEEP as local key vault (not in Cortex — secrets should not be in a queryable graph)

Dredd (→ Cortex)

  • reasoning_patterns: 1,584 rows
  • decisions: 2,474 rows
  • decision_context: linked to decisions
  • decision_outcomes: linked to decisions

Dispatch (→ Cortex)

  • backlog_items: ~100 rows
  • swarm_events: high volume
  • swarm_tasks: high volume
  • agent_metrics: telemetry
  • audit_log: audit trail

Migration Order

  1. PromptForge — Issue feat: Prompt Graph — Storage, Versioning & Migration #20 (active)
  2. Alexandria secrets — extract to local encrypted file/SQLite vault
  3. Dredd — reasoning patterns + decisions as Cortex nodes
  4. Dispatch — backlog items + tasks as Cortex nodes, events as observations

Post-Migration

  • Verify all services function without Supabase
  • Run parallel for 1 week (both Supabase and Cortex)
  • Cancel Supabase subscription
  • Remove Supabase connection strings from all configs
  • Update documentation

Supabase Instances

  • Warren/Swarm: uaubofpmokvumbqpeymz.supabase.co
  • Darlington/Personal: vufdabwdnpmxmgugzric.supabase.co (separate — may keep)

Acceptance Criteria

  • All PromptForge data in Cortex
  • Alexandria stripped to local key vault only
  • Dredd writing to Cortex instead of Supabase
  • Dispatch data migrated to Cortex
  • 1-week parallel run with zero issues
  • Supabase Warren instance decommissioned

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions