1 click Mysql schema to convert chart?

Question

I have so many tables and FK relationships it's hard to track and visualize all this. Speard through several excel docs. I already entered it in mysql, but I want to display a data model diagram that links tables together with all FKs.

How to do this, except manually? I am open to tools of the third part, if they are free.

Answer 1

I am using phpMyAdmin on my local server.

PhpMyAdmin 3 has this constructor function that shows the relationships between different tables and its columns.

Answer 2

MySQL Workbench.

, . , MySQL, .