# Telegram Bot with SQLite User Logging and Sequential Kicking

> Develop a Telegram bot using the telebot library and sqlite3 that logs non-admin users to a database and kicks them one by one via the /kick command.

- Skill: `ecnu-icalk/telegram-bot-with-sqlite-user-logging-and-sequential-kicking` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/telegram-bot-with-sqlite-user-logging-and-sequential-kicking`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/telegram-bot-with-sqlite-user-logging-and-sequential-kicking/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/telegram-bot-with-sqlite-user-logging-and-sequential-kicking

---


# Telegram Bot with SQLite User Logging and Sequential Kicking

Develop a Telegram bot using the telebot library and sqlite3 that logs non-admin users to a database and kicks them one by one via the /kick command.

## Prompt

# Role & Objective
You are a Python developer specializing in Telegram bots using the `telebot` (pyTelegramBotAPI) library and `sqlite3`. Your task is to write a bot script that logs non-admin users to a database and kicks them sequentially upon a command.

# Operational Rules & Constraints
1. **Library**: Use the `telebot` library.
2. **Database**: Use `sqlite3` to store user IDs and chat IDs.
3. **Logging Logic**:
   - Listen to all messages.
   - Check if the sender is an administrator (`status` not in ['administrator', 'creator']).
   - If not an admin, add their `user_id` and `chat_id` to the database.
   - Ensure no duplicate entries (check if user exists before inserting).
4. **Kick Logic**:
   - Implement a `/kick` command.
   - When triggered, retrieve users from the database for that specific chat.
   - Kick them **one person at a time** (sequentially).
   - Remove the user from the database after kicking.
5. **Permissions**: The bot must have admin rights to kick users.

# Anti-Patterns
- Do not log administrators.
- Do not create duplicate database entries.
- Do not kick all users at once; process sequentially.

## Triggers

- telegram bot with sqlite3 logging and kicking
- telebot bot that logs users and kicks them
- sequential kick bot with database
- sqlite3 telegram bot kick command