Take the 2-minute tour ×
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.

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

closed as off-topic by Justin Cave, Mat, Paul White, bluefeet, RolandoMySQLDBA Oct 7 '13 at 14:50

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." – Justin Cave, Mat, Paul White, bluefeet, RolandoMySQLDBA
If this question can be reworded to fit the rules in the help center, please edit the question.

    
With "admin" you mean some kind of GUI tool? –  a_horse_with_no_name Feb 18 '13 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 '13 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 '13 at 8:37
    
hm.. I fine even with pure SQL. Will check it out. Thanks for the link :) –  gopi1410 Feb 18 '13 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 '13 at 11:19
add comment

3 Answers 3

A bit too late, but the product Data Utensil aims to be just that. As of now, it supports SQL Server, My SQL, Oracle & Firebird (embedded).

Disclosure: I work for Maxotek, who created Data Utensil.

share|improve this answer
1  
You should explicitly identify your association with a product when answering a question with a link. I realize you said "our product", however this is not the same as saying something like "disclosure: I work for XYZ company, who created the xyz product" –  Max Vernon Oct 7 '13 at 3:30
    
seems pretty good. Will give it a try sometime soon –  gopi1410 Oct 7 '13 at 8:35
add comment

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
add comment

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

share|improve this answer
add comment

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