CRM Genie : Natural Language to SQL Query generator

Our project aimed to convert natural language questions into accurate SQL queries. Initially, it could only generate basic queries and often struggled with correct column names. To improve this, we used a technique called Retrieval-Augmented Generation (RAG). We took all the column names from our database and created descriptions , split them into chunks, and converted them into embeddings to create a knowledge base. When the user types a query in plain English, the backend first identifies relevant column info using these embeddings. Then, it sends both the user input and the retrieved knowledge to the Gemini 2.5 Pro model to generate a precise SQL query. The generated query is run on a MySQL database, and the result is returned.