WanderWithDevesh is a web application that transforms natural language queries into SQL queries, executes them, and displays user-friendly responses. This tool simplifies database interactions for users who may not be familiar with SQL syntax.
- Natural Language Processing: Convert natural language questions into executable SQL queries.
- Query Execution: Run SQL queries directly from natural language input.
- Results Formatting: Display results in a human-readable format.
- Interactive Explainer: Visual flow from natural language question to SQL query to formatted answer.
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.
- Prerequisites
- Node.js
- React
- FastAPI
- Uvicorn (for serving FastAPI)
- OpenAI API key (for natural language processing)
- Git clone the repository:
git clone https://github.com/deveshcode/shopping-multimodal-rag.git
cd shopping-multimodal-rag- Install the required packages:
cd frontend
npm install
cd ../backend
pip install -r requirements.txt- Create a .env file in the root directory and add your API keys:
OPENAI_API_KEY=your_openai_api_key- Start the backend server:
cd backend
uvicorn main:app --reload- Start the frontend development server
cd frontend
npm startOpen your browser and navigate to http://localhost:3000 to use the application.
To run the REST API server:
uvicorn app:app --host 0.0.0.0 --port 8001 --reloadTo run the Streamlit app:
streamlit run app.pyOpen the provided URL in your web browser to access the application.
- Hey, Which Countries do you guys give tour packages in ?
- Oh Great, which cities in USA do you guys give tour for ?
- How many days for the Los Angeles tour ?
- And how much will Los Angeles cost me ?
- What’s the best cusine to try out in Paris ?
- How many days will I get in the Tour for city of Paris ?
- What's the package cost in Paris?
- Which all cities do you guys cover again ?
- Give me London City details ?
- How many days will I get in the city of Bali ?
Contributions are what make the open-source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.
Distributed under the MIT License. See LICENSE for more information.