Doctor & Clinic Booking App with Live Queue

Description
Doctor & Clinic Booking is a production-ready React Native (Expo Router) template with a real Supabase backend — Postgres, Auth, Row Level Security, and Realtime, not a static UI shell.
The standout feature: a live queue view. Once clinic staff check a patient in, everyone still waiting sees their queue position and estimated wait time update automatically, with no refresh, powered by a database function that recalculates the queue every time someone ahead is checked in or completed.
Three roles are built in — patient, doctor (fixed roster), and staff — each with their own real screens, not stubs. Patients browse doctors, book open slots, and track their live status. Staff check patients in and mark visits complete from a dedicated queue screen. Everything is wired to real, working demo data out of the box.
Features
- Live queue position + estimated wait time via Supabase Realtime — updates automatically, no manual refresh - Three real user roles: patient, doctor (fixed roster), staff/receptionist - Slot-based appointment booking with race-condition-safe database functions (no double-bookings) - Staff check-in / complete-visit flow that drives the live queue for every waiting patient - Full Row Level Security — every write goes through a SECURITY DEFINER Postgres function, not open table access - Light and dark mode throughout, built on a proper design-token system - Working demo data: 4 doctors, 2 staff, 18 patients, seeded appointments in every queue state - Clean, documented Expo Router file structure — no dead code, no unused stubs
Requirements
- Node.js and npm - A free Supabase account (Postgres + Auth + Realtime, all on the free tier) - Expo Go app for testing, or an Expo dev build for production
Instructions
1. Create a Supabase project. 2. In the Supabase SQL Editor, run supabase/schema.sql, then supabase/seed.sql — in that exact order. 3. Copy .env.example to .env and add your Supabase project URL and anon key. 4. Run npm install, then npx expo start. 5. Sign in with any seeded demo account (see README.md for the full list) or create a new account.
Full setup details, demo account credentials, and project structure are documented in README.md.
| Author | U25 |
|---|---|
| Category | App Templates / React |
| Price | $54 |
| Extended License | $162 |
| Likes | 1 |
| First Release | Aug 16, 2026 |
| Last Update | Aug 16, 2026 |
| Files included | .sql, JavaScript .js |
| Operating systems | Android 8.0, Android 9.0, Android 10.0, iOS 14.0, iOS 13.0, iOS 15.0, Android 11.0, Android 12.0 |
Categories
Tags
External listing. code.market does not sell this product and does not process payment for it. Pricing, payment, delivery, licensing, refunds, and support are handled by the third-party merchant on its own website. We may earn an affiliate commission from a referral. Details.
Products of the Week.
Submit🥇
Perceptle
Perceptle is a daily browser-based game that challenges you to test your sensory intuition through five quick estimation and rhythm-based rounds.
Other · 1,489 views · 9 clicksOther · Week 47 · 1,489 views · 9 clicks
🥈
Free LinkedIn Likes From Real
Get free LinkedIn likes on your posts from real members who react by hand. No
SaaS · 1,632 views · 10 clicksSaaS · Week 47 · 1,632 views · 10 clicks
🥉
STOP GUESSING WHAT TO POST
AI that learns your brand voice and builds a month of consistent, on-brand social content: carousels, posts and hooks that sound like you, not like everyone else's AI.
SaaS · 9,176 views · 75 clicksSaaS · Week 47 · 9,176 views · 75 clicks
#4
aaas.market
407 reliable micro tools for solo founders, marketers and creators. They work in your browser
SaaS · 1,597 views · 5 clicksSaaS · Week 47 · 1,597 views · 5 clicks