Auto Care On Wheels
Automated car service booking, scheduling confirmations, and dispatch management.
A complete full-stack car service booking platform deployed for a real commercial mechanic business. The platform automates customer scheduling, booking confirmations, and administrative service dispatch.
The Context
Operating a mobile automotive mechanic service requires coordinating customer locations, vehicle specifications, technician availability, and service packages. Auto Care On Wheels was commissioned to transition an established automotive repair business from manual phone and paper bookings to a modern, automated online dispatch platform.
Core Constraints & Failure Modes
Manual booking via phone calls created severe scheduling bottlenecks during peak driving hours: double-booked time slots, missed inquiries, lack of structured vehicle detail collection, and delayed customer confirmations. Administrative staff spent hours daily manually re-typing job orders into calendars.
Architectural Solution
We engineered a full-stack booking system pairing a customer-facing appointment scheduling interface with an administrative dispatch portal. The client interface dynamically queries mechanic availability, enforces slot validation, and collects vehicle details (make, model, year, service type). Bookings are processed through an Express API and committed via Prisma ORM to MySQL, triggering automated confirmation alerts and administrative dashboard updates.
Verified Scope & Lifecycle Boundaries
Strict truth in engineering: we clearly separate what is functional in code, what is bounded by prototype scope, and what represents future architectural roadmap.
- Full-stack web application built with React 18 and Vite for fast client rendering
- Interactive calendar booking with dynamic date and time availability querying
- Express.js REST API handling booking validation, scheduling constraints, and status updates
- Prisma ORM schema modeling customers, appointments, service tiers, and vehicle data
- MySQL database managing appointment persistence and scheduling transactions
- Administrative control portal for viewing, confirming, and dispatching incoming jobs
- Automated booking notification workflow dispatched upon reservation confirmation
- Live production deployment and DNS configuration on Hostinger infrastructure
- Commercial production deployment live in the Australian market (autocareonwheels.com.au)
- Single-business operational tenancy configured for current mechanic fleet
- SMS gateway integration for two-way customer arrival reminders
- Technician mobile progressive web app (PWA) with real-time GPS route dispatch
- Integrated automated invoicing with Stripe / Square terminal reconciliation
System Topology & Component Decomposition
Customer Interface → Appointment Availability → Booking API → Prisma ORM → MySQL, with an administrative dispatch layer.
Customer Scheduling Canvas
React 18 / Vite / Tailwind CSSInteractive booking workflow allowing vehicle owners to select services, inspect time slot availability, and submit service reservations.
Booking & Availability API
Node.js / Express.js / CORSValidates incoming appointment requests, verifies technician slot availability, and commits reservations with transaction locks.
Prisma & MySQL Persistence Layer
Prisma ORM / MySQLStrict relational database modeling customers, vehicle specs, service logs, and dispatch states.
Administrative Dispatch Portal
React / REST API / HostingerSecured management dashboard for the commercial business owner to review, reschedule, and dispatch service technicians.
Critical Architectural Choices
Prisma ORM for Strict Data Integrity
Booking systems require strict relational guarantees between customers, vehicles, and appointment times to prevent orphaned records.
Prisma's typed schema enforces foreign key constraints and eliminates type drift between the backend API and database migrations.
Vite + React 18 for Instant Mobile Loading
Automotive service inquiries predominantly originate on mobile devices by stranded drivers or roadside owners.
Sub-second initial client bundles with Vite deliver immediate interactivity even on mobile cellular connections.
Complete Technology Stack
Interested in deploying a similar architecture or commissioning a custom digital engineering engagement based on this system pattern?