Robi Sen, friend and fellow IBM developerWorks author, has written a great piece on using SQL databases from within Eclipse. He’s done a great job on what was originally my idea and outline but which I just didn’t have the time to carry forward when the proposal was approved by IBM. The tutorial covers the use of SQLExplorer (my favourite interface) and Clay (which I admit I’ve probably never extracted the best from because I don’t have time to devote to it at the moment). From Robi’s own intro:
Learn how to use Eclipse and the SQLExplorer plug-in to connect to any database that supports a JDBC driver. These tools allow you to view database schemas, view table data, add and edit table data, and write, edit, and execute SQL. You will also learn how to use Azzurri Clay to create Entity Relationship Diagrams (ERDs), reverse-engineer databases, add tables, edit tables, delete tables, edit relationships, add indexes, and change your underlying data model into different SQL dialects.
If you do any sort of database development using Eclipse you should at least check out the article and better still, add the plug-ins to your environment.