Cloud sync not yet configured
To share inventory across everyone in your office, connect a free
Supabase database.
Create a project, run the SQL below to make a table, then paste your
Project URL and anon key into the
SUPABASE_URL and SUPABASE_KEY constants at the
top of the <script> block in this file.
Until then the app works locally using localStorage.
Show setup SQL
create table inventory (
id bigint generated always as identity primary key,
name text not null,
cat text not null default 'other',
qty integer not null default 0,
low integer not null default 5,
notes text default '',
updated_at timestamptz default now()
);
create table categories (
id bigint generated always as identity primary key,
cat_id text not null unique,
label text not null,
color text not null default '#888780'
);
-- Allow anonymous read/write (fine for internal tools):
alter table inventory enable row level security;
create policy "public access" on inventory for all using (true) with check (true);
alter table categories enable row level security;
create policy "public access" on categories for all using (true) with check (true);