🇰🇭 Data Portal Bot

A Telegram bot providing real-time public data from Cambodia

---

📋 Overview

Data Portal Bot is an open-source Telegram bot that provides convenient access to Cambodia's public data through a simple chat interface. Get instant updates on air quality, weather, exchange rates, and stock market information - all from official public sources.

Data Sources:

• Air Quality Index from public monitoring stations
• Weather data from meteorological services
• Exchange rates from official financial sources
• Stock market data from Cambodia Securities Exchange (CSX)
• All data sourced from MEF Cambodia Open Data Portal

✨ Features

• 🌬️ Air Quality Index (AQI) - Real-time air quality monitoring
• 🌤️ Weather Data - Current weather conditions
• ☀️ UV Index - Sun exposure levels with safety tips
• 💱 Exchange Rates - USD/KHR and other currencies
• 📈 Stock Market - CSX index and market summary
• 📊 Economic Data - Public economic indicators
• 🐳 Docker Support - Easy containerized deployment
• 🔄 Auto-recovery - Automatic restart on failures
• 💾 Smart Caching - Efficient data caching (5-minute TTL)

📱 Available Commands

/start       - Open main menu
/aqi         - Air Quality Index
/weather     - Current weather
/uv          - UV Index
/exchange    - Exchange rates
/csx_index   - CSX stock index
/csx_summary - CSX market summary
/stats       - Bot statistics
/health      - Health status

🚀 Quick Start

Prerequisites

• Node.js 18 or higher
• PostgreSQL database (free options: Neon, Supabase)
• Telegram Bot Token from @BotFather

Installation

# 1. Clone repository
git clone https://github.com/im4tta/mefapibot.git
cd mefapibot

# 2. Install dependencies
npm install

# 3. Configure environment
cp .env.example .env
# Edit .env with your credentials

# 4. Initialize database
npm run init-db

# 5. Start bot
npm start

🔐 Configuration

Create a .env file with your credentials:

# Telegram Bot Token (required)
BOT_TOKEN=your_bot_token_from_botfather

# PostgreSQL Database URL (required)
DATABASE_URL=postgresql://user:password@host:5432/database

# Admin User IDs (optional)
ADMIN_USER_IDS=your_telegram_user_id

# API Configuration
MEF_API_URL=https://data.mef.gov.kh/api/v1

# Environment
NODE_ENV=production

Getting Credentials

1. Bot Token: Message @BotFather on Telegram

   • Send /newbot and follow prompts
   • Copy the token provided

2. Database: Get free PostgreSQL from:

   • Neon - Serverless PostgreSQL
   • Supabase - Open source alternative
   • Railway - Easy deployment

3. User ID: Message @userinfobot to get your Telegram ID

🐳 Docker Deployment

Using Docker Compose (Recommended)

cd docker
docker-compose up -d

# View logs
docker-compose logs -f

# Stop
docker-compose down

Using Docker Run

# Build
docker build -t data-portal-bot .

# Run
docker run -d \
  --name data-portal-bot \
  --env-file .env \
  -p 3000:3000 \
  data-portal-bot

Windows

cd docker
.\run-docker.bat

📁 Project Structure

mefapibot/
├── api/                    # API endpoints
│   ├── daily-broadcast.js # Scheduled broadcasts
│   ├── health.js          # Health check endpoint
│   ├── index.js           # Express server
│   ├── metrics.js         # Metrics endpoint
│   └── webhook.js         # Telegram webhook handler
├── docker/                 # Docker configuration
│   ├── docker-compose.yml
│   ├── run-docker.bat
│   └── stop-docker.bat
├── scenes/                 # Command handlers
│   ├── aqi.js             # Air quality commands
│   ├── economic.js        # Economic data commands
│   ├── exchange.js        # Exchange rate commands
│   └── weather.js         # Weather commands
├── scripts/                # Utility scripts
│   ├── init-db.js         # Database initialization
│   └── setup-webhook.js   # Webhook setup
├── admin.js                # Admin panel features
├── bot.js                  # Main bot entry point
├── bot-class.js            # Bot class implementation
├── database.js             # Database utilities
├── keyboards.js            # Telegram keyboard layouts
├── package.json            # Dependencies
├── Dockerfile              # Docker configuration
├── .env.example            # Environment template
└── README.md               # This file

🛠️ Development

Available Scripts

npm start              # Start the bot
npm run dev            # Development mode
npm run init-db        # Initialize database
npm run setup-webhook  # Configure webhook
npm run docker:build   # Build Docker image
npm run docker:run     # Run Docker container
npm run docker:stop    # Stop Docker container

Database

The bot uses PostgreSQL to store operational data. Initialize with:

npm run init-db

Privacy Note: This bot does not collect or store personal user data.

🔒 Security & Privacy

Data Privacy

• ✅ No personal data collection
• ✅ Public data sources only
• ✅ No user tracking or analytics
• ✅ Open source and transparent

Security Features

• Environment variables for sensitive config
• No hardcoded credentials
• Input validation
• Rate limiting on API calls
• Secure database connections (SSL)
• Error handling without exposing internals

Best Practices

• Keep bot token secure
• Use strong database passwords
• Enable SSL for database
• Keep dependencies updated: npm audit fix

� API Endpoints

When running, the bot exposes these endpoints:

• GET /api/health - Health check
• GET /api/metrics - Bot metrics
• POST /webhook - Telegram webhook (production)

🤝 Contributing

Contributions are welcome! To contribute:

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Test thoroughly
5. Submit a pull request

📝 License

This project is licensed under the MIT License - see LICENSE file.

🙏 Acknowledgments

• Data from MEF Cambodia Open Data Portal
• Built with Telegraf - Telegram Bot Framework
• Inspired by the need for accessible public data

📞 Support

• Issues: GitHub Issues
• Repository: github.com/im4tta/mefapibot

⚖️ Disclaimer

This bot provides information from public data sources for informational purposes only. The accuracy and availability of data depend on the source APIs. This is an independent project and is not officially affiliated with any government agency or data provider.

---

Made with ❤️ for Cambodia