Home / Lovable / Booking and scheduling
The Lovable Booking App Kit is a complete, staged build plan for an appointment booking product in Lovable: a public booking page with service, person and time selection, a staff calendar, client records, deposits, reminders and a private page where customers reschedule or cancel. Scheduling is the kind of app where small mistakes become double bookings and lost revenue, so the 14 prompts are written around the hard parts: time zones and daylight saving, concurrency, holds, money and abuse.
The included data-model.sql does the work most AI builds skip. An exclusion constraint makes overlapping bookings for one person impossible, slot search runs in Postgres in the business time zone so DST is handled correctly, and temporary holds expire automatically. Reschedule, cancel and payment-confirmation logic live in service-role functions that run as single transactions, manage links are stored only as hashes, and row level security keeps customers, staff and admins in their lanes.
Seed data creates a demo studio with four team members, split-shift hours and a dozen services and add-ons.
A clickable prototype of the finished product (public booking flow with a live availability engine and hold countdown, customer manage page, day and agenda calendar, services, team hours, clients and settings with embed snippets) is the visual spec, and a built-in pack browser lets you search, copy and tick off each prompt offline. This is a Pro kit because of the depth: concurrency tests, DST tests, Stripe deposits and a full launch checklist are included. Honest note: Lovable is an AI builder; test payments, time zones and permissions yourself before taking real bookings.
Highlights
- 14 staged prompts with verify checklists and troubleshooting
- Double booking impossible: exclusion constraint on staff and time range, plus 10-minute slot holds
- Availability engine in SQL (get_available_slots): split shifts, buffers, time off, notice and horizon, business time zone and DST safe
- Stripe deposits with idempotent webhook, auto-refund when a hold expired, and cancellation fee logic
- Customer manage links stored as hashes: atomic reschedule, cancel with fee policy, calendar (.ics) files
- Reminder outbox with pg_cron and Resend, waitlist that refills cancelled slots, embeddable widget
- Seed demo studio plus a clickable prototype (public flow, calendar, services, team, clients, settings)
- CC0: build and sell booking apps for clients with no attribution
mammoth templates


