We build smart websites & automation systems for modern businesses.

If your website visitors encounter an insert error, or you see no new data syncing inside this Admin Portal, your Supabase leads table has Row Level Security (RLS) enabled, but standard public permissions are restricted.

To resolve this instantly, copy and run the SQL below inside your Supabase project SQL Editor to authorize public write and syncing permissions:

-- Ensure leads table is correctly structured
create table if not exists public.leads (
  id uuid default gen_random_uuid() primary key,
  name text,
  email text,
  phone text,
  business_type text,
  description text,
  budget text,
  features jsonb default '[]'::jsonb,
  created_at timestamp with time zone default timezone('utc'::text, now()) not null
);

-- Enable row level security (RLS) on leads
alter table public.leads enable row level security;

-- Policy 1: Allow anyone to insert leads (public web form)
drop policy if exists "Allow public inserts" on public.leads;
create policy "Allow public inserts" on public.leads
for insert to anon, authenticated
with check (true);

-- Policy 2: Allow anyone to read leads (realtime sync / admin board)
drop policy if exists "Allow public select" on public.leads;
create policy "Allow public select" on public.leads
for select to anon, authenticated
using (true);

-- Policy 3: Allow anyone to delete/dismiss leads (archive action)
drop policy if exists "Allow public delete" on public.leads;
create policy "Allow public delete" on public.leads
for delete to anon, authenticated
using (true);