Postico Reviews & Product Details

Color coded tabs, customizable views and advanced filtering make Postico a critical SQL database manager. The per-seat pricing is reasonable for small teams and deploying Postico in the Mac environment is simple and fast. Review collected by and hosted on G2.com.

Filtering could be a little smarter by stripping out trailing spaces, etc. Lack of Windows and Linux support could be a problem for some businesses. Review collected by and hosted on G2.com.

Simplicity. The simple view is great for use cases where we have 1-2 databases to connect. Review collected by and hosted on G2.com.

- DBMS features: It does lack a lot of features such as table insights (index, constraints, etc) that typically is useful for a software developer

- Multi-view: Connecting multiple databases opens up in a separate window which creates a lot of problems and does not offer a holistic view

- Scripts: Lack of support for writing SQL scripts such as intellisense, persisting scripts, etc. Review collected by and hosted on G2.com.

Speed is important when querying a database since there will be inherant latency. The fact that this Mac app runs locally and not as SaaS helps with that. The ability to filter for indexed field variables is great for those of us who aren't so great writing SQL queries. However, you can still write your own. The "Copy Insert Statement" feature came in handy. In full disclosure, I used version one which I don't believe had the function editor. This app was a workhorse in my daily tasks. Review collected by and hosted on G2.com.

The GUI is a bit bland and monolithic-looking, so it can take some getting used to. It feels as if it could be more intuitive and pleasant-looking. It's also almost a bit too easy to overwrite data if your database is very sensitive to changes Review collected by and hosted on G2.com.

The best part is that configuration of tool to get the ability of managament of database is so simple. It's just 20 seconds to provide credentials and you can access and make operations on database.

It provides me easy way:

- to execute SQL statement on databases

- export the results as a csv

- intuitive way and shortcuts when making queries. Review collected by and hosted on G2.com.

There is not a lot of disadvantages of Postico. It's useful, nice and easy. But the column filtering would be nice feature. Also It would be nice to have an ability to export results on different formats. Review collected by and hosted on G2.com.

Postico's SQL execution is very intuitive. It's not cluttered, and lets you execute single or multiple queries with great shortcut support. The navigation view is also amazing to explore a larger database. Review collected by and hosted on G2.com.

It's not possible to indent SQL code with IDE-like shortcuts. If they supported that, it would be amazing. Also there is no way to easy way to look at history or saved sql queries in the UI. Review collected by and hosted on G2.com.

I've been using Postico for many years at work, and it's a fantastic tool to interact with Postgres databases. What I like the most is the user-friendly features and slick UI that Native DB Clients don't have, such as:

- Copy/paste using the clipboard is so nice for quickly copying data in a tabular format

- Advanced Copy as Insert, CSV, etc also works very nicely

- Autocomplete: Makes building complex queries so much easier

- Low risk: Many GUI-based DB clients come with some risk, but with Postico you have complete control over how transactions are made, and you don't risk overloading the database. Also data edits are pretty low risk as they prescriptively require you to commit/save the changes, so it's a multi-stage process (other GUI-based clients are more prone to manipulate data inadvertently) Review collected by and hosted on G2.com.

Switching between Database hosts is not straightforward, as you have to close the entire connection every time.

It will be nice to have a "Get SELECT" feature to get a predefined SELECT query (similar to copy as INSERT) when selecting a row.

More updates will be nice as well. There are a few updates per year and this is probably fine as it's a small team behind it, but sometimes it feels a bit behind OSX releases Review collected by and hosted on G2.com.

I love that we're able to use this tool to create personalized and specific reporting for our company and our employees. It's a really helpful tool for us to be able to keep track of all our key metrics and stay on top of where our team is trending. Review collected by and hosted on G2.com.

There's really not much that I dislike about the platform. It meets all my basic needs and is pretty simple to use. Writing the queries is the hardest part, but this application makes it pretty simple to use. Review collected by and hosted on G2.com.

Postico Interface is easy I felt. I user DBeaver too, but comparatively, this is far better. We can easily connect to our internal DB spaces wihtout much hassle. :) Review collected by and hosted on G2.com.

Adding multple servers became alittle difficult. Also if there can be a tour guide that would help a newbie easily explore it otherwise it is good. :) Review collected by and hosted on G2.com.

PostgreSQL is super easy to use, with a beautiful and Mac-native user interface, super functionality and a very fair price including a very functional free tier. Review collected by and hosted on G2.com.

Nothing, I haven't found any issues or anything that I couldn't do with Postico. It's really an amazing product and anyone with a Mac and a PostgreSQL DB should use it. Review collected by and hosted on G2.com.

Postico is very easy and intuitive to use. Review collected by and hosted on G2.com.

- We can only save 5 db connection is free/community edition.

- You cannot filter any column in community edition Review collected by and hosted on G2.com.