SequelPG v0.1.8 is here, and it is the biggest feature release yet. This update transforms SequelPG from a single-connection browser into a multi-tab, multi-database workstation with full object browsing, schema editing, and inline data editing.

iTerm2-style tabs

Press Cmd+T to open a new tab within the same window. Each tab maintains its own independent database connection, so you can work across multiple servers or databases simultaneously without switching windows. Tabs are lightweight and feel native — just like you would expect from a macOS app.

Hierarchical tree navigator

The flat database and schema picker dropdowns are gone. In their place is a full hierarchical tree navigator built with DisclosureGroups. The tree follows the familiar structure: databases → schemas → object categories → individual objects.

Expanding any database in the tree automatically fetches its schemas, temporarily switching the connection if needed. This means you can browse multiple databases from a single connection without manually switching.

17 pgAdmin-style object categories

Each schema now exposes 17 object categories, matching the level of detail you would find in pgAdmin:

  • Aggregates
  • Collations
  • Domains
  • FTS Configurations, Dictionaries, Parsers, and Templates
  • Foreign Tables
  • Functions
  • Materialized Views
  • Operators
  • Procedures (PostgreSQL 11+ only)
  • Sequences
  • Tables
  • Trigger Functions
  • Types
  • Views

Categories adapt to the server version automatically. Procedures are only shown when connected to PostgreSQL 11 or later, and aggregate and trigger queries adjust to the pre-11 catalog schema when needed.

Create databases, schemas, and tables

The navigator now includes a + menu that lets you create new databases, schemas, and tables directly from the sidebar. No more switching to a SQL editor just to run CREATE DATABASE or CREATE TABLE.

Schema editing

The Structure tab is no longer read-only. You can now modify table schemas directly:

  • Add new columns
  • Drop existing columns
  • Rename columns
  • Change column types
  • Toggle nullable constraints
  • Change default values

All changes are executed via ALTER TABLE statements under the hood, so they are safe and transactional.

Single-click cell editing

Editing data is now faster. Click any cell to start editing immediately — no more double-click followed by pressing Enter. Changes auto-save when you move focus to another cell. The update happens in-place, preserving your current row order and scroll position instead of re-fetching the entire result set.

Under the hood

  • Per-tab architecture — each tab gets its own AppViewModel instance while sharing the connection list via environment injection.
  • Bulk introspection — a new listAllSchemaObjects method fetches all 17 object types in parallel, keeping the tree responsive even on large schemas.
  • Version detection — server version is detected on connect via SHOW server_version_num, enabling version-adaptive queries throughout the app.

What is next

With tabs and a full object tree in place, the next priorities are:

  • Query history and saved queries
  • Table data export (CSV, JSON)
  • Schema visualization
  • Improved filtering and search in Content view

SequelPG is open source on GitHub. Download the latest release from the releases page, report issues, or contribute directly. We would love your feedback.