H2 database is an embedded database that widely used in testing, local storage and caching.

Install H2 database client and server

The H2 database installation contains a web based database client, in which you can create database, table, insert data and query data.

Download the windows installer .

Start "H2 Console" from start menu then goto url 

 
 
http://localhost:8082/login.do
 
 

Click Connect to open the database session.

H2 database client

Some queries examples:

 
SELECT * FROM TEST ORDER BY ID
INSERT INTO TEST VALUES(2, 'World')
DELETE FROM TEST WHERE ID=2
 
 

Other H2 database client

If you don't like web based client , I recommend "Execute Query". Make sure the H2 database run in server mode. And configure H2 in Database Browser like this.

H2 database client Execute Query

And execute query in Query Editor

H2 database client Execute Query