• stackoverflow discussion
• SchemaSpy — open-source, and it'll suck out the table/column comments too

diagrams

• MySQL Workbench supports E-R diagramming
  • and it's easy to install on Ubuntu
• WWW SQL Designer — open source, and it looks nice