Manipulate your database with dBeaver¶
DBeaver is free universal SQL client/database tool for developers and database administrators. DBeaver is able to connect to H2GIS database which is the one used.
Connect dBeaver to your database¶
Be sure that the geoserver is closed. It is not possible to connect dBeaver and GeoServer at the same time.
- Run dBeaver
- Add a new connection
- If you use a h2gis type databse please select ‘H2GIS embedded’
- Browse your database. By default it is in Geoserver\data_dir and the name is h2gisdb.mv.db
- Open it !
Now you can use the full potential of dBeaver and the h2gis database. You can explore, display and manage your database.
Many spatial processing are possible with H2GIS. Please see the H2GIS website.