/sql-llm

natural language to sql query with google gen ai

Primary LanguageJavaScript

SQL Query Generator

Overview

image

This project provides a web interface for generating SQL queries based on user questions about a PostgreSQL database. It includes a Node.js backend with Express and a frontend styled with Bootstrap. Users can ask questions, and the application generates and displays the corresponding SQL queries along with the results.

Features

  • Web interface built with Bootstrap for asking database-related questions.
  • Node.js backend using Express to handle requests and generate SQL queries.
  • Integration with PostgreSQL to execute SQL queries and return results.
  • Displays SQL queries and results in a formatted table on the web page.

Prerequisites

  • Node.js and npm installed on your machine.
  • PostgreSQL database with access credentials.
  • A .env file for environment variables.

Setup

  1. Clone the Repository:

    git clone https://github.com/BirajMainali/sql-llm.git
    cd sql-llm