PracticeMate: Real-Time Patient Flow Without a Spreadsheet

Published 2026-08-17 by Faraz Rahimi

A role-based clinic dashboard for reception and nursing. Color-coded patient status, tablet-friendly updates, and Postgres RLS so staff only see what their job needs.

PracticeMate: Real-Time Patient Flow Without a Spreadsheet

Tags: Next.js, Supabase, Healthcare, TypeScript, RLS

PracticeMate is a clinic operations dashboard I built so reception and nursing stop coordinating patient status on paper, group chats, and a shared spreadsheet that is already stale.

The job is not "another EHR." The job is answering, in one glance: who is here, who is waiting, who is with the doctor, and who can go home.

What it is for

Front desk staff check patients in. Nurses move them through the room. Everyone else needs to see the same board without logging into five tools.

Color-coded patient flow board at the reception desk.

Statuses are color-coded on purpose: checked in, awaiting doctor, in session, ready for checkout. The board is the product. If you cannot read it from across the desk, it failed.

Nurses do not sit at the reception PC. They need a phone or tablet in the hallway. The UI is mobile-first Tailwind so a status tap is one thumb, not a form.

How it technically works

The stack is Next.js 14 (App Router), React 18, TypeScript, and Supabase for auth and Postgres.

Authentication is split by role. Receptionists sign in with email and password. Nurses use short access codes so a shared tablet does not become a password manager. Both paths land in the same app with different grants.

Row Level Security and database triggers enforce that split. A nurse can update flow status. They cannot browse another clinic's roster. A receptionist can check people in. They cannot impersonate a clinical update. The policy lives in Postgres, not in a if (role) check that a client can skip.

Realtime subscriptions keep the board live. When a nurse taps "awaiting doctor," the reception monitor moves the card without a refresh. That is the whole point of not using a spreadsheet.

A nurse updating patient status from a hallway tablet.

The live clinic build is at drhashemi.netlify.app. The source is on GitHub.

Original post: https://farazrahimi.com/posts/practicemate-clinic-patient-flow