SequelPG v0.1.9 follows up on the v0.1.8 tabs-and-tree release with full object lifecycle management, a powerful content filter bar, and a type-aware field editor that makes working with JSON, arrays, and booleans feel native.

Object CRUD: create and drop from the navigator

Right-click any object in the tree navigator and select Drop to remove it with a confirmation dialog. This works for every object type SequelPG knows about: tables, views, materialized views, functions, procedures, sequences, types, domains, collations, foreign tables, FTS objects, and operators. All drops use CASCADE so dependent objects are cleaned up automatically.

Creating objects is just as easy. Right-click a schema in the navigator to access dedicated creation sheets for:

Views — name and SQL definition
Materialized Views — name and SQL definition
Functions — name, arguments, return type, language, and body
Sequences — name with optional increment, min, max, and start values
Types — enum types with a label list
Domains — name, base type, default, and optional NOT NULL constraint

For any other category, a generic create sheet provides a raw SQL editor so you are never stuck.

Object Definition tab

Selecting a non-table object now opens the new Definition tab by default. This tab shows the DDL or source code for the selected object, pulled directly from pg_catalog. Functions display their full pg_get_functiondef output, views show CREATE OR REPLACE VIEW ... AS with the formatted view definition, sequences show their parameters, and composite or enum types show their full CREATE TYPE statement.

A refresh button lets you reload the definition after making changes, and the text is fully selectable for copying into your query editor.

Content filter bar

Press Cmd+F in the Content tab to reveal a filter bar. Each filter row lets you pick a column (or “Any Column” to search across all columns), choose an operator, and enter a value.

Available operators:

contains, equals, not equals
greater than, less than, ≥, ≤
starts with, ends with
is null, is not null

Add multiple filter rows for AND logic. A SQL Preview button shows the generated WHERE clause before you apply it. The filter toggle in the pagination bar turns orange when a filter is active, so you always know when you are looking at a subset of your data.

Type-aware field editor

Double-clicking a value in the Inspector now opens a rich editor tailored to the column's data type:

JSON / JSONB — a multi-line editor with pretty-print and format buttons. The Inspector preview shows a formatted 4-line snippet with a purple accent.
Arrays — displayed as an indexed list in the Inspector with a blue accent. The editor shows the raw PostgreSQL array literal for editing.
Booleans — shown with checkmark/cross icons and green/red coloring in the Inspector. The editor provides a simple toggle.
Long text — values longer than 80 characters or containing newlines open in a multi-line popover editor.

Each column in the Inspector also shows a colored data-type badge, making it easy to see at a glance what kind of data you are working with.

Under the hood

Navigator context menus — every object node has a right-click menu for drop. Schema nodes expose create actions for all supported object types.
getObjectDDL — a new protocol method on PostgresClientProtocol that retrieves definitions from pg_catalog for all 17 object types.
AppViewModel+ObjectCRUD — CRUD logic is extracted into its own extension to keep the main ViewModel focused.

What is next

With object management and filtering in place, the next priorities are:

Query history and saved queries
Table data export (CSV, JSON)
Schema visualization
Table row count in the navigator tree

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