African intelligence AI
# Kekeli — African Data Intelligence Agent 🌍
> **Anti-hallucination AI agent for African official data**
> Built for the Google Cloud Rapid Agent Hackathon — **Fivetran Track**
## What is Kekeli?
Kekeli is an AI agent that answers questions about African countries using **only real, verified data** — never hallucinated statistics. It queries 73,940 rows of official data synchronized by Fivetran from 80+ African sources into BigQuery.
Every answer cites the source and year: `[Source: IMF, imf_economic_stats, 2023]`
## Architecture
```
User Question
│
▼
Google ADK Agent (Gemini 3.1 Flash Lite)
│
├── BigQuery Tool ──► titan-ia-497117.titan_african_data (73K rows)
│ IMF · WHO · FAO · World Bank · UNICEF · UNHCR
│ CKAN · NADA · NASA Climate · GeoData
│
└── Fivetran Tools ──► Pipeline monitoring & sync control
80+ African official sources
Connector: varieties_rigged → BigQuery
```
## Data Sources (via Fivetran pipeline)
| Table | Source | Content |
|-------|--------|---------|
| `imf_economic_stats` | IMF | GDP, inflation, debt — 54 African countries 2000-2024 |
| `who_health_stats` | WHO | Life expectancy, mortality, vaccination |
| `world_bank_indicators` | World Bank | 50+ macro indicators |
| `fao_agriculture` | FAO | Agricultural production, food security |
| `unicef_indicators` | UNICEF | Education, child health, nutrition |
| `unhcr_displacement` | UNHCR | Refugees, forced displacement |
| `ckan_datasets` | HUMDATA + openAFRICA | 3,215 open data catalogs |
| `nada_microdata` | NBS·KNBS·GSS·ANSD·DataFirst | 1,054 microdata archives |
| `geodata_layers` | GeoData Togo | 736 geospatial layers |
| `nasa_climate` | NASA GISTEMP | Temperature anomalies |
| `african_countries` | — | Reference: 54 countries, ISO codes, regions |
## Tools
### BigQuery Tools
- `query_bigquery(sql)` — Execute SQL on `titan_african_data`
- `list_available_tables()` — Catalog of all 15 tables
### Fivetran Tools (REST API)
- `check_pipeline_st …