Sounds brilliant @dale.roberts
Designing away the requirement for ssh keys is a great idea, making the whole process much more robust.
What do you mean by “analytics at a user-level”? Adding hooks to run scripts/tools to report PBS job analytics for personal or systemic use? Logging conda package loads, data access through tools like clef? That would be awesome!
The other way works too. The DB could be used as a source of data for CLI tools. Grafana is great, but sometimes CLI is nice, and an API means anyone can hack up the tool they want, or just dump the data into a pandas table and play with it.
Do you have a plan for how to transition to this?
@rbeucher some of what Dale is planning for capturing usage might be very interesting for you I think.