I'm looking for a nice visual explorer for PostgreSQL.

I found DataGrip by JetBrains. The issue is the price is high, at least for me.

I would like to have another explorer, which is comfortable, visually speaking and with a lower price. The explorer has to be for Windows (7 and onward). But it has to be an IDE too, because I'm developing SQL queries.

  • 1
    What features do you need? Is a simple database browser enough? The "D" in "IDE" means "Development", what kind of development do you need the tool to allow you to do?
    – Nicolas Raoul
    Commented Nov 15, 2016 at 7:22
  • Hi @NicolasRaoul, I need the same thing as I have with SqlServer Management Studio but for postgres (e.g having a tree with the referencing of the objects in the db, be able to write queries that will put the correct syntax and the correct object names).
    – Andy K
    Commented Nov 15, 2016 at 7:44
  • @AndyK Please edit your Question with further information rather than post as comments. Commented Nov 20, 2016 at 7:05

2 Answers 2


I use pgAdmin for this.

It meets your requirements as far as I can tell:

  • Works with Windows 7 and onwards
  • Has a visual tree tree with the referencing of the objects in the db
  • Able to write queries
  • Hi @ryan-weaver nice! I need to have a look. Thanks.
    – Andy K
    Commented Nov 15, 2016 at 18:21
  • Distributions of Postgres commonly bundle pgAdmin. So you may already have it. Beware that the many-years-old well-worn edition of pgAdmin (QT-based C app) is being replaced with an all-new dual-purpose web app/desktop app edition, with all-new code base. Commented Nov 20, 2016 at 7:08

pgAdmin is the best option because it is built for PostgreSQL only.

I am using pgAdmin and Database .NET, Database .NET is my favorite since it has many good features which pgAdmin doesn't. It is very lightweight (free and commercial versions are available) and portable.You can connect many databases with this.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.