Natural Language to SQL Query Generator

This application allows users to generate SQL queries using natural language input. It connects to a database and provides an interface for users to ask questions in English, which are then converted into SQL queries and executed against the database.

Architecture

• Frontend:

  • Next.js for server-side rendering and API routes
  • Tailwind CSS for styling
  • Shadcn/UI for components

• Backend:

  • FastAPI for handling database connections and text-to-SQL conversion
  • OpenAI for text-to-SQL conversion

Installation

1. Clone the repository:

   git clone https://github.com/theGateway1/QueryWise-Frontend.git
   cd QueryWise-Frontend

2. Install frontend dependencies:

   npm install

3. Set up frontend environment variables: Create a .env.local file in the root directory and add:

   API_URL=http://localhost:8000  # FastAPI backend URL

4. Install backend dependencies:

• Clone the backend repository:

  git clone https://github.com/theGateway1/QueryWise-Backend.git
  cd QueryWise-Backend

2. Install backend dependencies:

   pip install -r requirements.txt

3. Set up backend environment variables: Create a .env file in the QueryWise-Backend directory and add necessary variables.

   OPENAI_API_KEY=<your-openai-api-key>

Usage

1. Start the FastAPI backend:

   cd QueryWise-Backend
   uvicorn main:app --reload

2. In a new terminal, start the Next.js frontend:

   npm run dev

3. Open http://localhost:3000 in your browser.

4. Enter your database credentials and click "Connect" to establish a database connection.

5. Enter a natural language query in the text area. Click "Generate SQL" to convert your query to SQL and execute it.