Clay is a database design tool that runs as a plug-in in the Eclipse IDE. It has an intuitive user interface for graphically designing database models. Clay can also create a database model by reverse engineering an existing database. It can also generates the SQL (DDL) code appropriate for your database.

Clay has been tested on Eclipse versions 2.1.1, 2.1.2 and 2.1.3 running on Windows 2000/XP with a Java 1.4 (J2SE). For now these are the only platforms being supported.

Clay Core Features

• Intuitive user interface
• Graphically design database models.
• Dedicated editors for Schemas, Tables, Indexes, Unique Keys, and Foreign Keys.
• Reverse engineer existing databases using JDBC.
• User-configurable SQL script generation.
• Self-document your database.
• Open source SQL dialects supported: HSQLDB, MySQL, PostgreSQL, Firebird, ANSI SQL-92, SAP DB, McKoi.
• Switch SQL dialects whenever you want.
• Auto-validate your database model.
• Dynamically updated outline view.
• Thumbnail outline view for navigating large database models.
• Zoom support for large database models.
• Align database tables vertically or horizontally.
• Switch between supported languages, English and Japanese, without restarting.