- This is streamlit based app that enables users to input text in plain english and generate corresponding SQL query code, along with an example of the output and an explanation of the generated code.
- The app have the workflow shown in the image below, where the user provides a prompt, and Gemini Pro (LLM) interprets it, then generates a SQL query and returns a response.
To get started, install the necessary packages using pip install as follows:
pip install google-generativeai streamlit
Run the streamlit app in your terminal
streamlit run text_to_sql_app.py