A Flask-based app provides a unified interface for working with multiple databases (MySQL, MongoDB) and natural language query processing.

• Natural Language to SQL Query conversion
• Multi-database support:
  • MySQL
  • MongoDB
  • Firebase Realtime Database (Only for upload)
• File import support (CSV/JSON) for all databases
• Database table information retrieval
• Query translation between different database systems

1. Install dependencies from requirements.txt:

• pip install -r requirements.txt

2. Start the Flask server:

• python run.py

3. Download spaCy language model:

• python -m spacy download en_core_web_sm

1. Navigate to the Frontend Directory

• cd react_frontend/frontend

2. Install Dependencies

• npm install

3. Run the Development Server

• npm start

• POST /analyze - Convert natural language to SQL queries

• GET /mysql/test - Test MySQL connection
• POST /sql/create - Create/modify tables from CSV/JSON files
• POST /sql/read - Execute SQL queries

• POST /mongodb/create - Upload data from CSV/JSON files
• POST /mongodb/read - Execute MongoDB queries
• Supports both raw MongoDB queries and MySQL-like queries

• GET /firebase/test - Test Firebase connection
• POST /firebase/create - Upload data from CSV/JSON files
• POST /firebase/read - Read data from specific Firebase paths

• GET /tables-info - Retrieve comprehensive information about tables and collections from all connected databases

backend/
├── app/
│ ├── routes.py # Main API endpoints and database operations
│ ├── mysql_connect.py # MySQL database connection configuration
│ ├── firebase_connect.py # Firebase database connection setup
│ ├── mongodb_connect.py # MongoDB connection configuration
├── venv/ # Python virtual environment
├── requirements.txt # Python dependencies
├── run.py # Flask application entry point
frontend/
├── src/
│ ├── components/ # React components (UI elements like buttons, forms, and tables)
│ ├── services/ # API service calls (e.g., connecting to backend endpoints)
│ ├── utils/ 
│ ├── App.css # CSS styles for the application
│ ├── App.js # Main React component for the app
│ ├── firebase_query.js # Firebase-related queries
│ ├── index.css # Root-level styles
│ ├── index.js # Application entry point for React DOM rendering
│ ├── setupTests.js # Test setup for React testing library
├── public/ # Static assets (HTML templates, public images, etc.)
├── package.json # Node.js dependencies and project configuration
├── package-lock.json # Locked versions of dependencies to ensure reproducible builds