DataGenie 1

What it does

DataGenie is an innovative app designed to simplify the way users interact with databases. The app allows users to input queries in plain English, which are then translated into SQL queries, making database interaction accessible even to those without SQL knowledge. This functionality is powered by Google’s Gemini API, which handles the natural language processing (NLP) tasks.

How it works:
Users enter a query in natural language, such as “Show all customers who made a purchase last month.” The app sends this input to the Gemini API, which processes the text and converts it into an accurate SQL query. The backend, built with Flask, then executes this query against a SQLite database, retrieving the requested data. The results are displayed to the user in a clean, user-friendly interface created with Flutter.

Gemini API Integration:
We utilized the Gemini API to handle the NLP aspects, ensuring that even complex queries are correctly interpreted and converted into SQL. The API’s advanced language model capabilities allow DataGenie to understand a wide range of query structures, making it a powerful tool for non-technical users.

Future Plans:
We plan to enhance DataGenie by integrating support for online databases like Oracle, adding functionality for altering and creating tables, and improving the overall user experience with data visualization tools.