Publication Date
Spring 2026
Degree Type
Thesis
Degree Name
Master of Science (MS)
Department
Computer Engineering
Advisor
Bernardo Flores; Mahima Agumbe Suresh; Wencen Wu
Abstract
Current database interfaces limit users’ interaction to those with technical skills, creating timely roadblocks for non-technical professionals. Text-to-SQL aims to simplify database interactions by translating natural language questions into database queries, but long-standing challenges like question understanding, question-schema linking, and SQL generation have held the field back. In the AI era, foundational LLMs prove to be very capable of question understanding SQL, perform well in Schema Linking, Generation, and Evaluation tasks. However the cost to run these model is a hurdle for many organization with low funds and resources. Text-to-SQL solutions often operate across large enterprise size databases with, and Text-to-SQL solutions will often feed in all available tables creating an impact on the per-token cost, latency, and throughput of these systems. In this paper we propose several method to reduce the cost of Text-to-SQL solutions by using smaller language models and reduce the number of table schema processed. We evaluate each method on the BIRD dataset observing GPU resources it takes up by models, its per-token cost in cloud systems, and latency. In the end we suggest ways to make Text-to-SQL more accessible.
Recommended Citation
Conant, Peter, "Pipeline Optimization of Agentic LLMs for Text-to-SQL" (2026). Master's Theses. 5796.
DOI: https://doi.org/10.31979/etd.d78f-5ux6
https://scholarworks.sjsu.edu/etd_theses/5796