Enhancing Relational Database Agents with Retrieval Augmented Generation (RAG)

In the GDSC7 challenge, I tackled the issue of reducing API costs while preserving answer quality in agent systems. The solution involved implementing semantic search to efficiently handle gender-related queries without explicit gender columns in the database. By using embeddings for all string columns and combining questions with answers, we minimized unnecessary database queries, enhancing system efficiency and reducing costs.