Text-to-SQL Generative AI with Google Gemini API

This project demonstrates how to use the Google Gemini API to convert natural language text into SQL queries using Python. The application is designed to take user input in the form of natural language queries and return the corresponding SQL statements, facilitating easier interaction with databases.

Before you begin, ensure you have met the following requirements:

You have Python 3.7 or later installed on your local machine.
You have a Google Cloud account with access to the Google Gemini API.
You have set up authentication for Google Cloud and obtained the necessary API credentials.


git clone https://github.com/your-username/text-to-sql-gemini.git


cd text-to-sql-gemini


pip install -r requirements.txt

Ensure that you have your Google Cloud service account key file. Set the environment variable to point to your service account key file:


export GOOGLE_APPLICATION_CREDENTIALS="/path/to/your/service-account-file.json"

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
venv		venv
.env		.env
NLP.ipynb		NLP.ipynb
README.md		README.md
requirment.txt		requirment.txt
sql.py		sql.py
sqlite.py		sqlite.py
student		student
student.db		student.db