A production-ready Telegram bot template with MySQL, Admin Panel & Command Handlers

---

✨ Features

• 🤖 aiogram 3.x — Modern async Telegram bot framework
• 🗄️ MySQL Database — Async connection pool via aiomysql
• 👑 Admin Panel — Ban/unban, broadcast, user info
• 🔐 Auth Middleware — Auto-registers users, blocks banned users
• 📋 Command Handlers — /start, /help, /me out of the box
• 🏗️ Clean Architecture — Modular handlers, middlewares, config

---

📁 Project Structure

telegram-bot-template/
├── main.py                  # Entry point
├── requirements.txt
├── .env.example
├── config/
│   └── settings.py          # All config from .env
├── database/
│   └── db.py                # MySQL pool + all queries
└── bot/
    ├── handlers/
    │   ├── start.py          # /start, /help
    │   ├── user.py           # /me
    │   └── admin.py          # /admin, /ban, /unban, /broadcast
    └── middlewares/
        └── auth.py           # Auto-register + ban check

---

⚡ Quick Start

1. Clone the repo

git clone https://github.com/algoanhaf/telegram-bot-template.git
cd telegram-bot-template

2. Install dependencies

pip install -r requirements.txt

3. Setup environment

cp .env.example .env
# Edit .env with your values

4. Create MySQL database

CREATE DATABASE telegram_bot;

5. Run the bot

python main.py

---

⚙️ Configuration (.env)

Variable	Description
BOT_TOKEN	Your bot token from @BotFather
ADMIN_IDS	Comma-separated admin Telegram IDs
DB_HOST	MySQL host (default: localhost)
DB_NAME	Database name
DB_USER	MySQL username
DB_PASSWORD	MySQL password

---

📋 Admin Commands

Command	Description
/admin	Show admin panel & stats
/ban <user_id>	Ban a user
/unban <user_id>	Unban a user
/userinfo <user_id>	Get user details
/broadcast <message>	Send message to all users

---

🗄️ Database Schema

users (id, username, first_name, last_name, is_banned, is_admin, joined_at, last_seen)
messages_log (id, user_id, command, text, created_at)

Tables are auto-created on first run.

---

💼 Need a Custom Bot?

Built something cool with this template? Need a fully custom bot for your business?

---

Made with ❤️ by ALGOANHAF

⭐ Star this repo if it helped you!