Testing the views:
A github action could test the views by running them, inside a transaction, on the database. Would be run on any pull requests and/or commits to main. Login information would be stored in github secrets.

Testing the XML snippets:
Run through XML linter