Visa Monitor Bot
ActiveServerless appointment-slot monitor for Australian visa applications — sends real-time alerts when new slots open, built on Playwright, Vercel Cron, and Supabase.
Tech Stack
Visa appointment slots at Australian consulates are released sporadically and disappear within minutes. This bot checks the visa portal every five minutes via a Vercel Cron job, uses Playwright in headless mode to navigate the authenticated booking flow, and stores slot metadata in Supabase.
When a new slot is detected that matches user-defined criteria (date range, visa type, location), the system dispatches notifications via Telegram Bot API and email. A lightweight Next.js dashboard displays the run history, success/failure status, and detected slots — accessible through Payload CMS's tool-run collection.
The project introduced practical constraints around bot detection avoidance, session token refresh, and rate-limit safe polling intervals, resulting in a robust monitoring pattern reusable for other appointment-based systems.
Other Projects
Internal data cataloguing and lineage platform integrating dbt, Metabase, and Supabase to give a 200-person org a single source of truth for 300+ data assets.
A collection of SQL scripts, pgBadger dashboards, and Python automation tools for diagnosing and resolving slow-query issues in high-traffic PostgreSQL clusters.
Enterprise-grade bidirectional data pipeline connecting NetSuite ERP and Boomi AtomSphere, processing 50 k+ transactions per day with sub-3 s latency.