Widely used open-source PostgreSQL administration tool for viewing, editing and maintaining databases.
pgAdmin is the widely used open-source graphical administration tool for PostgreSQL, used to manage databases, tables, users, permissions, queries and backups. Researchers working with PostgreSQL / PostGIS can use pgAdmin to view and maintain spatial databases.
Use cases: PostgreSQL administration, PostGIS administration, SQL queries, database maintenance, viewing tables
Note: For simple SQLite files, DB Browser for SQLite is lighter.