Skip to content

Ahla22-19/SQL-Query-Agent-with-Manual-Safety-Check

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

GEMINI SQL Query Agent

Python Streamlit License: MIT

🌟 Description

GEMINI SQL Query Agent is a Streamlit-powered AI assistant for querying a student database.
You can ask questions in natural language, and the AI generates safe SQL queries and returns results directly in the app.

This project ensures your database queries are safe while providing a friendly, ChatGPT-like interface.


🚀 Features

  • Ask natural language questions about your student database
  • AI generates safe SQL queries
  • Results are displayed instantly in the Streamlit app
  • Beautiful and clean user interface

🛠️ Installation

  1. Clone the repository:
    git clone https://github.com/Ahla22-19/SQL-Query-Agent-with-Manual-Safety-Check.git
    cd SQL-Query-Agent-with-Manual-Safety-Check
    
  2. Create virtual environment:
    python -m venv venv
    
  3. Activate virtual environment:
    venv\Scripts\activate
    
  4. Install dependencies:
    pip install -r requirements.txt
    

💻 Usage

Run the Streamlit app:

streamlit run app.py



## 📂 Project Structure

 ├─ app.py                  # Main Streamlit app
 ├─ sql.py                  # SQL helper functions / database interactions
 ├─ requirements.txt        # Python dependencies
 ├─ README.md               # Project documentation
 ├─ .gitignore              # Git ignore rules
 └─ venv/                   # Virtual environment folder

## ⚡ License

This project is licensed under the MIT License. See the LICENSE file for details.





About

AI assistant that converts natural language to safe SQL queries using Gemini API

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages