Postico 2 is compatible with PostgreSQL 8.0 or later, Amazon Redshift, CockroachDB, Greenplum, and others.
Postico 2 requires macOS 10.13 or later. If you have an older Mac, get Postico 1.5 instead.
A database app for users
Postico 2 is a database app with a very strong focus on its core audience: people who use databases. Our customers range from researchers and analysts to app developers and students. Whether you want to enter data, search data, or perform SQL queries, Postico has you covered.
Postico 2 is the next major version coming after Postico 1.5.
If you'd like to know more about Postico 1.5, click here.
New: Multi-File Query Editor
The new SQL query editor makes working with a lot of queries easier than ever:
Create multiple SQL files and organize them into folders
Open the same file in multiple tabs or windows
Postico autosaves changes so you never lose your work
Drag any SQL file into the sidebar to add it to Postico
Edit SQL files with other text editors like VS Code, Atom, Sublime, Textmate, …
Auto-format SQL queries with Ctrl-F: pgFormatter is now built in!
Data Entry, Editing, and Search
Click a table in the sidebar, and see the data instantly.
Add rows, edit them, or filter them.
Powerful features like the foreign key picker or the row detail sidebar make editing all kinds of tables a breeze.
Table Structure Editor
Postico has a powerful graphical structure editor for creating and altering tables.
Add a column, edit data types, set a default value.
Columns, indexes and constraints are unified in a single editor, so you see everything at once.
And the more technically inclined can view the structure as raw SQL (DDL view).
New: Function Editor
You can now edit functions and stored procedures.
New: Distraction-free Updates
Postico can now update silently in the background.
We know that you have more important things on your mind than dealing with software updates.
So unless you disable automatic updates, Postico will never interrupt you with an update notification again.
This allows us to release updates to Postico more frequently than ever before.
Every new feature, every refactor, and every bugfix is built and automatically published by our new build system
(see the changelog).
Improved: Connection Settings
The streamlined interface means that your servers are never more than two clicks away.
Connection management in Postico 2 has been optimized for everyone, whether you use a single server, or hundreds of them:
Organize servers into nested groups
Support for syncing server settings with iCloud or Drop Box
Startup Queries allow customising server settings (eg. read-only connections)
Redshift, Greenplum, CockroachDB
Postico tries to support all PostgreSQL-compatible databases.
In addition to PostgreSQL, we have first class support for Amazon Redshift, Greenplum, and CockroachDB.
Some databases like Vertica are supported only in a limited way: executing SQL is possible, but other features do not work.
New: Support & Feedback built in
Postico now has a dedicated "Feedback" button in the toolbar to send feedback or to request support.
Postico will include relevant version numbers automatically, and optionally even include a screenshot of the current window.
You can send feedback anonymously, or you can include your email address if you want us to get back to you.
There are still a few minor bugs that we want to fix before we can recommend that people upgrade from Postico 1.x
When is Postico 2 going to be released?
Soon! We need to fix a few bugs and hope to release Postico 2.0 soon.
Is this a paid upgrade from Postico 1.x?
Yes, Postico 2 is a paid upgrade.
However, if you have purchased a license for Postico 1.x, you can use all functions of Postico 2 Preview until the final version is released.
Is there a grace period for people who have just purchased Postico 1.x?
If you have purchased a Postico 1.x license for yourself within the last 90 days, you can upgrade for 10€.
I bought a preorder license. How do I get my license key?
Please use the order number as license key.
Are there any limits in the Preview?
Preview builds expire after 6 weeks. Postico 2 updates itself, so unless you disable automatic updates that should not be an issue.
Postico 2 Preview has limits similar to the free trial of Postico 1.5 and needs to be activated to unlock all features (eg. multiple tabs). You can activate Postico 2 Preview either with a Postico 1.x license, or you can buy a license for Postico 2.
Are any other features coming to Postico 2?
The current feature set is what we are confident we can ship for 2.0.
Our focus is on making the current feature set stable and fix usability issues that pop up during testing.
We plan to ship additional features in 2.1, 2.2, etc, but we don't have a fixed roadmap.
We prioritise our work largely according to customer demand, so make sure to click the new feedback button!