MOSKitt , a free modeling platform for Eclipse (see this detailed interview to know more about it and the people behind the project) can now be used to model and generate spatial databases.
The MOSKitt-Geo extension adds a new primitive type named Geometry that can be used to indicate the spatial properties of the model elements. Then, this information is used to generate an spatial database DDL script. So far, Oracle Locator 10g and PostGIS extension for PostgreSQL are supported.
More info and a couple of videos showing MOSKitt-Geo in action here .