Accessing the Keycloak H2 database
When running Keycloak out-of-the box it will use a H2 database. This is built-in and no extra
configuration is needed. It is possible (and recommended in production) to use
Options are MySQL, PostgreSQL, etc.
For development the H2 database is fine.
When you use an external database you can access the database with you favorite database explorer
software, HeidiSQL, DBBeaver,
pgAdmin. But when you still use
the H2 database you maybe want to access this database.
To explorer your H2 database open you terminal and go to the Keycloak directory.
java -cp ./modules/system/layers/base/com/h2database/h2/main/h2-*.jar org.h2.tools.Console -url "jdbc:h2:./standalone/data/keycloak;AUTO_SERVER=TRUE" -user sa -password sa
Your browser will start and the H2 console will open.