AI-powered data analysis SaaS application. Upload your data, ask questions in natural language, and get insights with visualizations.
┌───────────────────┐ ┌───────────────────┐
│ FRONTEND │ │ SUPABASE │
│ Next.js • React │ │ Auth • DB • S3 │
└─────────┬─────────┘ └─────────┬─────────┘
│ │
└─────────────┬─────────────┘
│
▼
┌───────────────────────────────────────────────────────────────────────────┐
│ BACKEND (FastAPI) │
│ ┌─────────────────────────────────────────────────────────────────────┐ │
│ │ AI AGENT SERVICE │ │
│ │ │ │
│ │ ┌───────────────────────────────────────────────────────────┐ │ │
│ │ │ OpenAI Agents SDK │ │ │
│ │ │ │ │ │
│ │ │ ┌─────────────────────────────────────────────────┐ │ │ │
│ │ │ │ AGENTIC LOOP (ReAct) │ │ │ │
│ │ │ │ │ │ │ │
│ │ │ │ User Query ──▶ THINK ──▶ ACT ──▶ OBSERVE ─┐ │ │ │ │
│ │ │ │ ▲ │ │ │ │ │
│ │ │ │ └─────────────────────────┘ │ │ │ │
│ │ │ │ (repeat until done) │ │ │ │
│ │ │ └─────────────────────────────────────────────────┘ │ │ │
│ │ │ │ │ │ │
│ │ │ ▼ │ │ │
│ │ │ ┌─────────────────────────────────────────────────┐ │ │ │
│ │ │ │ TOOLS │ │ │ │
│ │ │ │ ┌─────────┐ ┌────────────┐ ┌──────────────┐ │ │ │ │
│ │ │ │ │ File │ │ Analysis │ │Visualization │ │ │ │ │
│ │ │ │ │ Tools │ │ Tools │ │ Tools │ │ │ │ │
│ │ │ │ └─────────┘ └────────────┘ └──────────────┘ │ │ │ │
│ │ │ └─────────────────────────────────────────────────┘ │ │ │
│ │ └───────────────────────────────────────────────────────────┘ │ │
│ └─────────────────────────────────────────────────────────────────────┘ │
└───────────────────────────────────────────────────────────────────────────┘
│
▼
┌───────────────────────┐
│ OpenAI API │
│ (GPT-4o) │
└───────────────────────┘
The core intelligence is an Agentic AI built with the OpenAI Agents SDK, powered by GPT-4o.
| Concept | Description |
|---|---|
| LLM Backbone | GPT-4o provides reasoning, natural language understanding, and decision-making |
| Tool Use / Function Calling | Agent can invoke Python functions to interact with data and generate visualizations |
| ReAct Pattern | Agent iteratively Reasons about the task, Acts by calling tools, and Observes results |
| Agentic Loop | Autonomous multi-step execution until the task is complete |
| Prompt Engineering | System instructions guide agent behavior, capabilities, and response format |
The agent has access to 11 tools across 3 categories:
- File Tools - Load datasets, inspect schemas, list available files
- Analysis Tools - Statistical summaries, filtering, grouping, correlations
- Visualization Tools - Bar charts, line charts, histograms, scatter plots, pie charts
Tools are Python functions with the @function_tool decorator. The SDK automatically generates JSON schemas from type hints and docstrings for the LLM.
| Feature | Description |
|---|---|
| More File Formats | Support for JSON, Parquet, Google Sheets, and direct database connections |
| Advanced Chart Types | Heatmaps, box plots, geographic maps, treemaps, and interactive dashboards |
| Export Reports as PDF | Generate downloadable PDF reports with charts and analysis summaries |
| Advanced Analytics | Time series forecasting, anomaly detection, clustering, and predictive modeling |
| Natural Language to SQL | Preview the generated SQL queries before execution for transparency and learning |