Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Before, I have used phpmyadmin to manage an MySQL database, but now I would like to manage a PostgreSQL database. The PostgreSQL database is on a server, but not a webserver, so I don't use PHP.

Are there any good and free tools for managing a PostgreSQL database?

I have tried with pgAdmin III but it was a far from intuitive application to use, compared to phpmyadmin that I have used before. What are PostgreSQL DBAs usually using? do they use graphical tools like pgAdmin III or is it mostly command line tools?

share|improve this question

closed as off-topic by Paul White, Phil, bluefeet, Aaron Bertrand Jan 26 '15 at 14:41

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, bluefeet, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

There is a long list in the PostgreSQL Wiki:… – a_horse_with_no_name Jul 20 '12 at 6:29
up vote 2 down vote accepted

There is Navicat for PostgreSQL and other database platforms.

It has a free lite and a commercial version.

share|improve this answer
I do not think they offer the free lite version – David Jun 25 '13 at 0:39
navicat is great, but I also wished it came with a free version... If you have any link to provide, it would be most welcome. – KookieMonster Nov 19 '13 at 6:17

pgAdmin and psql, those are the tools I use. A PHP-script isn't very usefull for database management, too slow and many problems with transactions: What to do when something goes wrong? Commit or rollback? This makes tools like phpmyadmin and phpPgAdmin pretty useless, when the script is done, the database connection will be closed. There is nothing to commit or rollback, your SQL script is already gone.

Learn SQL and any tool that can keep it's databases connections open, will do the job.

share|improve this answer
I have used pgAdmin and psql a few months now, but I'm disappointed. The result sets from psql looks terrible on Windows, it's almost impossible to read, when having many columns. And it's hard to get a good workflow using pgAdmin, e.g. see How can I access the query history with SQL Editor in pgAdmin III? – Jonas Nov 7 '11 at 17:45

Coming from Microsoft SQL Server, I really like for managing PostgreSQL.

The free version has most everything you would need to get started.

share|improve this answer

Check out JackDB, it's a database client entirely in your web browser.

There's no software to install locally so you can use it on Mac OS X, Linux, and Windows and it works on all major modern browsers (eg. Chrome, Firefox, IE, Safari, and Opera). It supports connecting to PostgreSQL, as well as MySQL, Oracle, and SQL Server databases.

At the moment (July 13') it's more of a full featured query editor but it also includes GUI-based management features for things like changing runtime config parameters or vacuuming tables.

Regarding your comment in another answer above about SQL history (linked to a removed question), JackDB includes a full history of all SQL commands both per connection (searchable locally) and across all connections/datasources (searchable globally).

Full disclosure: I'm the founder of JackDB.

share|improve this answer
And how do I use this against a local database running on my desktop or on a local server? – a_horse_with_no_name Jul 18 '13 at 21:27
At the moment you can't with the cloud version without opening up remote ports from your local machine. We're looking into couple of ways to simplify that ( looks cool though it's http only) but for now it works best with cloud databases that are already network accessible (ex: Heroku Postgres, Amazon RDS, etc). – sehrope Jul 18 '13 at 22:31

Well, there is phpPgAdmin, if that suits you.

share|improve this answer
That sounds good. But at the moment I don't have a webserver and I'm not running PHP. Is there any similar GUI tools? It would also be helpful if it was possible to log in to a remote database via SSH. – Jonas Feb 17 '11 at 8:48

I like dbVisualizer, it has a free version that unfortunately is missing some features, you'll have to see if it has enough for you.

also check out stackoverflow for more choices:

share|improve this answer

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