last updated 4/18/2024
Creating an English to SQL query generator using OpenAI API. User needs to give the table names and a specific query request, as well as load in the data, Lang2SQL will return the corresponding SQL query.
How to run this?
- a) It's recommended to set up a virtual enviornment in Python and have all required packages installed there.
- i) For how to set virtual env up, refer to Virtual Environment Setup.txt
- ii) All required packages are under .devcontainer
- b) You will need to request an api_key from OpenAI API, here is how
- c) Download the datasets and store the .csv files under a folder "data"
2021
2022
2023 - d) Now run code in Code.ipynb
Inspired by the project by Rami Krispin