I know other existing projects like this (GitHub profile generators), although I like the idea you can customize the template.

However, it requires quite effort to deploy this one as you need to setup different services for the DB, deployment, etc. Since the data is pushed based on a GitHub action, I'm wondering if it's possible to just build a static site based on it. In the end, we're storing "snapshots" of the data to query them later.

Yes, since the data pipeline is universal, there can be multiple options on the UI, such as https://github.com/evidence-dev/evidence, which can regularly build static reports using SQL and data from the database through GitHub Actions.