Skam Docs

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

Shared Deno Utilities

Located in supabase/functions/_shared/

CORS headersStandardized cross-origin configuration
Gemini API configGoogle AI model initialization and prompts
Supabase clientAuthenticated Deno Supabase client

Migration Timeline

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