Ask HN: How do you create your databases?

Let's keep it to traditional entity/relationship databases.

How do you create you databases? Say that you are starting a new project, do you write all the SQL to generate dbs, tables views by hand, or do you use tools to, for instance, graphically create the tables and and then generate the SQL from that?

If so, what tools do you use?