A Web-Based Data Summarization System Integrating Large Language Models (LLM) and Spreadsheet Data Using the Model Context Protocol (MCP)
DOI:
https://doi.org/10.22303/csrid-.18.2.2026.300-319Keywords:
Data Summary, Large Language Models, Model Context Protocol, ISO/IEC 25010, Normalized GainAbstract
Asset management in information technology at the IT Division of PT Pertamina Hulu Rokan currently faces scalability challenges due to reliance on conventional manual spreadsheet-based processes in managing approximately 30,000 asset data. This condition triggers the risk of human error, data redundancy, and time inefficiency in preparing asset condition recapitulation reports. This study aims to design a website-based Data Summary System that integrates Large Language Models (LLM) technology and spreadsheet data through the use of the Model Context Protocol (MCP) as a form of secure and scalable integration standard. System development was also carried out using a two-iteration prototype method, with Microsoft Azure infrastructure, the FastAPI framework (Python) on the backend side, and React.js on the frontend side. System quality testing was carried out based on the ISO/IEC 25010 standard which covers the eight main characteristics. The test results showed 100% achievement in the functional suitability aspect and the highest rating (Rating A) in the reliability, maintainability, and security aspects using SonarQube analysis. In terms of performance, the system demonstrated high responsiveness with a GTMetrix score of 100% and a usability level of 80.9 (Good category) on the System Usability Scale (SUS). The effectiveness of the system was tested through a One-Group Pretest Posttest experimental design on 8 IT employee respondents. The analysis results showed a good increase in productivity with a Normalized Gain value of 0.91 (High category) and an effectiveness percentage reaching 91.48% (Effective category). Therefore, this Data Summary System has proven successful in minimizing repetitive work steps and increasing accuracy and speed in managing IT assets at PT Pertamina Hulu Rokan.
References
Nawassyarif, Julkarnain, M., & Amanda, R. K. (2020). Sistem Informasi Pengolahan Data Ternak Unit Pelaksana Teknis Produksi Dan Kesehatan Hewan Berbasis Web. Jurnal JINTEKS, 2(1).
El-Kassas, W. S., Salama, C. R., Rafea, A. A., & Mohamed, H. K. (2021). Automatic text summarization: A comprehensive survey. In Expert Systems with Applications (Vol. 165). Elsevier Ltd. https://doi.org/10.1016/j.eswa.2020.113679.
Zaenuddin, I., & Bani Riyan, A. (2024). Perkembangan Kecerdasan Buatan (AI) Dan Dampaknya Pada Dunia Teknologi. Jurnal Informatika Utama, 2(2), 128–153.
Felandry, D., Haq, M., & Farras, R. (2022b). Implementasi Good Corporate Governance Dalam Kerjasama Antara PT Pertamina Hulu Rokan Dan PT Patra Drilling Contractor Di Kecamatan Mandau Kabupaten Bengkalis Provinsi Riau. Jotika Research in Business Law, 1(2), 93–106.
Sapardi, Hadikristanto, W., & Kurniadi, N. T. (2023). Implementasi Pengembangan Aplikasi Sistem Manajemen Aset Berbasis Web Menggunakan Metode Waterfall Untuk Mengoptimalkan Penggunaan Aset Pada PT. Hutama Karya (Persero). Jurnal Teknologi Dan Sistem Informasi Bisnis, 5(4), 401–408. https://doi.org/10.47233/jteksis.v5i4.948.
Prayoga H, E., & Nugroho, A. (2025). Perancangan Sistem Ringkasan Materi Perkuliahan Menggunakan Artificial Intelligence Berbasis Web. Journal STEKOM, 18(1).
Mu’alifah, E., Farisa, S., & Haviana, C. (2025). Perancangan Sistem Peringkasan Artikel Ilmiah Menggunakan Grobid Dan Large Langguage Models (LLM) Berbasis Scibert. Jurnal Rekayasa Sistem Informasi Dan Teknologi, 2(3).
Singh, A., Ehtesham, A., Kumar, S., & Khoei, T. T. (2025). A Survey of the Model Context Protocol (MCP): Standardizing Context to Enhance Large Language Models (LLMs). https://doi.org/10.20944/preprints202504.0245.v1
Albert, V., & Pramudya, F. (2024). Application of Artificial Intelligence Technology to Improve Responsiveness and Speed of Operations in Organizations. Prosiding Seminar Nasional Ilmu Manajemen, Ekonomi, Keuangan Dan Bisnis, 3(2), 145–164. https://doi.org/10.55927/snimekb.v3i2.12645.
Sugiyono, & Lestari, P. (2021). Buku Metode Penelitian Komunikasi (1st ed.). Alfabeta.
Anisa, F., & Hadiwandra, T. Y. (2024). Rancang Bangun Aplikasi Android Pengenalan Pembelahan Sel Menggunakan Teknologi Augmented Reality Markerless. Jurnal CoSciTech (Computer Science and Information Technology), 5(3), 493–501. https://doi.org/10.37859/coscitech.v5i3.7922
Rosabel Ramli, F., Hakim, F., & Anggelina Hutabarat, R. (2021). Perancangan Web Design Aplikasi E-Learning dengan Metode Prototype pada Tingkat SMA. Majalah Ilmiah UPI YPTK, 28(1), 13–18. https://doi.org/10.35134/jmi.v28i1.62.
Ichwani, R., Lestari, R. P., & Ramdan, M. (2021). Pengembangan Sistem Informasi Akademik Berbasis Web Menggunakan Metode Prototipe. Jurnal Imiah Rekayasa Dan Manajemen Sistem Informasi, 7(1), 11–20.
Dako, R. D. R., & Ridwan, W. (2021). Pengujian karakteristik Functional Suitability dan Performance Efficiency tesadaptif.net. Jambura Journal of Electrical and Electronics Engineering, 2(3). https://app.loadimpact.com.
Meilina, S. T., Susilo, E., & Sari, D. M. (2026). Rancang Bangun Aplikasi Reservasi Bimbingan Akademik Berbasis Website Pada Program Studi Teknik Informatika Universitas Riau. CSRID Journal, 18(1). https://doi.org/https://doi.org/10.22303/csrid-.18.1.2026.113-134
Krisbudiana, M. F. I., & Susilo, E. (2023). Employee Attendance Application Using QR Code Android-Based at Eria Hospital Pekanbaru. International Journal of Electrical, Energy and Power System Engineering, 6(1), 113–119. http://www.ijeepse.id
Sanatang, Baso Kaswar, A., & Jamila. (2022). Pengembangan Sistem Informasi Kepegawaian SMA Negeri 2 Polewali Berbasis Web. INTEC Journal: Information Technology Education Journal, 1(3).
Susila, A. A. N. H., & Arsa, D. M. S. (2023). Analisis System Usability Scale (SUS) Dan Perancangan Sistem Self Service Pemesanan Menu Di Restoran Berbasis Web. Majalah Ilmiah UNIKOM, 21(1), 3–8.
Ponda, I. S., Permady, Y. T., & Supriadi, Y. N. (2023). Analisis Faktor-Faktor Yang Mempengaruhi Harga Saham Perusahaan Sektor Energi. Jurnal Ilmiah Metansi (Manajemen Dan Akuntansi), 6(2), 183–191. https://doi.org/10.57093/metansi.v6i2.203.
Agustine, D. A. D., Hakimah, N., & Nurmayanti, R. (2023). Edukasi Keamanan Pangan terhadap Tingkat Pengetahuan dan Sikap Penjamah Makanan di Catering Pondok Sawah Kecamatan Turen Food Safety Education on Knowledge Levels and Attitudes of Food Handlers at Pondok Sawah Catering Turen. Nutriture Journal, 2(3), 145–154. https://doi.org/10.31290/nj.v2i3.4102.
Fauzy, F. I., Sumaryana, Y., & Sudiarjo, A. (2024). Pemanfaatan Teknologi Augmented Reality (AR) Sebagai Media Pembelajaran Interaktif Pengenalan Rumah Ibadah Umat Beragama Di Indonesia. Jurnal Mahasiswa Teknik Informatika, 8(4)
Febrinita, F. (2022). Pengembangan Modul Fisika Berbasis Kontekstual Untuk Meningkatkan Hasil Belajar Siswa. Jurnal Pendidikan Sains Indonesia, 10(3), 531–541.
