🔧 First-time Setup

Connect your Supabase database. You only do this once — it saves automatically.

1
Go to supabase.com → sign up free → create a new project.
2
Go to SQL Editor and run this:

create table if not exists clients (id uuid default gen_random_uuid() primary key, name text not null, whatsapp text, email text, type text not null, notes text, project_note text, steps jsonb not null default '{}'::jsonb, created_at timestamptz default now()); alter table clients enable row level security; create policy "Public" on clients for all using (true) with check (true);

create table if not exists comments (id uuid default gen_random_uuid() primary key, client_id uuid references clients(id) on delete cascade, author text not null default 'Team', body text not null, created_at timestamptz default now()); alter table comments enable row level security; create policy "Public" on comments for all using (true) with check (true);

create table if not exists documents (id uuid default gen_random_uuid() primary key, client_id uuid references clients(id) on delete cascade, name text not null, path text not null, size bigint, mime_type text, uploaded_by text, created_at timestamptz default now()); alter table documents enable row level security; create policy "Public" on documents for all using (true) with check (true);
3
Go to Storage → New Bucket. Create a bucket named client-docs. Make it Public.
4
Go to Project Settings → API. Copy your Project URL and anon key below.

Abdullah Digital

LLC · LTD · Tax Reporting