Technical demonstration

Français

AI assistant for querying internal data

Designed and built by Benie Kimpuela, Web & AI Development student, Efrei

I built this web application to query, in plain language, a sample film database holding 11,696 films from Wikidata, which I host in the cloud. The AI turns requests into SQL queries, runs them against the database, and produces an answer using only the information available in it.

The goal is to show how an AI can be connected to internal data while keeping control over how that data is used and keeping it confidential. Film data is only a demonstrator here: the same architecture applies to company data such as customers, orders, stock, finance or internal documentation.

  1. 1

    Question in plain language

  2. 2

    The AI writes a SQL query

  3. 3

    Python queries, PostgreSQL allows reads only

  4. 4

    The AI writes the answer

The AI cannot change or delete anything: it can only read the information it is allowed to see. Every request is checked before it runs.

Example questions