pgAdmin 4

pgAdmin 4 is an open-source tool for administering, developing, and monitoring PostgreSQL databases. It runs as a desktop application on Windows and macOS, and can also be deployed in server mode as a web application. It provides a graphical interface to create, browse, and maintain PostgreSQL objects, with the generated SQL kept visible. The Query Tool adds syntax highlighting, auto-completion, query history, and a graphical EXPLAIN.