Blog
Updates, guides, and thoughts on SequelPG and PostgreSQL.
May 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 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 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 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 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 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 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 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 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 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 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.