Personal project · 2025 to 2026

DataBot: your AI-powered data science assistant

An AI assistant that connects to your databases and files, writes and runs the analysis code, builds and evaluates models, and saves you hours of development. Every project follows CRISP-DM: you keep the expertise and the decisions, and every step is recorded in a notebook.

Subscriptions for the same calls
+40%
AUC on future campaigns
0.65
Automated tests
≈ 330
  • GPT-5.1
  • GPT-5.4
  • LangChain
  • LangGraph
  • FastAPI
  • React
  • DuckDB
  • Docker

In 90 seconds

Excerpts of the two full demos shown below, in real order: questions and their charts, the Arabic interface, a prediction project and its evaluation charts, then an unknown database, a challenged and corrected mistake, and the final report.

DataBot's code is private: the demos, the notebook and the report published on this page are the evidence.

The problem

Companies have more data than people to analyse it, and generic AI assistants give answers nobody can check. What was missing was a tool that works like a data scientist, quickly, but under the control of a skilled person.

Architecture

Interface
React web appFrench, English, Arabic; accounts and roles
Notebook and reportsAll the work as .ipynb and PDF
Server
FastAPI APIAuthentication, live step tracking
Agent
LangGraph agentGPT-5.1; picks its own tools
CRISP-DM phasesOne report per phase, approved by the user
MemoryLessons learned from user feedback
Tools
Read-only SQLPostgreSQL, MySQL, SQLite
FilesCSV, Excel, Parquet with DuckDB
Isolated PythonSession in Docker
Charts and reportsFigures, PDF, deliverable files

Simplified diagram, drawn by me.

My approach

  • A single agent that picks its own tools: SQL queries, Python code, charts, reports, files.
  • Read-only access to the sources (PostgreSQL, MySQL, SQLite, CSV, Excel, Parquet): it can never change the data.
  • An isolated Python session in Docker, where it writes and runs its code and installs the libraries it needs.
  • Modelling projects follow CRISP-DM: each phase produces a report (findings, decisions, limits) and only closes when the user approves, skips or sends it back.
  • All its work is visible live and downloadable (.ipynb notebook and PDF).
  • It learns from feedback: a commented thumbs-down becomes a lesson it reuses later.
  • A web interface in French, English and Arabic, with accounts, roles and about 330 automated tests.

Demo 1: prediction

A real recording of the platform: connecting a MySQL database and an Excel file, then a full prediction project on public bank data, with the evaluation charts.

See the full notebook DataBot produced, on Kaggle

Demo 1 results

Subscriptions for the same number of calls
+40%
Of subscribers reached with a third of the calls
47%
AUC on unseen campaigns
0.646
Automated tests
≈ 330

Demo project on UCI Bank Marketing (45,211 calls, May 2008 to November 2010): predict which clients will subscribe to a term deposit. The model was trained on the oldest campaigns and evaluated on the most recent ones, in real time order: calling the top-ranked third of clients yields 1,267 subscriptions instead of about 889 at random. To put the 0.646 AUC in context: this version of the dataset has no economic indicators, and on the same data and the same test period, reference models (random forest, gradient boosting, logistic regression) score between 0.64 and 0.67. Higher published scores come from easier conditions: a random split that mixes past and future, a version enriched with macroeconomic indicators, or the call duration, only known after the call, which the agent spotted and excluded on its own.

Gains curve
Gains curve: share of subscribers reached by share of clients called
ROC curve
ROC curve on the most recent campaigns (AUC 0.646)
DataBot project page: the six approved CRISP-DM phases
The project page: each phase approved by the user, with its decisions and deliverables

Second demo: another domain

A real recording, in order, sped up only while DataBot computes. A 9-table PostgreSQL database it had never seen (Olist, Brazilian e-commerce, about 100,000 orders), questions in English, a business rule, then a CRISP-DM project without prediction: understand bad reviews, group the complaints written in Portuguese and segment the sellers. It also shows DataBot getting a definition wrong in its final report, then fixing it as soon as I challenge it.

Bad reviews when delivered over 7 days late
78%
Bad reviews when delivered on time
9%
Seller segment stability (30 reruns)
0.94
Answers I checked, no follow-up needed
5 / 5
  • Classic traps avoided on its own: real customers (96,096, not 99,441), incomplete months, duplicate reviews, amounts inflated by joins.
  • Portuguese comments grouped into 7 readable complaint themes, validated by an automatic topic model (NMF).
  • Explanatory models (logistic regression, odds ratios), their robustness checked separately on 2017 and 2018.
  • Before recording, I computed and froze the reference answers myself; every figure checked matches.

See the full notebook, unedited · See the PDF report DataBot wrote · Download the notebook (zipped .ipynb)

Data: Olist, Brazilian E-Commerce Public Dataset (Kaggle), CC BY-NC-SA 4.0 license. The notebook and report are shared under the same license.

Ready for public deployment

I prepared DataBot so that it can be opened to anyone on the internet, without the server paying for its users' AI or taking risks with the code they ask it to run.

  • Open accounts. Anyone can sign up, confirmed by a code sent by email; everyone can export or delete all their data at any time.
  • Everyone brings their own AI key. OpenAI, Anthropic, Google, Azure, Groq or OpenRouter: the key is tested before it is accepted, stored encrypted and never shown again. The server never uses a key of its own: no valid key, no workspace.
  • Isolated code. Each conversation runs its Python code in its own container, with no internet and no privileges, with limits on memory, time and processes, and a queue when the server is busy.
  • Protected connections. A database is accepted only if it is on the internet: the server's internal addresses are refused before any connection is made.
  • Proven by tests. About 70 dedicated tests, including real attacks launched from inside a container (network, other users' files, privilege escalation, process bomb): all blocked.

Deployment-ready (server configuration, HTTPS and guide included), but not hosted publicly yet because of hosting costs. Live demo available on request.

Limits

DataBot is built to assist a data scientist, not to replace one: supervision is what makes it reliable. During the demo, some steps were challenged, notably the time-ordered validation and a first model file that needed fixing; each time, the phase stayed open until it was corrected.

In demo 2, after an automatic summary of the long conversation, it first counted lateness in whole days in the final report instead of the business rule; it acknowledged and fixed it as soon as I pointed it out. Definitions decided during a project should be kept outside the summary.

The quality of its work also depends on the language model used.

No isolation is perfect: on a public server, the system and Docker must be kept up to date, and nothing else of value should run on it.