Best software (or other) solution for modeling existing complex MySQL schema

Question

What's a good solution for modeling an existing and very complicated MySQL schema. Preferably with the following features:

• completely visual
• drill down on click
• shows keys, indexes
• gives sample data per field*

*as fields aren't always intuitively named

Thanks! Emile

Answer 1

Try MySQL Workbench

MySQL Workbench provides DBAs and developers an integrated tools environment for:

• Database Design & Modeling
• SQL Development (replacing MySQL Query Browser)
• Database Administration (replacing MySQL Administrator)

You can also check this interesting post Top 10 MySQL GUI Tools