What's new in PGZen

PGZen 1.0

Coming soon to the Mac App Store

The first release of PGZen.

• SQL editorAutocomplete from the live catalog, formatting, snippets, and errors exactly as PostgreSQL reports them.
• Result gridNULL is never an empty string, JSONB opens as a tree, and foreign keys are one click away.
• Safe editsEvery generated INSERT, UPDATE and DELETE shows its exact SQL and values before it runs.
• StructureColumns, indexes, constraints, triggers and DDL in one editor that rates every change’s risk before you apply it.
• IndexesB-tree, GIN, GiST, BRIN and the rest, with their expressions, predicates and included columns.
• TriggersTiming, events, UPDATE OF columns and constraint triggers, edited visually.
• FunctionsBrowse every catalog object and edit functions through CREATE OR REPLACE, reviewed before it runs.
• DiagramsAuto-laid-out from the live foreign-key graph, cycles and self-references included.
• EXPLAINEXPLAIN output as a tree with cost bars, the most expensive node flagged.
• PerformanceTop statements from pg_stat_statements, charted, one click from the editor.
• ConnectionsDirect TCP, SSH tunnels, verified TLS, read-only and production profiles.
• Schema diffTables, columns, indexes, constraints, routines and types, with the DDL of each side.
• History & filesSearch, pin and re-run past queries; keep queries as real .sql files.
• Import & exportA CSV import wizard with column mapping and preview; exports to CSV, JSON and SQL.
• LISTEN/NOTIFYSubscribe to channels, see payloads arrive, and refresh the open table when they do.