A new version of pgAdmin 4, version 9.13, is out with several notable updates and fixes. This release includes a rewritten core infrastructure for language models, allowing users to integrate their own AI providers or run them locally, which provides features like instant security report scans and schema summaries. Additionally, the ERD tool has been improved by restoring foreign key relationships when copying diagrams and making the drag-and-drop interface more intuitive. Other changes include an enhanced index creation dialog with auto-filled options and fixes for various smaller bugs that were causing issues.

pgAdmin 4 9.13 Unleashes AI Features and Fixes ERD Glitches

A fresh build of pgAdmin 4 is out, bringing a handful of AI‑powered tools, tighter ERD control, and a cleanup of the odd quirks that have been bugging users for months.

pgAdmin 4’s New Core LLM Infrastructure

The biggest headline here is a complete rewrite of how the app talks to language models. Instead of a single, monolithic endpoint, developers now get an infrastructure layer that lets you plug in your own AI provider or run the defaults locally. For database folks, this means instant “security report” scans and schema summaries without leaving the interface. The Query Tool has a brand‑new chat pane where you can ask for help drafting a SELECT statement; it even auto‑completes based on the current database schema.

ERD Tool Gets a Tightening

Earlier releases left users in a bind when they tried to copy an existing table’s diagram into a new one: foreign keys vanished. Version 9.13 restores those FK relationships, so the visual map now matches what actually sits in the catalog. The drag‑and‑drop interface is also smarter—only the tables you pick show up, and relations between them are highlighted automatically. A user once complained that dragging a table from one diagram to another would drop all constraints; that’s fixed.

Index Creation Dialog Gets a Boost

When building indexes on large tables, a common pain point was having to type out the full definition. The new dialog now supports an “ONLY” keyword straight away, letting you target a specific table in a partitioned set without extra typing. Customizing the “OF TYPE” clause during table creation is also possible now; the UI shows the current options and lets you pick from them instead of leaving that column blank.

Miscellaneous Fixes You’ll Notice

A handful of smaller but annoying bugs finally went home: the “Quote strings only” setting in export was previously ignored, backup dialogs had broken checkboxes, and a helm chart deployment would crash with an “operation not permitted” error. A JSON import feature was added for pre‑defined users so that admins can bootstrap their environment via command line. The translation compiler has been reworked to avoid missing strings.