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 AllHow 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 AllCustomising 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 MorepgAdmin 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 MorepgAdmin 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 MoreWant to see your pgAdmin blog post here? Email webmaster@pgadmin.org.
Recent News
View AllpgAdmin 4 v9.14 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.14. This release of pgAdmin 4 includes 23 bug fixes and new features. For more details, please see the release notes.
Notable changes in this release include:
Features:
- Added support to download binary data from the result grid.
- Added support for custom LLM provider URLs for OpenAI and Anthropic, allowing use of OpenAI-compatible providers such as LM Studio, EXO, and LiteLLM.
- Fixed an issue where AI features (AI Assistant tab, AI Reports menus, and AI Preferences) were visible in the UI even when LLM_ENABLED is set to False.
- Allow copying of text from the AI Assistant chat panel.
Bugs/Housekeeping:
- Fixed an issue where selecting all in the Query Tool's Messages tab would select the entire page content.
- Fixed an issue where OAuth2 authentication fails with 'object has no attribute' if OAUTH2_AUTO_CREATE_USER is False.
- Ensure that the Geometry Viewer refreshes when re-running queries or switching geometry columns, preventing stale data from being displayed.
- Fixed an issue where the default fillfactor value for B-tree indexes was incorrect.
- Fixed an issue where AI Reports are grayed out after setting an API key by auto-selecting the default provider.
- Fixed an issue where AI Assistant does not notify that No API Key or Provider is Set.
- Fixed an issue where AI Reports fail with OpenAI models that do not support the temperature parameter.
- Improve the AI Assistant user prompt to be more descriptive of the actual functionality.
- Fix an issue where the AI Assistant was not retaining conversation context between messages, with chat history compaction to manage token budgets.
- Support /v1/responses for OpenAI models.
Download your copy now!
pgAdmin 4 v9.13 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.13. This release of pgAdmin 4 includes 15 bug fixes and new features. For more details, please see the release notes.
Notable changes in this release include:
Features:
- Core LLM integration infrastructure, AI reports for security, schema, and performance, AI chat for the Query Tool, and AI Insights for EXPLAIN.
- No FK are shown in diagrams created from existing tables in the ERD Tool.
- Add support for 'ONLY' in the Index creation dialog.
- Allow users to customize "OF TYPE" columns during table creation.
- Allow "drag-n-drop" for only user chosen tables, and show relations between them.
- Load predefined users from a JSON file through the command line.
Bugs/Housekeeping:
- Fixed an issue where the 'Quote strings only' configuration was ignored when downloading the result set.
- Fixed an issue where tools settings changed by the users were not restored on application relaunch.
- Fixed an issue where modifying a shared server incorrectly updated the original server details.
- Fixed an issue where a long name in ERD table node was not breaking into multiple lines.
- Fixed an issue where column comments were not displayed in the SQL tab for materialised views.
- Fix an issue where deployment of the helm chart was crashing with "operation not permitted."
- Fix translation compilation.
- Fix broken checkbox selection in backup dialog's object tree.
- Fixed an issue in file dialog where renaming was not working.
Download your copy now!
pgAdmin 4 v9.12 Released
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.12. This release of pgAdmin 4 includes 3 new features and 21 bug fixes/housekeeping changes. For more details, please see the release notes.
Notable changes in this release include:
Features:
- Add new options like INHERIT and SET to the Role's membership tab.
- Add a new button in the query tool data output toolbar to get entire range of data.
- Enhance OAUTH2 and OIDC authentication support with improved claims handling and configuration options.
Bugs/Housekeeping:
- Mask the secret key for restrict option in the process watcher when restoring plain SQL file (CVE-2026-1707).
- Fix Query Tool state restoration for new connections and queries.
- Fix pg_restore logs to distinguish UI sync issues from actual failures.
- Optimize checkbox selection logic in backup dialog objects tree.
- Fixed an issue where double click to open a file in the file manager is not working.
- Ensure saved shared server passwords are re-encrypted on password change.
- Fixed an issue where the dashboard freezes on initial render when there is a high number of locks.
- Fixed the SSL certificate issue while checking for the upgrade.
- Fixed a sorting issue in the system stats memory usage table.
- Disable Parameters and Membership fields when object is not new for Login and group roles.
- Fixed an issue where the Query History panel would auto-scroll to the top and did not preserve the scroll bar position for the selected entry.
- Fixed an issue where pgAdmin4 app on macOS cannot auto-update while running on a read-only volume even if present in the Applications folder.
- Fixed an issue where connection parameters were using localized values instead of literal values, causing connection failures.
- Ensure the container deployment supports boolean values in yaml format.
- Fix pgAdmin fails when performing Backup/Restore on a PostgreSQL connection defined exclusively via pg_service.conf.
Download your copy now!