Vaccination Management System

Abstract

Managing vaccination records across a country\'s population is a complex logistical challenge, particularly when paper-based systems remain common. The Vaccination Management System (VMS) is a full-stack, web-based Vaccination Database Management System (VDBMS) built with Python Flask and MySQL that digitizes and streamlines the entire vaccination lifecycle. The system supports three distinct user roles — patient, administrator, and vaccine administrator — each with tailored dashboards and functionality. Core features include appointment scheduling, profile management for multiple family members, digital certificate generation with QR code verification, AI-powered chat support, vaccine inventory management, and real-time analytics. This paper presents the system design, relational database architecture, feature set, and implementation details of the Vaccination Management System, demonstrating how modern web technologies and AI integration can address real-world healthcare management challenges.

Introduction

The Vaccination Management System is a web-based healthcare platform designed to digitize and simplify vaccination tracking, appointment scheduling, and certificate management. It addresses problems in traditional paper-based systems such as lost records, duplication, and difficulty in tracking immunization history.

Built using Flask (backend), MySQL (database), and HTML/CSS/JavaScript (frontend), the system follows a three-tier architecture and supports role-based access for patients, system administrators, and vaccine administrators. Patients can manage family profiles, book appointments based on real-time vaccine availability, view vaccination history, and download QR-coded digital certificates for verification.

A key feature is an integrated AI chatbot (Groq API) that provides real-time answers about vaccines, side effects, and scheduling, reducing workload on healthcare staff. Administrators manage centers, vaccines, schedules, and analytics, while vaccine staff handle inventory and on-site operations.

Security is ensured through hashed passwords, secure sessions, SSL-encrypted database access, and CSRF protection, with strict server-side role enforcement. The system is deployed on a public cloud platform and is designed to be scalable and self-hostable.

Conclusion

The Vaccination Management System addresses a genuine gap in healthcare infrastructure by providing a complete, open-source, web-based vaccination management system that is immediately deployable. By combining a well-designed relational database, secure authentication, role-based access control, digital certificate generation, and AI-powered support, the platform offers a level of functionality typically associated with enterprise healthcare software — but at zero licensing cost. The system is built with extensibility in mind. Future work will explore the addition of appointment reminder notifications, integration with national immunization databases, multilingual support for broader accessibility, and a mobile application for patients in low-connectivity environments. This system is a step toward a world where every person has immediate, reliable access to their vaccination history and can interact with the healthcare system on their own terms. The codebase is open for contributions at https://github.com/dattaaaaa/vaxcare.

References

[1] World Health Organization, \"Vaccination and trust: How concerns arise and the role of communication in mitigating crises,\" WHO Europe Policy Summary, 2017. [2] R. Dombkowski, K. Lantz, and G. Freed, \"Role for Health Information Exchange in Immunization Registries,\" Am. J. Manag. Care, vol. 10, pp. 67–74, 2004. [3] A. Laranjo et al., \"Conversational agents in healthcare: a systematic review,\" J. Am. Med. Inform. Assoc., vol. 25, no. 9, pp. 1248–1258, Sep. 2018. [4] M. Grinberg, Flask Web Development, 2nd ed. Sebastopol, CA: O\'Reilly Media, 2018. [5] ReportLab Inc., \"ReportLab PDF Library User Guide,\" [Online]. Available: https://www.reportlab.com/docs/reportlab-userguide.pdf [6] Groq Inc., \"Groq API Documentation,\" [Online]. Available: https://console.groq.com/docs [7] Vaccination Management System GitHub Repository. [Online]. Available: https://github.com/dattaaaaa/vaxcare

Copyright

Copyright © 2026 Rashmi Mishra, Prerna Sahane, Komal Yadav, Muskan Yadav, Prof. Pratiksha Shinde. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.