Keycloak database schema for application?

I am learning about keycloak. I have seen in docs keycloak support mysql or postgresql database if we want to deploy it in production. But if I switch to postgresql do we need to create user schema or roles? I could not understand why database support provided if someone wants to switch from default H2 database? Thanks

Once you run Keycloak with dedicated DB (postgres, mysql) it will create all necessary tables if that is what you are asking? You can define how the migrations will be run in the configuration file of keycloak.

1 Like