Also available on the Mac App Store. Requires OS X 10.9 or later. Version 0.0 released on . Read the Changelist.
PostgreSQL is an absurdly powerful database, but there's no reason why using it should require an advanced degree in relational theory. Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike.
Postico will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views. Start with the basics and learn about advanced features of PostgreSQL as you go along.
Postico is an intuitive app for looking at data. Filter rows, sort them, rearrange columns. You can examine long text or images conveniently in the sidebar. Even related rows from referenced tables are shown.
Edit rows directly, or use the sidebar — a great choice for long text. You can even change multiple rows at once. Batch saving (with SQL preview) lets you commit changes to multiple rows in a single transaction.
Add and remove columns, rename them, change types. Modify tables and views without having to remember the ALTER TABLE syntax.
The unified structure editor displays everything you need to know about a table. Comments and constraints are shown right next to the columns.
When you need hard questions answered, PostgreSQL offers many advanced tools for data analysis: Common table expressions, recursive queries, filter aggregates, window functions.
To access these tools, Postico sports a query view inspired by Sequel Pro, the popular MySQL client. But with sophisticated features like multiple query results, Postico goes even beyond its role model.
Native Experience
Native Cocoa controls ensure consistency.
Keyboard shortcuts follow platform conventions.
Commands like undo/redo or copy/paste work just as you'd expect.
And of course, Postico plays nice with other apps and services you use every day.
Vibrant Design, backwards compatible
Postico was designed from the ground up with Apple's new design language in mind.
Its high resolution artwork looks great on Retina displays.
But the UI looks great on OS X 10.9 as well.
Secure out of the box
Postico uses industry standard encryption: both SSL and SSH can be used for secure connections.
Server certificates are always validated.
Passwords are stored safely in the system keychain.
A warning is shown if the server requests a plain text connection.
Dependable Customer Support
When you have a question, you can contact the developer directly —
I personally answer all customer emails.
You don't have to deal with outsourced support agents, and you'll never get a canned response.
A Companion to Postgres.app
Postgres.app is the fastest way to run a PostgreSQL server locally.
Since Postico is made by the maintainer of Postgres.app, the two apps co-operate perfectly.
Optimized for small displays
A slim toolbar conserves vertical screen estate.
The sidebars can be hidden to show more of your data.
And if you don't want to waste a single pixel, switch to full screen mode.
Which versions of PostgreSQL are supported?
I have successfully tested connecting to servers running PostgreSQL 8.0, 8.4, 9.1, 9.2, 9.3, 9.4 and 9.5, including Amazon Redshift.
Postico uses a patched version of libpq 9.3.8.
What are the limitations of the free trial?
Should I buy Postico on the Mac App Store or from your website?
It's your choice! Many customers prefer the convenience of the App Store.
You have all licenses in one place, and your software is automatically updated.
However, updates usually take a week (sometimes longer) to approve, and Apple charges a bit for distributing apps.
Therefore the version on my website will have updates available sooner and it is slightly cheaper.
Is Postico related to PG Commander?
Postico is the successor of PG Commander. While working on version PG Commander 2.0, I grew tired of its name and decided to try something less generic.
How can I import my PG Commander favorites?
Open PG Commander, right click on the favorites and select “Export All Favorites…”.
Drag the exported files on the favorites window in Postico to import them.
I bought PG Commander. Do you offer a discounted upgrade to Postico?
If you purchased PG Commander on my website after September 1st, 2014, your license file is valid for Postico.
(Just drag the license file on the Postico icon.)
Otherwise you can either purchase a new license at the full price, or email me if you consider that too expensive.
Do you have an issue tracker for bug reports and feature requests?
You can use this Github repository for public feature requests and bug reports.
If you prefer a private conversation, please contact me via email: jakob@eggerapps.at.