Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : intech - informatika dan teknologi

Pengembangan Chatbot Perpustakaan Berbasis Retrieval-Augmented Generation (RAG) pada Telegram Tutu, Elrica Meriana Isabel; Pinontoan, Benny; Tenda, Edwin; Soewoeh, Christian A. J.; Takaendengan, Mahardika I.; Ngangi, Stephano C. W.
INTECH Vol. 7 No. 1 (2026): INTECH (Informatika Dan Teknologi)
Publisher : Informatics Study Program, Faculty of Engineering and Computers, Baturaja University

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.54895/intech.v7i1.3435

Abstract

The library of Sam Ratulangi University (UNSRAT) has a large collection of books and academic resources; however, users still experience difficulties in obtaining book availability information quickly and efficiently. This study aims to develop and evaluate a Telegram-based chatbot using a Retrieval-Augmented Generation (RAG) approach integrated with the GPT-4.1-mini Large Language Model (LLM). The system was developed using the Waterfall method and implemented through the n8n workflow automation platform by integrating Telegram Bot, MySQL, and Pinecone as a vector database. The chatbot applies a Text-to-SQL RAG mechanism, where user questions are converted into embeddings, matched with database context, and transformed into SQL queries limited to SELECT operations. System evaluation was conducted using Black Box Testing, User Acceptance Testing (UAT), and RAG evaluation metrics consisting of Answer Relevancy and Faithfulness. The results show that the chatbot successfully performs its main functions and achieved a UAT score of 82.3%, while Answer Relevancy and Faithfulness obtained scores of 100%. The developed system is capable of providing relevant and interactive information regarding library collections.
Co-Authors Aditya Lapu Kalua Alfonsius, Eric Alita, Debby Andreas Robert Langi , Yohanes Andreuw Vandy Lengkong Andrew Lengkong Andrew Lengkong Andria K. Wahyudi Aprilyani, Lilis Dwi Sapta Armando, Junando Arthur G. Pinaria Arundaa, Rillya Asalui, Darlene Syaroon Baba Barus Benny Pinontoan Benny Pinontoan Benny Pinontoan Bobby Polii Chriestie Ellyanne Juliet Clara Montolalu Chriestie Montolalu, Chriestie Christian A. J. Soewoeh Christian Alderi Jeffta Soewoeh Christian Soewoeh cindy Lahama Dedie Tooy Delon Daniel Wolayan Djoni Hatidja Dodisutarma Lapihu Dyah Ayu Megawaty Eliasta Ketaren Eliasta Ketaren Eliasta Ketaren, Eliasta Frangky J. Paat Gabriell Cristiano Agung Taroreh Imas Sukaesih Sitanggang Iqbal Firdaus Islam, Noorul Jantje Pongoh Juan Sebastian Sijron Lahope Kinzie Feliciano Pinontoan Lapihu, Dodisutarma Legi, Fabio Kevin Williams Lonteng, Alfa Luther Latumakulita Mahardika I. Takaendengan Mahardika Inra Takaendengan Mandagi, Franklin Megastin M. Lumembang Mongi, Charles Efraim Montolalu, Chriestie Ellyanne Clara Juliet Muhammad Saefudin Ngangi, Stephano C. W. Ngangi, Stephano Caesar Wenston Parluhutan Siahaan Pioh, Diane Prisilia Lumentah, Sweety Reymon Rotikan Rillya Arundaa Rinny Mamarimbing Samola, Jonathan Sandra Pakasi Sanriomi Sintaro Saroyo Saroyo Siska Ayu Widiana Soewoeh, Christian A. J. Soewoeh, Christian Alderi Jeffta Sofia Wantasen Sofiana Paendong, Marline Stenly Ibrahim Adam Stephano C. W. Ngangi Stephano Caesar Wenston Ngangi Stephano Caesar Wenston Ngangi Ngangi Takaendengan, Mahardika I. Takaendengan, Mahardika Inra Tambalean, Feergio Given Majesty Tohap Manurung Trianita, Maria Tutu, Elrica Meriana Isabel Wisard Kalengkongan Wisard Widsli Kalengkongan Wuaten, Frank Emmanuel