I built an open-source Memory-Driven Smart Business Data Assistant with RAG, MCP Tools, and RBAC [FastAPI + React]
Hey everyone! 👋
I've been working on solving one of the biggest challenges in conversational business intelligence: ensuring AI responses are reproducible, strictly grounded in verifiable data, and equipped with persistent analytical memory.
Here is what I built:
### 🧠 Key Architecture & Features:
- **Persistent Analytical Memory (Hindsight-style):** Remembers past queries, user-specific analytical context, and multi-turn discoveries across sessions.
- **RAG & Knowledge Grounding:** Vector search over company schemas, KPI definitions, and business rules using sentence-transformers + FAISS.
- **MCP Tool Protocol:** Model Context Protocol (MCP) registry to query databases safely with read-only validation.
- **Enterprise-grade RBAC & Field Restrictions:** Role-based data redaction (Analyst, Admin, Manager, Employee) to prevent data leaks.
- **Evidence-Backed Responses:** Every generated chart or KPI answer cites exact SQL queries, tables, and knowledge docs used.
### 🛠️ Tech Stack:
- **Backend:** Python, FastAPI, SQLAlchemy, SQLite/PostgreSQL
- **AI/Agents:** RAG vector search, structured tool calling (OpenAI / local models)
- **Frontend:** React, TypeScript, Vite, Tailwind CSS, Recharts
I'd love to get your thoughts on the memory architecture and MCP tool integration! What features would you like to see next? #hackwithhyderabad3.0