These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
1 more ways to get Postico 2
Package managers
- Homebrew
brew install --cask postico
About Postico 2
Postico 2 is a PostgreSQL client for macOS aimed at people who use databases day to day, from researchers and analysts to app developers and students. Click a table to see its data, then add, edit or filter rows, with a foreign key picker and a row detail sidebar for editing.
The multi-file query editor organizes SQL files in folders, autosaves, lets you edit files in other editors and formats queries with the built-in pgFormatter. It also works with Amazon Redshift, CockroachDB and Greenplum. It requires macOS 14 or later, with older versions offered for older Macs.
Strengths
- Native macOS interface focused on data entry and browsing
- Multi-file SQL editor with folders and autosave
- Built-in SQL formatting with pgFormatter
- Works with Redshift, CockroachDB and Greenplum
Limitations
- macOS only
- Current version needs macOS 14 or later
- Limited to PostgreSQL and compatible databases
Details
- Pricing
- PaidPaid app; a download is available before buying.
- License
- Proprietary
- Developer
- Egger Apps
- Platforms
- macOS
- How it runs
- Downloadable app
- Best suited for
- Mac users who work with PostgreSQL data and want a native client
- Categories
- Database tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to Postico 2
Compare allSoftware that can replace Postico 2 for an important use case, and what changes if you switch.
TablePlus
Native database client for many engines with a clean interface.
TablePlus is a native client for many engines on Windows, macOS, Linux and iOS, freemium rather than paid, with a free tier that limits tabs and connections.
pgAdmin
The standard open-source administration tool for PostgreSQL.
pgAdmin is free and open source, covers the full PostgreSQL object model and runs on all desktop platforms or the web, but its interface is heavy and slow.
DBeaver Community
One database client for more than a hundred databases, with a proper SQL editor and ER diagrams.
DBeaver is a free, open-source cross-platform client for more than a hundred databases, but it is Eclipse-based, heavy and has a busy interface compared with a native Mac app.
DataGrip
Multi-database IDE with an intelligent SQL console and schema navigation.
DataGrip is a cross-platform multi-database IDE with schema-aware completion and schema comparison, sold as a paid subscription instead of Postico's Mac-only license.
Beekeeper Studio
A SQL client that is pleasant to look at and works the same on Windows, macOS and Linux.
Beekeeper Studio is an open-source client on Windows, macOS and Linux with broad database support, built on Electron so it uses more memory than a native app.
DbGate
One database client for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, Redis and a dozen more, on desktop or as a web app.
DbGate is an open-source client for PostgreSQL and many other SQL and NoSQL engines on desktop or web, Electron-based and denser in interface.
Antares SQL
An open-source desktop SQL client for MySQL, PostgreSQL and SQLite with a focus on usability.
Antares SQL is a free, open-source cross-platform client for PostgreSQL, MySQL and SQLite with a usability focus, from a smaller project.
Similar software
Related functionality, not necessarily a direct replacement.
pgcli
A command-line PostgreSQL client with auto-completion and syntax highlighting.
PostgreSQL
The open-source relational database with 35 years behind it, known for correctness, extensibility and a long feature list.
Sequel Ace
A free, open-source macOS app for managing and querying MySQL and MariaDB databases.
Querious
A native macOS client for viewing, editing and managing MySQL and compatible databases.
