🚀 AskDB.AI — Natural Language to SQL AI Assistant

AskDB.AI is an AI-powered data assistant that allows users to query their databases using plain English.
Built with LangGraph, LangChain, and FastAPI, it transforms natural language queries into SQL, executes them, summarizes insights, and even visualizes results — all in one workflow.

---

🧠 Features

• 💬 Natural Language → SQL Query Generation
• 🧾 Automatic Query Execution & Summarization
• 📊 Visualization Planning (JSON or Graph)
• 💾 Session Persistence using SQLite Checkpointer
• 🧱 Modular Multi-node Graph (Intent Parser → SQL Generator → Executor → Summarizer → Visualizer)
• 🌙 Clean Dark UI built with React + ShadCN/UI + TailwindCSS
• 🔥 Full-Stack Deployment ready (FastAPI backend, React frontend)

---

🧩 Tech Stack

Layer	Tools Used
AI Orchestration	LangGraph, LangChain, OpenAI
Backend	FastAPI, SQLiteSaver (LangGraph Checkpointer)
Database Engine	DuckDB, Pandas
Frontend	React (Vite), ShadCN/UI, TailwindCSS
Deployment	Render (Backend), Vercel (Frontend)

---

🧱 Architecture Overview

graph TD;
  A[User Query] --> B[Intent Parser Node]
  B --> C[SQL Generator Node]
  C --> D[SQL Executor Node]
  D --> E[Summarizer Node]
  E --> F[Visualizer Node]
  F --> G[Frontend Response]

Loading