Chat2Data is a Streamlit-based AI-powered app that lets you ask questions in natural language and get accurate SQL-generated insights from a global economic dataset.
It uses Google Gemini (via Gemini Pro) to convert plain English into SQL queries and executes them against a SQLite database built from a Kaggle dataset.
- Source: Kaggle
- Topic: Global Economic Indicators
- Years Covered: 2010 to 2025
- ✅ Ask questions like “Top 5 countries by GDP in 2020”
- ✅ Powered by Gemini Pro for Text-to-SQL generation
- ✅ Displays generated SQL queries
- ✅ Executes queries against SQLite DB
- ✅ Interactive result table (via
pandas+ Streamlit) - ✅ Query history log (for successful queries only)
Check out the Webapp: Chat2Data
- "Which countries had the highest GDP in 2020?"
- "List the top 5 countries by GDP growth in 2022."
- "Show unemployment rates in India from 2015 to 2020."
- "Compare public debt between United States and China in 2018."
- "What was the average inflation for the United Arab Emirates over the last decade?"
- Kaggle for the dataset
- Google Gemini for the Text-to-SQL model
- Streamlit for the frontend framework