SwiftUI & AppKit · PostgreSQL 14–18 · macOS 26
Postgres. At home on Mac.
Less friction. More flow.
Query, design schemas, visualize ER diagrams, and inspect execution plans in a fast, thoughtfully crafted Mac app.
The tools you use every day, built for PostgreSQL

Autocomplete from the live catalog, formatting, snippets, and errors exactly as PostgreSQL reports them.
More about SQL editorNative macOS
SwiftUI and Liquid Glass where macOS uses it: the sidebar and toolbar. Your SQL and data stay on solid, readable surfaces.
Safe by construction
Generated SQL is reviewed before it applies, schema changes are rated for risk, and read-only profiles block writes in the client.
Private by default
Passwords stored in the macOS Keychain, no analytics, and crash reporting off unless you turn it on.
Dark or light, it follows your Mac
PGZen follows the system appearance, respects Reduce Transparency and Increase Contrast, and keeps result grids and the SQL editor opaque in both modes.

Every PostgreSQL object, first class
PGZen connects to PostgreSQL and nothing else, so the Explorer is organized the way PostgreSQL is.
- Tables
- Browse, edit rows with review, change structure
- Views
- Browse rows and definitions
- Indexes
- All access methods shown; B-tree created and changed visually
- Constraints
- Primary key, unique, check and foreign key; exclusion shown
- Triggers
- Created and edited visually
- Functions & procedures
- Definitions, edited through CREATE OR REPLACE
- Sequences
- Browsed and edited
- Types
- Domains, enums and composite types
- Extensions
- Installed and upgraded
- Schemas
- Diagrammed and compared
Nothing changes until you have read the SQL
Every generated INSERT, UPDATE, DELETE and ALTER TABLE opens in Review with its exact statement and bound values. Read-only profiles add a client-side guard; PostgreSQL permissions remain the real boundary.
How PGZen compares
Next to Postico, TablePlus and pgAdmin, three things set PGZen apart.
- Native, like the best Mac clients
- PGZen is a SwiftUI and AppKit app, like Postico and TablePlus. pgAdmin’s desktop app runs in Electron.
- PostgreSQL only, all the way down
- Triggers, functions, types, extensions, EXPLAIN plans and pg_stat_statements are first class, with nothing averaged across other database engines.
- Risk rated before anything runs
- PGZen rates every schema change and shows the exact SQL with its values. None of the other clients compared documents a risk indicator.
Get PGZen for your Mac
macOS 26.0 or later · PostgreSQL 14–18

