skip to content
Ayush Kedia | Portfolio
Table of Contents

View GitHub Repository | View Technical Report

Project Overview

Developed a Python-based NLP system that converts natural language into optimized SQL queries.The system uses a LlamaEmbedder for semantic understanding and a metadata structure to ensure schema-accurate generation.

Key Insights & Impact

NLP & LLM Engineering: Implemented embedding-based semantic understanding to map user intent directly to database schema elements. Schema Intelligence: Designed a layer that analyzes table relationships and metadata before constructing queries to ensure accuracy. Performance Optimization: Achieved 30–35% faster response times for complex joins and aggregations through schema-aware query rewriting. System Design: Built a modular pipeline architecture covering intent parsing, schema mapping, and query validation[cite: 21, 23].