pgAdmin

The most popular and feature-rich open-source administration and development platform for PostgreSQL.

Category: db-toolFirst released: 1998Created by: The pgAdmin Development TeamLicense: PostgreSQL LicensePlatforms: macOS, Linux, Windows, Web

pgAdmin is the leading open-source management tool for PostgreSQL databases, providing a comprehensive graphical interface for database administration and development. It supports all PostgreSQL features including tables, views, functions, triggers, foreign data wrappers, and partitioning, from local instances to cloud deployments. The query tool offers syntax highlighting, auto-completion, and an explain plan visualizer for query optimization. pgAdmin includes a procedural language debugger for PL/pgSQL functions, a schema diff tool for comparing database objects, and a graphical query builder. Available as a desktop application and a web-based server mode, it serves developers and DBAs managing PostgreSQL databases from single instances to complex multi-server environments.

Links

Official WebsiteDocumentationGitHub

Key Features

SQL query tool with auto-completeExplain plan visualizerPL/pgSQL debuggerSchema diff and comparisonGraphical query builderServer monitoring dashboardBackup and restore wizards