Postico 2

Free trial Mac

What Postico 2 is

Postico 2 is a native Mac database app for working with PostgreSQL and compatible databases, including Amazon Redshift, CockroachDB, and Greenplum. Its query editor supports multiple SQL files, folders, tabs, and windows, autosaves work, and formats SQL with pgFormatter. Users can view, add, edit, and filter table data, use a foreign key picker and row detail sidebar, and edit tables through a graphical structure editor with a raw SQL DDL view. The app can also edit functions and stored procedures. Connection settings can be organized into nested groups and synced with iCloud or Dropbox; startup queries can set server options such as read-only connections. Postico 2 is a desktop app with SSH tunneling, query history, and exports to TSV, CSV, or SQL Insert Statements, including versions with headers. It is paid software, with listed plans starting at $29, and has a time-unlimited evaluation license with some features disabled. The latest stable release listed requires macOS 14 or later. Some databases, such as Vertica, have limited support: SQL execution works, but other features do not.

Who it suits

Postico 2 suits Mac users working with PostgreSQL or compatible databases who want data editing, SQL tools, and export options in a desktop app. It may also suit students and researchers, as well as analysts and app developers.

What it does well

Works with PostgreSQL and several compatible databases
SQL editor supports multiple files, tabs, and windows
Can view, edit, and filter table data
Supports SSH tunneling and query history
Exports TSV, CSV, and SQL insert statements

What to know first

Latest stable release requires macOS 14 or later
No free plan; evaluation disables some features
Some databases, including Vertica, have limited support

Plans

Plan	Billed and limits	Price
Free Evaluation License	No time limit; a paid license is required to unlock all features. · Evaluation purposes only · some features disabled	Free
Student License	$29 / 27€ (VAT included) · 1 device · not for resale · valid for Postico 2.x	$29, paid once
Personal License	$69 / 62€ (VAT included) · Up to 3 devices · not for resale · valid for Postico 2.x	$69, paid once
Team License	$799 / 730€ (plus VAT if applicable) · Up to 10 devices · valid for Postico 2.x	$799, paid once
Commercial License	$99 / 90€ per device (plus VAT if applicable) · Per device · valid for Postico 2.x	$99, paid once

As eggerapps.at lists them, read 11 Oct 2026. The maker's own page has the final word.

Verdict

Postico 2 combines database connections, SQL editing, and table work in a native Mac app. Check the macOS requirement and the support level for your particular database before choosing it.

Facts from Postico 2's own pages

Compatibility limit: Some databases, such as Vertica, are supported only in a limited way: SQL execution works, but other features do not. · eggerapps.at, 11 Oct 2026
Connections: Connection settings can be organized into nested groups and synced with iCloud or Dropbox; startup queries can customize server settings such as read-only connections. · eggerapps.at, 11 Oct 2026
Database compatibility: Postico 2 is compatible with PostgreSQL, Amazon Redshift, CockroachDB, Greenplum, and other PostgreSQL-compatible databases. · eggerapps.at, 11 Oct 2026
Data editing: Users can view, add, edit, and filter table data, with a foreign key picker and row detail sidebar. · eggerapps.at, 11 Oct 2026
Evaluation: The evaluation license has no time limit, but some features are disabled until a paid license is used. · eggerapps.at, 11 Oct 2026
Headquarters: Linz, Austria · eggerapps.at, 28 Sept 2026
Maker: Egger Apps is a small company based in Linz, Austria, and its founder Jakob Egger currently maintains the app on his own. · eggerapps.at, 11 Oct 2026
Privacy: The maker says its desktop apps run locally, have no cloud features, and do not transfer user data to a web service; Postico does send limited device and version information to check for updates. · eggerapps.at, 11 Oct 2026
Product: Postico 2 is a native Mac database app for working with PostgreSQL databases. · eggerapps.at, 11 Oct 2026
Schema and functions: Postico includes a graphical table structure editor with a raw SQL DDL view, and can edit functions and stored procedures. · eggerapps.at, 11 Oct 2026
SQL editor: The query editor supports multiple SQL files, folders, tabs and windows, autosaving, and built-in SQL formatting with pgFormatter. · eggerapps.at, 11 Oct 2026
Support: Users can request support or send feedback from the app, email the maker, or use its GitHub Issues page. · eggerapps.at, 11 Oct 2026
System requirement: The latest stable release listed on the downloads page requires macOS 14 or later. · releases.eggerapps.at, 11 Oct 2026
Users: The maker says its customers include researchers, analysts, app developers, and students. · eggerapps.at, 11 Oct 2026

Where Postico 2 stands on Freedom251

Database Client Software#50 of 53