Is it possible to create a telegram bot that works with MySQL database?

Question

MySQL

Is it possible to create a telegram bot that reads data from a MySQL database through a search (by keywords)? For example, if you send a request to the bot for the inventory number of the equipment, it gave out the full data of the serial number, which department it belongs to. This table is already in the database. You just need to connect the base to the bot via Python (I write the code via PyCharm).

Answer 1

Yes, you can use PyMySQL to connect to the database
. Further, when you receive messages from a person, you simply make a query to this database and get the necessary data

Answer 2

You can, on the go, pretty fast