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

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.

3 Answers

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

share|improve this answer
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

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

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