Skip to content

Latest commit

 

History

History
45 lines (33 loc) · 1.85 KB

README.md

File metadata and controls

45 lines (33 loc) · 1.85 KB
Raw

AI-QUERY-RESOLVER

This repository contains a streamlit app for querying any mysql/postgresql/mongodb database using natural language by leveraging the power of GEMINI-PRO Model. Combined.py contains a streamlit app that lets a user select a database among Mysql/ PostgreSQL/ MongoDB and query them using natural language. test_llm1.py, test_llm2.py, test_llm3.py are individual streamlit app that lets a user query Mysql, PostgreSQL and MongoDB database using natural language respectively.

Screenshots

Screenshot 2024-10-06 213854

Screenshot 2024-10-06 214445 Screenshot 2024-10-06 214455

Screenshot 2024-10-06 220529

Screenshot 2024-10-06 220556 Screenshot 2024-10-06 215640 Screenshot 2024-10-06 215653

Installation

To run this project in your laptop:

git clone [email protected]:riddhi-283/AI-QUERY-RESOLVER.git

Setting-up the application

Establishing connection

Make sure that the database server (which you want to use) is running on your local machine while running this application.

Setting up LLM model

Get your free google-api key from "makersuite.google.com"
Create a .env file in the same folder and paste your google api key.

GOOGLE_API_KEY=''

Running the application

pip install -r requirements.txt
streamlit run combined.py