How to make an AI chat boot for the company ?

Hello

I would like to create an intern chat boot for the company, to help employee to get all answers like who is doing what or when Joe Doe is going to go holidays ….
all these data exists already in tables :

– Absences table (to get the holidays , sickness …)
– Trainings table (for employee trainings )
– Users table (to get profile of users )
– …

the questions types :

• Give me the names of the employees in training .
• Who lives in XYZ city?
• how many employee are now in the XYZ office ?

Is there any framework or a tool to make this possible ?

thanks