Blog
Updates, guides, and thoughts on SequelPG and PostgreSQL.
June 10, 2026
SequelPG v0.3.5: CSV/JSON result export, a Stop button, and a configurable query timeout
The most-requested workflow feature lands: an Export ▾ menu under the query results and the content tab writes the rows you’re looking at to CSV (RFC 4180 quoting, NULL as empty field) or JSON (NULL as null, duplicate columns suffixed). The hard-coded 10-second query cap becomes a Settings picker — 5 s to 5 min or no limit — and while a statement runs, Run becomes Stop (⌘.). Under the hood: statement_timeout now lives on the same pooled connection as the query it guards, rapid filter/sort/pagination clicks can’t race stale rows onto the screen, and functions in CamelCase schemas finally resolve in the Run sheet.
June 1, 2026
SequelPG v0.3.4: a JetBrains-style SQL completion popup, an off switch, and smarter DDL ranking
The native macOS completion list is gone, replaced by a purpose-built, JetBrains-style popup — a non-activating child NSPanel that keeps the editor focused, with kind chips, the characters you’ve typed bolded in the accent color, type detail, and click-to-accept. Accepting leaves the caret at the end with no leftover selection. A new Settings toggle turns as-you-type completion off (⌃Space still invokes it on demand), schema and table names now outrank keywords in DDL targets so DROP SCHEMA no longer prefers VACUUM, and two UI fixes land — a “Running query…” state in the results pane and explicit theme colors for the navigator sidebar labels.
May 27, 2026
SequelPG v0.3.3: an interactive entity-relationship diagram for your schema
A new Diagram tab (⌘5) draws the selected schema as table cards with primary- and foreign-key markers, and foreign keys as right-angle connectors that route around other tables — never through them — via an A* obstacle-avoiding router with turn and crossing penalties. Auto Layout is a deterministic Fruchterman–Reingold force-directed pass that clusters related tables and keeps lines short. Drag, zoom, pan, collapse, and hide tables; your arrangement is saved per schema and restored next time. Export the whole diagram as PNG (1×/2×/3×), SVG, or PDF.
May 26, 2026
SequelPG v0.3.2: database export and import with pg_dump and psql
A full Export sheet backed by pg_dump — four output formats (plain SQL, custom, directory, tar), schema-or-data scope, schema and table include/exclude, and the long tail of owner / privilege / clean / create / INSERT / compression / encoding toggles — with live progress and credentials passed through the environment, never the command line. An Import sheet runs .sql files through psql with single-transaction and ON_ERROR_STOP safety. Plus hardened client-tool detection that finds a keg-only brew install libpq and postgresql@N kegs a Finder-launched app would otherwise miss.
May 19, 2026
SequelPG v0.3.0: a plain-English EXPLAIN/ANALYZE visualizer and smarter SQL autocomplete
Two big additions to the query editor. A plain-English EXPLAIN / EXPLAIN ANALYZE visualizer that translates PostgreSQL plan nodes into rows like “Read the whole orders table” and “Match rows using a hash table” — with self-time, bad-estimate, and dominant-step callouts surfaced in plain English. A smarter autocomplete that understands clause context (tables after FROM, columns after WHERE, qualified columns after table-dot), prefix-first ranks SELECT above SECURITY, and only auto-fires on growth so backspace can actually correct a query. Headlines are now JetBrains Mono Bold throughout — one consistent developer-tool identity, no italic.
May 15, 2026
SequelPG v0.2.1: editorial redesign, Slonik mark, and a single phosphor-lime accent
The marketing site’s editorial “technical journal” aesthetic translated into the native macOS app. Lime selection replaces macOS blue across sidebar / row / button / caret, JetBrains Mono and Instrument Serif ship bundled, roman-numeral kicker labels and italic-serif object titles sit above each tab, type pills in violet / mauve / cyan / amber color-code column headers, and the AppIcon is now a refined Postgres-elephant Slonik mark that renders cleanly at every size.
May 14, 2026
SequelPG v0.1.14: a UI performance pass for long browsing sessions
Sixteen targeted fixes for the symptom users hit after a long working session — walking through tables and opening large cells, then watching the UI slow down. The AppKit grid stops calling reloadData() on selection-only changes, introspection caches are bounded LRUs, open tabs cap at twelve, the field editor debounces JSON validation and parses arrays off the main thread, and the inspector stops rebuilding its column dictionary on every redraw. No new features, no behavior changes — everything just stops doing the same work twice.
May 12, 2026
SequelPG v0.1.13: run functions and procedures, full CREATE TABLE definitions, and syntax-highlighted DDL
A focused Run / Call sheet for invoking functions and procedures from the navigator with per-argument Value / Expression / NULL / DEFAULT modes, named-argument SQL generation, and an inline result pane that reshapes for scalar, set-returning, and procedure calls. Full CREATE TABLE reconstruction in the Definition tab, syntax-highlighted DDL for every entity, and a fix for the navigator collapsing when you click a leaf row.
May 11, 2026
SequelPG v0.1.12: AppKit results grid, type-aware cells, and a test-connection probe
The results grid is rebuilt on AppKit for reliable single-click selection, multi-select, and vertical cell dividers. Every PostgreSQL type now decodes from the binary wire format (numeric, money, inet, cidr, macaddr, jsonb, composite types). The Test Connection button finally works, and a dockerized PostgreSQL 18 demo database ships for local development.
April 19, 2026
SequelPG v0.1.11: database tools, query history, and a catalog-query security pass
An Extensions sheet, Roles & Privileges browser, Index creation sheet, per-table indexes/constraints/triggers/partitions in the Structure tab, a bottom-docked Query History panel with redaction, a curated SQL Function Library, and a catalog-wide refactor that parameterizes every introspection query.
April 6, 2026
SequelPG v0.1.9: object CRUD, content filters, and type-aware field editor
Full object lifecycle management (create and drop views, functions, sequences, types, domains), a content filter bar with SQL preview, a Definition tab for viewing DDL, and a type-aware field editor for JSON, arrays, and booleans.
April 6, 2026
SequelPG v0.1.8: tabs, tree navigator, schema editing, and inline cell editing
iTerm2-style tabs, a hierarchical tree navigator with 17 pgAdmin-style object categories, create objects from the UI, schema editing, and single-click cell editing.
April 4, 2026
SequelPG v0.1.7: modern SwiftUI, native Table grid, and a comprehensive security audit
Modernize to macOS 14+ with @Observable and native Table grid, plus a comprehensive security, performance, and PostgreSQL correctness audit across 36 files.
March 10, 2026
SequelPG v0.1.5: SQL editor with syntax highlighting, SSH tunnels, and more
The biggest update yet — a full-featured SQL editor with syntax highlighting, autocompletion, and query formatting, plus SSH tunnel support for secure remote connections.
February 17, 2026
SequelPG: an open-source PostgreSQL GUI for macOS
Why we built SequelPG, what makes it different, and how to get started with a lightweight PostgreSQL client for macOS.