How to ron SQL stored Procedures with Ansible

How do I get ansible to run a folder full of SQL stored procedures on a
remote sql server?

any help would be appreciated.

You could use find module to find all the file and then run them with
command/shell module if there is no other module to execute them.