Generate SQL

This is a web-based application designed to simplify the process of creating and managing SQL queries. With a user-friendly interface, this tool helps users generate SQL queries from natural language descriptions, making it easier to interact with databases without needing extensive SQL knowledge.

Features

• Natural Language to SQL Conversion: Convert descriptive queries into SQL statements seamlessly.
• Interactive Interface: User-friendly interface with a clean design for ease of use.
• Error Handling: Displays relevant error messages for invalid queries.

Installation

Prerequisites

• Node.js (>= 16.x)
• npm (>= 7.x)
• Vite (for development)

Clone the Repository

git clone https://github.com/Manjunathhs-0003/Generate-SQL.git
cd Generate-SQL

Setup

1. Install Dependencies

   npm install
   

2. Create a .env File

   Copy the example environment file and set up your OpenAI API key.

   cp .env.example .env
   

   Add your OpenAI API key in the .env file:

   OPENAI_API_KEY=your_openai_api_key_here
   

3. Run the Development Server

   npm run dev
   

   The application will be accessible at http://localhost:3002.

Usage

• Enter Query Description: Provide a natural language description of the query you need.
• Generate SQL: Click the "Generate" button to see the SQL query generated based on your description.
• Submit: Use the generated SQL query for your database operations.

Acknowledgements

• OpenAI API for the powerful natural language processing capabilities.
• Vite for fast and optimized development.