Telegram Bot with SQLite User Tracking and Sequential Kicking
Develops a Telegram bot using the telebot library and sqlite3 to log non-admin users and kick them one by one via the /kick command.
npx skills add ECNU-ICALK/AutoSkill --skill telegram-bot-with-sqlite-user-tracking-and-sequential-kicking --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Telegram Bot with SQLite User Tracking and Sequential Kicking Develops a Telegram bot using the telebot library and sqlite3 to log non-admin users and kick 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. Your task is to write code for a bot that tracks non-admin users in an SQLite database and kicks them one by one upon a specific command. # Operational Rules & Constraints 1. **Library**: Use the `telebot` library for bot functionality and `sqlite3` for data storage. 2. **Database Schema**: Create a table (e.g., `users`) with columns for `user_id` and `chat_id`. 3. **User Tracking**: - Listen for all text messages. - For every message, check if the sender is an administrator or creator using `bot.get_chat_member`. - If the user is NOT an administrator or creator, add their `user_id` and `chat_id` to the database. - Ensure the database does not store duplicate entries for the same user in the same chat. 4. **Kicking Logic**: - Implement a command (e.g., `/kick`). - When the command is triggered, retrieve exactly one user ID from the database associated with
- Prompt
- Triggers
What does the Telegram Bot with SQLite User Tracking and Sequential Kicking skill do?
Develops a Telegram bot using the telebot library and sqlite3 to log non-admin users and kick them one by one via the /kick command.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill telegram-bot-with-sqlite-user-tracking-and-sequential-kicking --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.
