Tell me more ×
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. It's 100% free, no registration required.
up vote 1 down vote favorite

I needed an interface/admin (web or desktop) from which I could manage all the databases in my system. Currently I use separate admins for each (phpmyadmin for mysql, pgadmin/phppgadmin for postgres, sqlite manager in firefox for sqlite etc). Whenever I have to work with all the databases, the only option I am left with is shell access to all the databases.

I wanted to know if there is an admin which can manage all kinds of databases in a single interface, possibly similar to the one used by jennifer widom in her coursera lectures?

share|improve this question
With "admin" you mean some kind of GUI tool? – a_horse_with_no_name Feb 18 at 8:33
@a_horse_with_no_name yes. actually didn't know what exact term to use. Feel free to edit the question if you think is necessary – gopi1410 Feb 18 at 8:35
I'm happily using sql-workbench.net (cross-platform and cross-operating system). It doesn't have a specialized "DBA GUI" for specific DBMS features though - you (mostly) need to find your way around using pure SQL. – a_horse_with_no_name Feb 18 at 8:37
hm.. I fine even with pure SQL. Will check it out. Thanks for the link :) – gopi1410 Feb 18 at 8:40
There's Embarcadero's DB Artisan which works with heterogeneous environments, with distinct db servers. But it's a paid tool and you didn't specify what your options are. – Marian Feb 18 at 11:19

2 Answers

up vote 1 down vote

You can try Adminer (http://www.adminer.org/) which supports MySQL, PostgreSQL, SQLite, MS SQL, Oracle

An additional beauty with this is that its a single PHP file that is deployed to your server

share|improve this answer
up vote 0 down vote

SquirrelSQL http://squirrel-sql.sourceforge.net supports a wide range of jdbc compliant DB's.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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