GeminiProLLMSQl

GeminiPro LLM converts natural language queries to SQL commands, GeminiPro generates SQL, executes it, and returns results. This simplifies data retrieval by eliminating the need for SQL expertise and streamlines database operations securely and efficiently.

How to run?

STEPS:

Clone the repository

Project repo: https://github.com/codeakki/TextToSQLUsingGENAI.git

STEP 01- Create a conda environment after opening the repository

conda create -n venv python=3.9 -y

conda activate venv

STEP 02- install the requirements

pip install -r requirements.txt

Create a .env file in the root directory and add your Pinecone credentials as follows:

GOOGLE_API_KEY = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"

# Finally run the following command
python app.py

Now,

open up localhost:

Currently Sample table

Sample

HuggingFace

https://huggingface.co/spaces/codeakki/TextToSQLUsingGENAI/tree/main

Techstack Used:

• Python
• Streamlit
• google-generativeai
• SqlLite