Hello. I’ve just built the project prototype but probably it could useful to someone. I used to use metabase to analyze the data and in one of the projects it was not possible to install it as part of our infra. I created as simple as possible prototype to define Questions + Dashboard, it attaches to the existing phoenix app. Experimentally I added duckdb driver to be able to merge the different sources of the data.

https://github.com/oivoodoo/phoenix_lens

And one more project since couple years I used pghero in Rails, did it for phoenix as well as mountable dashboard.

https://github.com/oivoodoo/pghero-elixir