Deploying the database

Apply the migrations in supabase/migrations/ to a local Docker stack or your own Supabase project. They are timestamp-prefixed and must be applied in lexical order.

Applying migrations#

Terminal

bunx supabase login
bunx supabase link --project-ref <your-project-ref>
bunx supabase db push

Open your project dashboard, open the SQL Editor, and run each file in supabase/migrations/ in timestamp order.

Terminal

psql "$DATABASE_URL" -f supabase/migrations/20250806092049_initial_schema.sql

Local development#

Terminal

bun run docker:supabase
bunx supabase db reset

Verify#

Confirm these tables exist:

users, contacts, chats, messages
ai_suggestions, loops, contact_inferences
user_preferences, auto_reply_rules

Then reload the PostgREST schema cache so the API sees the new shape immediately:

Terminal

docker exec supabase-db psql -U postgres -d postgres -c "NOTIFY pgrst, 'reload schema';"