InsightAI Agent
Ask questions over business data and review the query, chart, and explanation.
A natural language analytics concept for turning business questions into governed queries, generated charts, and readable explanations.
Architecture preview
Project Preview
Visual context for the case study.
This preview image represents the portfolio's AI engineering work and gives the project page an accessible visual asset for search and sharing.
Problem
Teams need faster analytical answers, but raw text-to-SQL flows can be unsafe, opaque, and hard to trust without schema awareness and reviewable reasoning.
Solution
InsightAI Agent uses a governed analytics flow: understand intent, map schema, generate a checked query, render visual output, and explain the result in plain language.
Timeline
Schema grounding, query flow, dashboard UX, report generation.
Architecture
System design decisions.
Features
- Natural language question input.
- Generated SQL with reviewable query preview.
- Chart recommendations and short summaries.
- Dataset-aware constraints and prompt templates.
Challenges
- Constraining query generation to known schema and allowed operations.
- Making generated insights explainable instead of magical.
- Designing the product for analysts and non-technical operators.
Results and signals
- Designed for traceable question-to-query workflows.
- Prioritizes governed analytics over unrestricted chatbot behavior.
- Supports future evaluation on query validity and answer usefulness.
Future roadmap
- Add dataset connectors and permission-aware semantic layers.
- Introduce query evaluation test sets.
- Build reusable executive report templates.
Tech stack
Project FAQ
Concise answers about InsightAI Agent.
What is InsightAI Agent?
A natural language analytics concept for turning business questions into governed queries, generated charts, and readable explanations.
What problem does InsightAI Agent solve?
Teams need faster analytical answers, but raw text-to-SQL flows can be unsafe, opaque, and hard to trust without schema awareness and reviewable reasoning.
What technologies are used in InsightAI Agent?
Python, FastAPI, Next.js, PostgreSQL, OpenAI, Vector Databases, RAG
Can recruiters view InsightAI Agent code or request a demo?
A GitHub link is provided. A demo request link is provided.
Related projects
Business automation
Multi-Agent Business Automation Platform
Human-reviewed automation for sales, support, and reporting operations.
Enterprise AI
Unscript One — AI-Native Enterprise Workspace
RAG, AI Agents, MCP, Guardrails, and LLM Evaluation unified into one production-oriented workspace.
Education technology
AI Teacher Robot
Classroom assistant with face recognition attendance, speech interaction, and knowledge retrieval.
Discuss this project with Ubaith Sherif.
The demo links use email where no public deployment URL has been provided, keeping the portfolio honest while still giving recruiters a direct path to request access.