pgAdmin

The Most Popular PostgreSQL Admin Tool

Feature-rich, open-source administration and development platform for PostgreSQL, the most advanced open source database in the world.

Available for:
Screenshot of pgAdmin

Why Choose pgAdmin?

Cross-Platform

Run on Windows, macOS, Linux, or deploy as a web application accessible from any browser.

Full Database Management

Create, manage, and query all PostgreSQL objects with an intuitive graphical interface.

Powerful Query Tool

Syntax highlighting, auto-complete, and graphical EXPLAIN for optimizing your queries.

Latest Videos

View All
How to use Restore Dialog in pgAdmin 4
Authenticate pgAdmin 4 with Github
Kerberos and Active Directory setup in pgAdmin 4

Want to see your pgAdmin video here? Email webmaster@pgadmin.org.

Latest Blog Posts

View All
Anil Sahoo | Aug. 24, 2023
Customising your pgAdmin 4 workspace - Part 1: Browser

If you are reading this then you are probably using pgAdmin as a tool to help in your day to day database management activities with PostgreSQL. But, did you know …

Read More
Aditya Toshniwal | Aug. 24, 2023
pgAdmin User Management in Server Mode

pgAdmin can be deployed as a web application by configuring the app to run in server mode. One can check out server deployment on how to run pgAdmin in server …

Read More
Dave Page | Aug. 24, 2023
pgAdmin CI/CD

Almost exactly three years ago I wrote a blog on my personal page entitled Testing pgAdmin which went into great detail discussing how we test pgAdmin prior to releases. Back …

Read More

Want to see your pgAdmin blog post here? Email webmaster@pgadmin.org.

Recent News

View All
2025-12-11
pgAdmin 4 v9.11 Released

The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.11. This release of pgAdmin 4 includes 16 bug fixes and new features. For more details, please see the release notes.

Notable changes in this release include:

Features:

  • Add support of DEPENDS/NO DEPENDS ON EXTENSION for INDEX.
  • Add support of DEPENDS/NO DEPENDS ON EXTENSION for MATERIALIZED VIEW.
  • Add support for showing the column data type beside column name in the object explorer.
  • Added Ubuntu 25.10 and Fedora 43.
  • Add conditional TLS support for the Ingress in the Helm chart.

Bugs/Housekeeping:

  • Plain SQL restore runs with '\restrict' option to prevent harmful psql meta-commands (CVE-2025-13780).
  • Fixed an issue on type casting of default string function/procedure arguments in debugger tool.
  • Fix pkg_resources deprecation warning by migrating Docker base image to python:3-alpine from alpine:latest.
  • Fixed an issue where EXPLAIN should run on query under cursor if no text is selected.
  • Fixed an issue where opening file in Query Tool does not retain file name in tab.
  • Fixed an issue where connection is failing via Query Tool/PSQL Tool workspaces.
  • Fixed an issue where copying highlighted text in the query tool data output cell editor would copy the complete string.
  • Fixed an issue where copying a single cell should not add quoting.
  • Fix the Helm chart server definition and change the app version.
  • Specify the correct hostname placeholder for the Password Exec command.
  • Ensure the proper handling of extra volume mount configurations in the Helm deployment template by correcting the configuration value references.

Download your copy now!

2025-11-13
pgAdmin 4 v9.10 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.10. This release of pgAdmin 4 includes 5 new features and 12 bug fixes/housekeeping changes. For more details, please see the release notes.

Notable changes in this release include:

Features:

  • Added the ability to search for tables and automatically bring them into view in the ERD tool.
  • Add support of DEPENDS/NO DEPENDS ON EXTENSION for PROCEDURE.
  • Add support for setting image download resolution in the ERD tool.
  • Add support for displaying detailed Citus query plans instead of 'Custom Scan' placeholder.
  • Add support for formatting .pgerd ERD project file.

Bugs/Housekeeping:

  • Fixed an issue where data output column resize is not sticking in Safari.
  • Fixed an issue where Schema Diff does not ignore Tablespace for indexes.
  • Fixed an issue where the 2FA window redirected to the login page after session expiration.
  • Fixed an issue where the Select All option on the columns tab of import/export data was not working in languages other than English.
  • Fixed an issue where the Debian build process failed with a "Sphinx module not found" error when using a Python virtual environment.
  • Fixed an issue where the last used storage directory was reset to blank, leading to access denied errors during backup or restore operations.
  • Fixed an issue that prevented assigning multiple users to an RLS policy.
  • Fixed remote code execution vulnerability when restoring PLAIN-format SQL dumps in server mode (CVE-2025-12762).
  • Fixed Command injection vulnerability allowing arbitrary command execution on Windows (CVE-2025-12763).
  • Fixed LDAP authentication flow vulnerable to TLS certificate verification bypass (CVE-2025-12765).
  • Fixed LDAP injection vulnerability in LDAP authentication flow (CVE-2025-12764).
  • Migrate pgAdmin UI to use React 19.

Download your copy now!

2025-10-16
pgAdmin 4 v9.9 Released

The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.9. This release of pgAdmin 4 includes 10 bug fixes and new features. For more details, please see the release notes.

Notable changes in this release include:

Features:

  • Add support of DEPENDS/NO DEPENDS ON EXTENSION for ALTER FUNCTION.
  • Added "MULTIRANGE_TYPE_NAME" option while creating a Range Type.
  • Added "SUBSCRIPT" option while creating an External Type.
  • Added option to skip the password dialog when using an identity file.
  • Added 'failover' and 'two_phase' parameter support in CREATE/ALTER SUBSCRIPTION for PostgreSQL v17+.
  • Add support for initializing the pgAdmin4 Kubernetes Helm chart.

Bugs/Housekeeping:

  • Fixed an issue where the query tool displayed 'default' instead of 'null' for null text data in the data output.
  • Fixed an issue where the pgAdmin configuration database wasn't being created on a fresh install when an external database was used for the configuration.
  • Fixed an issue where shortcuts are not working as expected on multiple keyboard layouts.
  • Fixed an issue where saving the newly changed preferences was not reflecting on the preferences tab.

Download your copy now!

Current Version: pgAdmin 4 9.11 Download Now