Cole este SQL no SQL Editor do seu projeto Supabase:

CREATE TABLE IF NOT EXISTS conversations (
  phone TEXT PRIMARY KEY,
  name TEXT,
  unread INTEGER DEFAULT 0,
  last_message_at TIMESTAMPTZ DEFAULT NOW(),
  last_content TEXT DEFAULT '',
  status TEXT DEFAULT 'open',
  profile_pic_url TEXT
);
-- Se a tabela já existe, adicione a coluna:
ALTER TABLE conversations ADD COLUMN IF NOT EXISTS profile_pic_url TEXT;

CREATE TABLE IF NOT EXISTS messages (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  evolution_id TEXT UNIQUE,
  phone TEXT NOT NULL,
  direction TEXT NOT NULL,
  content TEXT NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE INDEX IF NOT EXISTS idx_messages_phone
  ON messages(phone, created_at DESC);

Informe o endereço que a Evolution API usa para chegar neste servidor. Se ambos rodam na mesma máquina, use http://localhost:3000.