Go to supabase.com → New project → give it a name like "dialtracker" → pick any region → click Create.
Step 2 — Create the database tables
In your Supabase project, click SQL Editor in the left sidebar, paste this SQL and click Run:
create table agents (
id uuid default gen_random_uuid() primary key,
name text not null,
created_at timestamptz default now()
);
create table entries (
id uuid default gen_random_uuid() primary key,
agent_id uuid references agents(id),
date date not null,
calls int default 0,
pickups int default 0,
pres int default 0,
deals int default 0,
ap numeric default 0,
deps numeric default 0,
deps_pend numeric default 0,
ld_spend numeric default 0,
ld_size int default 0,
created_at timestamptz default now()
);
create table leads (
id uuid default gen_random_uuid() primary key,
agent_id uuid references agents(id),
date date not null,
name text,
qty int default 0,
cost numeric default 0,
ap numeric default 0,
deals int default 0,
created_at timestamptz default now()
);
alter table agents enable row level security;
alter table entries enable row level security;
alter table leads enable row level security;
create policy "public_all" on agents for all using (true) with check (true);
create policy "public_all" on entries for all using (true) with check (true);
create policy "public_all" on leads for all using (true) with check (true);
Step 3 — Paste your keys
In Supabase → Project Settings → API → copy your Project URL and anon public key and paste them below: