Yes, as example script I gave Claude the link to the one by pharesim mentioned here. Different topic, but the principle is the same - HafSQL database is used to retrieve info.

I use the witness node server to run the script, but not for the database which is on another public server (DB_URL = "postgresql+psycopg2://hafsql_public:hafsql_public@hafsql-sql.mahdiyari.info:5432/haf_block_log")

No, this is not needed, such a bot script you can easily run locally from your machine (you just need to install Python). For a witness a more powerful server is needed, 500GB NVME (which is faster than SSD), 32GB RAM and 6-8 CPU Cores. I rent it at Contabo (but the monthly rent fee is higher than the witness rewards, so I would not recommend it at this Hive price).