A secure, efficient, and comprehensive visitor tracking solution for modern facilities — built with Express.js, PostgreSQL, and a beautiful responsive UI.
Streamline visitor operations from check-in to check-out with a full suite of management tools.
Register new visitors or quickly check in returning ones. Auto-detects returning visitors with full visit history display.
Real-time stats for active visitors, today's visits, overstays, and blacklisted visitors with auto-refresh every 30 seconds.
Three distinct roles — Admin, Receptionist, and Security — each with tailored permissions and restricted page access.
Flag and block suspicious visitors. Blacklisted visitors are automatically denied check-in with logged audit trails.
Automatic status update via database triggers when visitors exceed their expected checkout time.
Verification logs, visit session reports with date/status filters, pagination, and complete audit trail visibility.
Track visitor vehicles with parking slot assignment, vehicle type, and number plate recording.
Admin panel to create, edit, toggle, and manage system users with password management and profile controls.
Deployed on Vercel with Neon PostgreSQL — serverless architecture with zero-config scaling.
A seamless process from arrival to departure.
Upon arrival, the receptionist or security guard creates a new visit session. Returning visitors are instantly recognized, speeding up the process, while new visitors provide their details and vehicle information.
The system cross-references the visitor against the blacklist. If clear, they are assigned a host, the visit is logged, and they are granted entry to specific areas of the facility.
During the visit, the system tracks the session duration. Overstays trigger automated alerts. Upon departure, the visitor is checked out, and the session is archived in the audit logs for future reporting.
Built with modern, battle-tested technologies.
Fine-grained permissions ensure every user sees only what they need.
| Capability | Admin | Receptionist | Security |
|---|---|---|---|
| Dashboard | ✅ | ✅ | ✅ |
| Check-In Visitors | ✅ | ✅ | ❌ |
| Check-Out Visitors | ✅ | ✅ | ❌ |
| View Visitor List | ✅ | ✅ | ✅ |
| Edit / Delete Visitors | ✅ | ✅ (edit) | ❌ |
| Blacklist Management | ✅ | ❌ | ❌ |
| Reports & Logs | ✅ | ❌ | ❌ |
| User Management | ✅ | ❌ | ❌ |
Normalized schema with triggers, stored procedures, and views for data integrity.
USER_ACCOUNT · VISITOR · VISIT_SESSION · VEHICLE — manage the primary entities of the system.
VERIFICATION_LOG · BLACKLIST_LOG · SYSTEM_SETTINGS — complete audit trail with automatic trigger-based logging.
5 Triggers (auto check-in/out logging, overstay detection, blacklist tracking) + 4 Stored Procedures + 3 Views.
Log in with demo credentials and experience the full system.