Hackathon-NL2SQL

Overview

Hackathon-NL2SQL is a project that converts natural language queries into SQL queries, allowing users to interact with their databases using simple text inputs.

Features

• Node.js with EJS templating for rendering dynamic web pages.
• Google Gemini API integration for query understanding and processing.
• SQL database support for executing and retrieving query results.
• Connect to your local database and execute SQL queries effortlessly.
• Formatted result output including a table displaying query results.

Installation

# Clone the repository
git clone https://github.com/AnupDangi/Hackathon-NL2SQL.git
cd Hackathon-NL2SQL

# Install dependencies
npm install

Usage

1. Start the application:

   npm server.js

2. Open your browser and navigate to http://localhost:3000.
3. Enter a natural language query, and the system will generate and execute the corresponding SQL query.
4. View results in a structured table format.

API Integration

• This project integrates Google Gemini API for natural language query processing.
• Ensure you have a valid API key and configure it in your environment.

Contributing

Feel free to contribute to this project by submitting issues or pull requests!

License

This project is licensed under the MIT License.

##Output Results

For more details, visit the repository: Hackathon-NL2SQL.