SQL Talker
Natural Language to SQL Assistant using Schema-Aware RAG
LLM and RAG assistant converting natural English questions into valid SQL queries with FAISS schema indexing and HuggingFace embeddings.
AI & Machine Learning, Backend Systems
2024 Development
LangChain • HuggingFace Embeddings
Cross-Platform
Problem, Solution & Engineering Scope
Operational Challenges & Cloud Fragility
Business stakeholders have to wait for data engineering teams to write ad-hoc SQL queries for routine operational metrics.
Offline-First Zero Latency Local Engine
Built a schema-aware RAG pipeline that accurately identifies relevant tables, joins, and aggregates to generate and run SQL autonomously.
- 1Schema-aware retrieval using FAISS vector indexing for precise column and table matching
- 2Converts natural language queries ('Which customer generated the most revenue in Q3?') into valid SQL
- 3Automated query syntax validation and safe read-only execution harness
- 4Interactive Streamlit dashboard visualizing SQL query results in real time
- Automotive Service Centers & Independent Garages
- Spare Parts Retailers & Inventory Managers
- Offline POS Operators needing Zero-Cloud Dependability
Key System Capabilities
Engineered features and deep architectural implementations.
Natural Language SQL Generation
Translates complex analytical questions into multi-table JOINs and GROUP BY queries.
FAISS Schema Indexing
Indexes table descriptions and column types, preventing context overflow on large database schemas.
Read-Only Security Guardrails
Restricts execution strictly to SELECT operations, preventing data modification or drops.
System Architecture & Engineering Design
The user's query is embedded using HuggingFace sentence transformers, compared against the FAISS index of database schemas, and supplied alongside the prompt to the language model to generate syntactically valid SQL queries.
Presentation Layer
User interface, client-side state handling, input sanitization, and responsive views.
Application Core
Core domain logic, transaction coordinator, validation pipeline, and IPC/API endpoints.
Persistence Layer
Normalized persistence layer with indexing, foreign key constraints, and transactional ACID safety.
External Services
Third-party APIs, asynchronous cloud synchronization, document generators, and external webhooks.
User interface, client-side state handling, input sanitization, and responsive views.
Core domain logic, transaction coordinator, validation pipeline, and IPC/API endpoints.
Normalized persistence layer with indexing, foreign key constraints, and transactional ACID safety.
Third-party APIs, asynchronous cloud synchronization, document generators, and external webhooks.
Technology Stack & Core Tooling
Selected languages, frameworks, runtime environments, and engines.
LangChain
Engineered architecture using LangChain
HuggingFace Embeddings
Engineered architecture using HuggingFace Embeddings
FAISS
Engineered architecture using FAISS
Python
Dynamic programming language utilized for data modeling, statistical ARIMA forecasting, and machine learning pipelines.
SQLite
Serverless, zero-configuration, transactional local SQL database with ACID guarantees and zero latency.
Streamlit
Engineered architecture using Streamlit
LLM APIs
Engineered architecture using LLM APIs
Engineering Challenges & Technical Solutions
Complex bottlenecks, concurrency hurdles, and architectural decisions resolved during development.
Constrained generation using strict schema context retrieved from FAISS and validated column names against SQLite metadata.
Individual Contributions & Architectural Ownership
Core development, system architecture, database schema, and delivery milestones.
Constructed the schema embedding and FAISS vector index pipeline
Engineered LangChain prompt templates and output parsers
Built the interactive UI with SQL preview, schema explorer, and data table rendering
Project Outcomes & Benchmarks
Empowered non-technical users to query relational data directly using conversational English with guaranteed schema correctness.
Explore Other Architectures
AutoBillDrive
Offline-first desktop billing application for Windows with SQLite persistence, automated PDF generation, Google Drive sync, and WhatsApp delivery.
EventApp
Production-ready event registration platform with Spring Boot 3.2, React 18, JWT RBAC, QR-code ticket generation, and async email confirmations.
