Text Summarizer Background

Natural Lnaguage to SQL query generator

A locally hosted Natural Language to SQL Query Generator that enables non-technical users to query internal databases securely using plain English. Built with CodeLlama and advanced NLP techniques, it streamlines data access and reduces reliance on technical teams.

Overview

This project is an AI-powered Natural Language to SQL Query Generator designed for a company where non-technical teams, such as marketing and growth, struggled to retrieve data from internal databases. These teams often relied on technical analysts to write SQL queries, causing delays and bottlenecks in decision-making. The tool allows any team member—regardless of technical background—to interact with the database simply by asking questions in plain English. It then generates accurate and executable SQL queries automatically. This significantly reduces the time and dependency involved in data access, empowering non-technical users and freeing up analysts for more strategic work. The project is still under development and being designed to run locally and securely, without exposing internal company databases to external cloud-based AI services.

My Role & Contributions

This project was initiated based on a real-world problem shared by a friend working in a marketing team in India. I took complete ownership of the project, from ideation to implementation. My responsibilities included:

Tech Stack

Python FastAPI LangGraph LangChain CodeLlama 7B Cosine Similarity BM25 Ollama Streamlit Docker AWS EC2 LangChain SQLDatabase Agent

Implementation Details

Swagger UI 1 Swagger UI 2

Results & Impact

While the project is still under development, early testing shows promising results:

View on GitHub