pgAdmin

pgAdmin is the standard GUI for PostgreSQL database management. Browse databases, write and execute queries with syntax highlighting, manage users and permissions, view server status, and use the graphical query builder. The interface is available as a desktop app or in the browser. Free, open-source, and cross-platform. The de facto standard for working with PostgreSQL visually.