Twitch persistent counters via API Stream elements Chat commands

Job ID: 39941433

Budget: $30 – $250 USD

TWITCH and STREAM ELEMENTS PROJECT

I need multiple persistent counters, stored by Twitch user ID, managed via StreamElements chat commands, hosted on my webserver so each user can have their own count (e.g. !first, !checkin, etc.), and the data stays saved between streams. I currently need two, but I also require the ability to set up more on my own.

I’m looking for a Python-based system (or any other suitable solution) that allows my viewers to trigger individual, persistent counters through StreamElements chat commands on Twitch. Each viewer needs their own record, keyed by Twitch user ID, so when someone types commands like !first or !checkin the bot will:

• increment that viewer’s specific counter
• immediately display the updated total back in chat

The counts must be stored in a MySQL database on my webserver and remain intact between streams and restarts.

What I need from you:
1. Clean, documented Python code (or whatever works) that listens to StreamElements webhook events or uses the appropriate API to capture chat messages.
2. Secure MySQL schema and queries to create, read and update each user’s counter.
3. A simple configuration file where I can map command keywords (e.g., !first, !checkin) to distinct counters.
4. Clear instructions for local testing plus a step-by-step deployment guide for my server.
5. Basic error handling and logging so I can track failures or misuse without spamming chat. Meaning some commands can only be used once per stream or once per stream per user.

I need an admin-only command to view a leaderboard or manually adjust a user’s count