pgAdmin4

The software provides a graphical interface for managing PostgreSQL databases, allowing users to create, modify, and query database objects such as tables, schemas, and functions. It includes a query editor with syntax highlighting, auto‑completion, and visual EXPLAIN output to help developers and administrators analyze and optimize SQL statements. The platform can be run locally on Windows, macOS, or Linux, and can also be deployed as a web application accessible through a browser.

It targets database administrators, developers, and analysts who work with PostgreSQL and need a unified tool for routine maintenance, schema design, and query testing. The interface presents database structures in a tree view, supports data import/export, and offers a result grid with capabilities like copying text and downloading binary data. Recent updates added support for custom large‑language‑model endpoints and refined AI‑related UI elements.

The application is open source, cross‑platform, and packaged for macOS among its core platforms. It is maintained as a stable release and includes documentation, tutorials, and a blog that covers configuration, server‑mode deployment, and workflow customization.