If you’re looking for something to generate entity/relationship (E/R) diagrams for your MySQL databases, check out DBDesigner 4. It’s a GPL solution.

http://www.fabforce.net/dbdesigner4/