pgAdmin

Widely used open-source PostgreSQL administration tool for viewing, editing and maintaining databases.

Details

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.