AI-Powered Smart SQL Query Generator

Full Stack AI Developer Needed — Natural Language to SQL System (QueryAI) We are building QueryAI, an internal business intelligence tool that allows non-technical users to query live databases using plain English. The system uses LLMs to convert natural language into SQL, executes queries on MSSQL, and returns results with AI-generated explanations and charts. The system architecture, UI screens, module breakdown, and flow diagrams are fully finalized. We need a skilled developer to implement it. Project Goal: Build a production-ready web application where users type questions like "Show total sales by region last month" and receive instant SQL results, charts, and a plain-English explanation — without writing any SQL. What Needs to Be Built: 1. AI / LLM Layer • Natural language → SQL conversion using OpenAI API or local LLM • Semantic caching using embeddings to avoid redundant LLM calls • Pattern-based query fallback logic • AI-generated human-readable explanation of results 2. Backend (Python FastAPI) • REST API for all modules • JWT-based authentication • OTP password reset via Gmail SMTP • SQL safety validation before execution • Role-based access control (Admin / User) 3. Database Layer • Live query execution on Microsoft SQL Server (MSSQL) • MySQL for storing users, sessions, chat history, activity logs 4. Frontend (React.js) • Chat-based interface (similar to ChatGPT UI) • Session history + favorites/saved queries • Chart rendering: Bar, Line, Pie • Admin panel with full management controls 5. Admin Panel • Manage users (add, edit, delete, reset password) • User activity dashboard (track all queries, status, timestamps) • Manage AI prompts and metadata • Manage subject areas and table schema context Expected Deliverables: • Fully working QueryAI web application • Backend API (Python FastAPI) • React frontend with chat UI and admin panel • LLM integration with semantic cache • Live MSSQL query execution • Chart generation module • JWT auth + OTP system • Clean codebase with documentation Ideal Candidate: • Strong experience in Python (FastAPI) and React.js • Has worked with OpenAI API or LLM integration before • Familiar with MSSQL / SQL Server • Understands JWT authentication and role-based systems • Can deliver clean, maintainable code Please include in your proposal: 1. Relevant projects you have built (AI or full stack) 2. Your experience with LLM/OpenAI API integration 3. How you would approach the NL to SQL conversion 4. Estimated timeline and milestones 5. Any challenges you foresee and how you would handle them Full UI screens and architecture diagrams will be shared with shortlisted candidates.