Supabase and Edge Functions

Database migrations, Deno edge functions, and vector-powered AI search.

Edge Functions

Located in supabase/functions/. Written in Deno and deployed to Supabase's edge runtime.

rag-chat

Semantic search over vector DB + Gemini AI to answer questions

rag-ingest

Chunks documents and inserts them for vector embeddings

rag-instagram

Processes Instagram DM data for knowledge base ingestion

rag-whatsapp

Processes WhatsApp messages for knowledge base ingestion

Located in supabase/functions/_shared/

CORS headersStandardized cross-origin configuration

Gemini API configGoogle AI model initialization and prompts

Supabase clientAuthenticated Deno Supabase client

Located in supabase/migrations/. 10 migrations applied.

20260121

add_playertag

Player tag system for gamification

20260123-1

add_is_admin_column

Admin flag for user profiles

20260123-2

create_audit_logs

Audit log tracking for admin actions

20260123-3

refactor_admin_users

Dedicated admin_users table (replacing profiles.is_admin)

20260207-1

create_stories_tables

Instagram-style stories feature

20260207-2

create_stories_storage

Storage bucket for story media

20260220-1

create_match_document_chunks_rpc

Vector similarity search for RAG

20260220-2

add_source_and_rate_limits

Rate limiting and source tracking

20260221-1

create_instagram_muted_table

Instagram muted users management

20260221-2

create_whatsapp_muted_table

WhatsApp muted users management