GIMS — Garrett Initiative Management System

Connect your database

GIMS uses Supabase for secure, persistent storage. You'll need a free Supabase project to store orders and users. This takes about 5 minutes to set up once.

Go to supabase.com and create a free account + new project.

In your project, go to SQL Editor and run the setup script below to create the tables.

Go to Project Settings → API and copy your Project URL and anon public key.

Paste them below and click Connect.

Show SQL setup script ▾

-- GIMS Setup Script
-- Run this in your Supabase SQL Editor

create table if not exists orders (
  id text primary key,
  created_at timestamptz default now(),
  date text not null,
  field text not null,
  test_type text not null,
  sample_id text not null,
  status text default 'Pending',
  result text default '',
  notes text default '',
  collection_time text default '',
  location text default '',
  analytes jsonb default '{}'
);

create table if not exists profiles (
  id uuid primary key references auth.users(id) on delete cascade,
  name text,
  role text default 'farmer',
  email text
);

create table if not exists gims_users (
  id serial primary key,
  name text,
  email text unique,
  role text default 'farmer',
  created_at timestamptz default now()
);

create table if not exists gims_clients (
  id serial primary key,
  name text not null,
  email text,
  contact text,
  phone text,
  notes text,
  created_at timestamptz default now()
);

-- Add client_name to orders if upgrading
alter table orders add column if not exists client_name text default '';

-- Enable RLS
alter table orders enable row level security;
alter table gims_users enable row level security;

-- Allow all authenticated users to read orders
create policy "Read orders" on orders for select using (auth.role() = 'authenticated');
create policy "Insert orders" on orders for insert with check (auth.role() = 'authenticated');
create policy "Update orders" on orders for update using (auth.role() = 'authenticated');
create policy "Delete orders" on orders for delete using (auth.role() = 'authenticated');
create policy "Manage users" on gims_users for all using (auth.role() = 'authenticated');

alter table gims_clients enable row level security;
create policy "Manage clients" on gims_clients for all using (auth.role() = 'authenticated');

Supabase Project URL

Supabase Anon Key

Total orders

Pending

In review

Complete

Recent orders

Order ID	Date	Field/Block	Test type	Status
ORD-1777043661092	2026-04-24		Water Quality	Complete
ORD-002	2026-04-23	old first pick field	Water Quality	Complete
ORD-1776917531518	2026-04-23		Water Quality	Pending
ORD-001	2026-04-22	Jakes field 007	Microbiological	Complete

Lab ID	Date	Time	Client	Field/Block	Test type	Status	Actions
ORD-1777043661092	2026-04-24	00:01	Winston's Blueberries		Water Quality	W042426	Complete	Pass
ORD-002	2026-04-23	—	—	old first pick field	Water Quality	BF-2026-002	Complete	Pass
ORD-1776917531518	2026-04-23	00:01	Winston's Blueberries		Water Quality	F9949	Pending	Pending review
ORD-001	2026-04-22	—	—	Jakes field 007	Microbiological	BF-2026-001	Complete	Pass

	Lab ID	Date ▲	Test type	Status

0 orders selected

How to add a user: Click "Add user" to register them in GIMS, then go to Supabase → Authentication → Users and create their login with the same email. Emails ending in @garrettlabs.com get Lab Staff access automatically. All others are Clients.

Name	Email	Role	Added	Actions
Amanda Livingston	amandal@fairlife.com	Client	2026-06-09
Winston Jones	caffeinestix@gmail.com	Client	2026-04-23

Client name	Email (portal login)	Contact	Added	Actions
Winston's Blueberries	caffeinestix@gmail.com	Winston Jones	2026-04-23

Connect your database

No orders found

No orders found

No clients yet

Connect your database

No orders found

No orders found

No clients yet

New order

Analyte results

Order details

Add user

Add client