AI Powered Data Analysis Agent — NLP to SQL Dashboard Automation Full Stack Dev

We are looking to develop a smart web-based assistant powered by AI agents that can understand natural language queries, generate SQL, execute them, and automatically visualize the results.
The goal: to make data analysis as simple as asking a question.
Example: “Compare chocolate sales across regions over the last 3 months.”

Deliverables

Frontend UI: Clean, intuitive interface with prompt box and chart output.
AI Agent with capabilities to:
Interpret natural language input
Retrieve and ingest data (CSV/API/Database)
Generate dynamic SQL schema if needed
Produce executable SQL queries securely
Visualize the result with charts + summary
Automated Dashboard: Generate visual output (e.g., bar, line, pie charts) from results.
Activity Logging System: Every AI decision, query, error, and user action must be logged.
Documentation: Developer documentation + user guide.


Suggested Tech Stack

Frontend: React, Next.js, TailwindCSS or Streamlit
Backend: Python (FastAPI) or Node.js
AI/NLP: OpenAI API (GPT-4o), LangChain, Text2SQL models
Databases: DuckDB, PostgreSQL, or SQLite
Visualization: Plotly, ECharts, or similar
ETL Sources: CSVs, JSON, REST APIs
Logging/Monitoring: Streamlit logs, OpenTelemetry, or custom JSON logs