Natural_language_to_SQL

This repository contains a code file written in Python to build a web application for converting natural language query to a SQL query using LLM calls. The sql query will then be performed on the database and th query results will be displayed on screen in tabular format for better clarity and understanding. Additionally, there is a "Download results as csv" button which will allow the users to download the obtained query results in form of a csv. The application is deployed in the form of a simple website built using HTML, CSS and JavaScript for frontend and uses Python-Flask at backend. The LLM used is google-gemini-pro model.

Screenshots

Installation

To run this project in your laptop:

git clone [email protected]:riddhi-283/Natural_language_to_SQL.git

Setting-up the application

Creating Database

Open Mysql Workbench in your local machines and create a database "atliq_tshirts" using the sql code file provided. Make sure that the MySQL server is running on your laptop while running this application.

Setting up LLM model

Get your free google-api key from "makersuite.google.com"
Create a .env file and paste your google api key.

GOOGLE_API_KEY=''

Running the application

pip install -r requirements.txt
python app.py