Accessing the ERPNext database in a GUI

Hellom I insatalled ERPNext in a ubuntu and it’s working. i can access the tables of the site using terminal. but is there a software to make me see the database in a GUI ( graphical user interface)?

You can connect any database management software as long as it supports mariadb. If the database isn’t local you’ll want to configure mariadb to allow remote connections. https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/

I am using Dbeaver for same…you can also use Heidisql

Hi @Mohsin1990

You can install Metabase on the same server as your ERPNext and use it to access your database tables. As an additional benefit, you can also use it’s default visualization methods to build a great looking dashboard.

Installation guide here :point_down: