# 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
```bash
Project repo: https://github.com/codeakki/TextToSQLUsingGENAI.git
```
### STEP 01- Create a conda environment after opening the repository
```bash
conda create -n venv python=3.9 -y
```
```bash
conda activate venv
```
### STEP 02- install the requirements
```bash
pip install -r requirements.txt
```
### Create a `.env` file in the root directory and add your Pinecone credentials as follows:
```ini
GOOGLE_API_KEY = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
```
```bash
# Finally run the following command
python app.py
```
Now,
```bash
open up localhost:
```
## Currently Sample table
## Sample
## HuggingFace
https://huggingface.co/spaces/codeakki/TextToSQLUsingGENAI/tree/main
### Techstack Used:
- Python
- Streamlit
- google-generativeai
- SqlLite