Link UI: 203.194.113.195 (if it doesn’t work, hit me up probably the openai credit need to add balance)

1. Overview

This project is an AI-powered multi-database analytics platform that enables users to:

• Query multiple heterogeneous databases using natural language.
• Generate interactive visualizations (charts, plots) directly from queries.
• Produce comprehensive PDF reports automatically, complete with charts, analysis, and insights.
• Integrate new databases dynamically by simply providing metadata, no need for hard-coded connections.

Use Cases:

• Business Intelligence & E-Commerce Analytics
• Climate & Environmental Data Analysis
• Disaster Research & Emergency Response Planning

2. High-Level Architecture

Workflow Summary:

1. User submits a query via Streamlit UI.
2. SmartRouter determines whether to route the query to:
   • SQL Agent → Direct data analysis & visualization.
   • Report Generator Agent → Full PDF report creation.
   • Scheduling / reminders / task history → Scheduler Agent
3. SQL Agent dynamically accesses the relevant database(s).
4. Report Generator Agent retrieves data via the SQL Agent, creates visualizations, and compiles a PDF report.
5. Results are returned as interactive visualizations in the UI or downloadable PDF reports.

3. Agent Architecture