User reference in database - best practice?

Hello !

I’m developing a project management app, using Keycloak as the identity provider. I need to reference users in the database and I am wondering what is the best practice.

Exemple : A “project” has a “manager”, it is a real human with a name and an email. For the moment, I reference the manager with a keycloak UUID.
Then I wan’t to retrieve all the projects, for all the managers. And I’m stuck because it would mean doing a request to keycloak for each project to get the names.
I’d like to know the bast path to follow ;

  • Sticking with a call to the admin API ?
  • Implement something to duplicate user info in my project database (SPI, cron job)
  • Call the SQL database of Keycloak from my backend
  • Implement a “manager” administration in my app where I can reference a keycloak UUID, or directly a name if the person isn’t in the system