SQL Designer is the tool available to generate schema for any database for mysql,postgresql, oracle and many more..It shows you pictorial presentation of how tables are related to each others in the database so that you can easily design a database with team discussion on the fly.Having design your database you can generate DDL statements.Demo of the tool can be found by following the link http://ondras.zarovi.cz/sql/demo/.