Thanks for your replies.
The thing is that i have an external neural network algorythm that gets the activity fo the person in the house and saves the information in a MySQL database in the same NUC where i’m running Home Assistant, saving this kind of data:
Then, in an automation about remind the person to take the pills, i want to check if the person has done it by getting the info from the database, to see if the automation needs to tell they to take their pills or not. And same for other activities and automations like eating, shower…
So i can’t use @CaptTom command cause it’s not HA info.
I’ve checked SQL sensor @CM000n, but i’m not sure if i can create many sensors and how it works with this external data.
And @dproffer, hope i gave more useful info about what i’m trying to do. I need an automation to remember the person to take their pills (after checking if they have done it in the database), and maybe for another 10 or more situations and activities.