SequelPG is a free, open-source PostgreSQL GUI and SQL client for macOS. It is a lightweight native app built with SwiftUI, designed as an alternative to pgAdmin, TablePlus, and Postico.

Yes. SequelPG is open source (MIT) and free to use, with no paid tier, no trial, and no telemetry.

Is SequelPG a good pgAdmin or TablePlus alternative on Mac?

Yes. SequelPG is a native macOS app (not Electron) focused on day-to-day PostgreSQL work: schema browsing, SQL editing, row inspection, SSH tunneling, and object CRUD. It is designed to feel at home on macOS while staying fully open source.

What macOS version is required?

SequelPG requires macOS 14.0 Sonoma or later. It is built with modern SwiftUI APIs including the native Table grid.

Does SequelPG support SSL?

Yes. SequelPG supports every PostgreSQL SSL mode: Disable, Allow, Prefer, Require, Verify-CA, and Verify-Full.

Can I connect through an SSH tunnel?

Yes. SequelPG has built-in SSH tunnel support with both key file and password authentication. Configure it directly in the connection form — no external ssh command is needed at the user level.

Does the SQL editor support syntax highlighting and autocompletion?

Yes. The editor highlights SQL keywords, strings, comments, numbers, and operators with adaptive colors for light and dark mode. It provides autocompletion from SQL keywords plus your live database metadata (schemas, tables, columns). A Beautify button formats your query with proper indentation and auto-quotes mixed-case identifiers.

Where are my passwords stored?

SequelPG stores all credentials in the macOS Keychain. Database passwords and SSH passwords are kept in separate Keychain items. No credentials are ever transmitted off-device.

Is SequelPG production-ready?

SequelPG is in active development and already usable for day-to-day PostgreSQL work. Each release adds substantial features; check the release notes on GitHub for the latest version.

Where do I report bugs or request features?

On GitHub Issues at https://github.com/mihailShumilov/SequelPG/issues. Contributions via pull request are welcome.

SequelPG

The free, open-source PostgreSQL GUI for macOS — native SwiftUI, lightweight, and built for speed. A modern alternative to pgAdmin, TablePlus, and Postico.

Download SequelPG View on GitHub

Native macOS interface (SwiftUI, not Electron)
SQL editor with syntax highlighting and autocompletion
Built-in SSH tunnel support for secure remote connections
Native Table grid with column sorting and inline editing
Object CRUD, extensions, roles, indexes, and partitions
Keychain-backed credential storage — no telemetry, no tracking

Why SequelPG

Native macOS Experience

SequelPG is built with SwiftUI and @Observable for macOS 14+. Native Table grid with column sorting, tree navigator sidebar, and per-property tracking for buttery-smooth performance — not an Electron wrapper.

Advanced SQL Editor

Write SQL with syntax highlighting, autocompletion from SQL keywords and live database metadata (schemas, tables, columns), and a built-in query formatter with Beautify support.

SSH Tunnel Support

Connect securely to remote PostgreSQL databases through SSH tunnels with key file or password authentication — configured in the app, no extra shell setup needed.

Structured Database Navigation

Hierarchical tree navigator with 17 pgAdmin-style object categories. Browse schemas, tables, views, functions, sequences, types, and more. Switch between Structure, Content, and Query views with a single click.

Database Tools

Extensions sheet, Roles & Privileges browser with GRANT/REVOKE builder, and a curated library of ~50 built-in PostgreSQL functions — reach beyond the current schema without leaving the app.

Query History with Redaction

Press Cmd+Shift+Y to reveal the bottom-docked Query History panel. Every query is logged with source, timing, and row count. String literals in system-issued writes are redacted by default — safe for screen shares.

Full Object CRUD

Create and drop tables, views, materialized views, functions, sequences, types, and domains. Indexes, constraints, triggers, and partitions live alongside columns in the Structure tab.

Type-Aware Field Editor

JSON, arrays, and booleans get a proper editor. Inline single-click cell editing for simple values, content filters with SQL preview, and a Definition tab for viewing raw DDL.

Secure Credential Storage

Database and SSH passwords live in the macOS Keychain in separate items. Credentials never leave the device — no telemetry, no analytics, no outbound traffic beyond your configured connection.

See It in Action

SequelPG PostgreSQL GUI for macOS with iTerm2-style tabs and hierarchical tree navigator showing databases, schemas, and 17 pgAdmin-style object categories — Tabs and tree navigator — browse multiple connections with pgAdmin-style object categories

SequelPG SQL editor with syntax highlighting, autocompletion from database metadata, Beautify formatting, and the query results grid on macOS — SQL editor — syntax highlighting, metadata-aware autocompletion, and Beautify

SequelPG Structure tab showing table columns, data types, nullable flags, and default values on macOS — Structure tab — columns with indexes, constraints, triggers, and partitions below

SequelPG Content view showing table rows in a native macOS Table grid with column sorting and inline cell editing — Content view — native macOS Table grid with sorting and inline editing

SequelPG content view with single-click inline cell editing, auto-save on focus loss, and type-aware JSON/array/boolean field editor on macOS — Inline cell editing — single-click with type-aware JSON and array editors

SequelPG schema editing: add, rename, and drop columns, change data types, and toggle nullable directly in the Structure tab on macOS — Schema editing — add, drop, and modify columns without leaving the app

SequelPG connection form with host, port, database, username, password, SSL mode picker, and SSH tunnel configuration section on macOS — Connection form — full SSL modes plus built-in SSH tunnel configuration

SequelPG main interface on macOS showing tree navigator, tabbed workspace, table grid, and inspector panel — Main interface — tree navigator, tabs, table grid, and inspector panel

How It Works

Create a new connection. Open SequelPG, click the + button, and enter your PostgreSQL host, port, database, username, and password. Optionally enable the SSH tunnel section for connections behind a bastion host. Credentials are stored in the macOS Keychain.

Browse database schemas and tables. Use the hierarchical tree navigator to explore schemas, tables, views, functions, sequences, types, and more. Select any object to view its structure or content in the main area and metadata in the inspector panel.

Run SQL queries and inspect results. Open the Query tab, write SQL with syntax highlighting and autocompletion, and press Cmd+Enter to execute. Inspect results in a native Table grid, edit rows inline, or open them in the type-aware field editor.

Frequently Asked Questions

What is SequelPG?: SequelPG is a free, open-source PostgreSQL GUI and SQL client for macOS. It is a lightweight native app built with SwiftUI, designed as an alternative to pgAdmin, TablePlus, and Postico.
Is SequelPG free?: Yes. SequelPG is open source (MIT) and free to use, with no paid tier, no trial, and no telemetry.
Is SequelPG a good pgAdmin or TablePlus alternative on Mac?: Yes. SequelPG is a native macOS app (not Electron) focused on day-to-day PostgreSQL work: schema browsing, SQL editing, row inspection, SSH tunneling, and object CRUD. It is designed to feel at home on macOS while staying fully open source.
What macOS version is required?: SequelPG requires macOS 14.0 Sonoma or later. It is built with modern SwiftUI APIs including the native Table grid.
Does SequelPG support SSL?: Yes. SequelPG supports every PostgreSQL SSL mode: Disable, Allow, Prefer, Require, Verify-CA, and Verify-Full.
Can I connect through an SSH tunnel?: Yes. SequelPG has built-in SSH tunnel support with both key file and password authentication. Configure it directly in the connection form — no external ssh command is needed at the user level.
Does the SQL editor support syntax highlighting and autocompletion?: Yes. The editor highlights SQL keywords, strings, comments, numbers, and operators with adaptive colors for light and dark mode. It provides autocompletion from SQL keywords plus your live database metadata (schemas, tables, columns). A Beautify button formats your query with proper indentation and auto-quotes mixed-case identifiers.
Where are my passwords stored?: SequelPG stores all credentials in the macOS Keychain. Database passwords and SSH passwords are kept in separate Keychain items. No credentials are ever transmitted off-device.
Is SequelPG production-ready?: SequelPG is in active development and already usable for day-to-day PostgreSQL work. Each release adds substantial features; check the release notes on GitHub for the latest version.
Where do I report bugs or request features?: On GitHub Issues. Contributions via pull request are welcome.

Get Started with SequelPG

Open source. Free forever. Built for PostgreSQL on macOS.

View on GitHub Download