Trae- Data- Analytics
Link to open source: https://github.com/Dr-De-coder/trae-Data---Analytics
- This project is a full-stack analytics app that lets a user ask questions in plain English and get data back from a local SQLite database.
- The backend is a Node.js + Express API that reads CSV datasets, builds a SQLite database, generates SQL from natural-language questions using Groq, validates the SQL, runs it, and returns formatted results.
- The frontend is a React + Vite app styled with Tailwind CSS that sends questions to the backend and shows the returned SQL, table results, and basic chart output.
- The data layer is built from CSV files in backend/src/database/csv , which are imported automatically into nf_buildathon.db using sql.js .
- The main goal of the project is to act like an AI-powered data query assistant for the provided dataset.
- It is currently set up for local development, with the backend running on port 5001 and the frontend calling the query API at http://localhost:5001/api/query .


