pgAdmin

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!

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!