create table if not exists roster (
id text primary key,
name text,
color text,
sort int
);
create table if not exists blocks (
id text primary key,
date text,
type text,
person_id text,
start int,
"end" int
);
alter table roster enable row level security;
alter table blocks enable row level security;
create policy "anon all roster" on roster for all
using (true) with check (true);
create policy "anon all blocks" on blocks for all
using (true) with check (true);
alter publication supabase_realtime add table roster;
alter publication supabase_realtime add table blocks;
In Project Settings → API, copy the Project URL and the anon public key.
Paste them below and Connect.
This is an internal FOH schedule, not sensitive data, so open access is fine. The keys live in this browser only.
Backup & Data
Export a snapshot of the whole schedule (roster + shifts) as a file, or import one.
Lock screen signs this device out and requires the password again — useful on a shared computer.