A Modern PostgreSQL Client Tool for the Mac

Postico for Mac

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe
Download Postico 2.1.9682

Postico for Mac

  -  11.8 MB  -  Demo
  • Latest Version

    Postico 2.1.9682 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    macOS 10.15 Catalina or later

  • User Rating

    Click to vote
  • Author / Product

    Jakob Egger / External Link

  • Filename

    postico-9682.dmg

Postico for Mac provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike. PostgreSQL is an absurdly powerful database, but there's no reason why using it should require an advanced degree in relational theory.

It 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 for macOS 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 powerful query view with support for multiple result sets. The editor has all the standard features you expect, like syntax highlighting and automatic indentation.

Features and Highlights

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, the tool plays nice with other apps and services you use every day.

Vibrant Design
The app was designed from the ground up with Apple's modern design language in mind. Its high resolution artwork looks great on Retina displays.

Secure out of the box
It 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 developers directly — "We 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.

Note: Only 5 connection favorites, only a single window per connection and the table filters are disabled. Requires 64-bit processor.

  • Postico 2.1.9682 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

What's new in this version:

New Features:
- Added a new setting that allows you to display binary values ("bytea") as Hex, Base64, or Crockford's Base32
- Multi-column sort! Sometimes a single column just isn't enough. Postico can now sort tables by multiple columns.
- Just hold down the option key when clicking the column to sort
- Sort NULLSs first or last. Right click the column header and make your choice
- Preconnect Shell Script: Postico can now run a shell script before connecting to the database
- This makes it a lot easier to use identity management software like AWS IAM or SSO solutions
- More ways to organise your queries: Postico now supports symbolic links and aliases
- If necessary, you can grant Postico permissions to additional folders in the new security settings pane

Small Improvements:
- Added a command to copy all values in a column
- Added a way to add a device name when activating multi-user licenses
- Add support for "nulls not distinct" indics
- Postico now has a command for generating UUIDv7 values
- Row counts are now formatted according to system settings (eg. 1,000,000 rows instead of 1000000 rows)
- Escape key no longer ends full screen mode
- Better support for functions & stored procdedures on Amazon Redshift

Fixed:
- Fixed a few crashes eg. when refreshing while the mouse is inside the "is in list" filter text field
- Fixed bug when adding columns with comments
- Better error messages when autocomplete fails

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe