Accessing Embedded in-memory H2 console used in Spring Boot

When an embedded in-memory H2 database is used with Spring Boot, your data can be accessed via H2’s web console available in your application. If you are using Spring Security, you may need to exclude the /h2-console URL from the authentication process.

You also need to set this property:

Please be aware that this type of configuration is not ideal for production. I’d recommend it only for prototyping.

H2 Web console

Assuming your web application is deployed in http://localhost:8080, the H2 console can be accessed via

You will be redirected to a login page.

Notice the JDBC URL

Viewing the Data

The default User Name and Password are:

NOTE: Password is blank.

Logged In

With the web console, you can run SQL queries against available tables.