SchemaGraph 1.0

This PHP script creates graphs out of MySQL database schemas
SchemaGraph - Database schema
  1 Screenshot
It queries the MySQL information_schema, getting all of the necessary information about a database's (InnoDB) tables.

The graphic is built with SVG and can be interacted with.

To use, just edit schemagraph.php with the appropriate database connection details and then run it from a web server.

Main features:

  • Tables in the schema are placed equidistantly around a circle.
  • Clicking the image causes the graph to rotate.
  • Foreign key constraints are represented by b├ęzier curves connecting table labels.
  • Hovering over a table or a constraint causes the table's label to highlight along with all of its constraint paths (both incoming and outgoing).
  • The paths representing incoming foreign key constraints are highlighted in a different color than outgoing constraints.
  • Multiple constraints between the same two tables are prevented from overlapping by giving a unique curve to each of the lines.
  • Hovering over a constraint produces a tooltip which shows the names of the fields that are linked by the constraint.

last updated on:
February 14th, 2011, 15:49 GMT
license type:

GPL: GNU General Public License

developed by:
Weston Ruter
operating system(s):
Windows / Linux / Mac OS / BSD / Solaris
C: \ Development Tools \ Schema
Download Button

In a hurry? Add it to your Download Basket!

user rating 1



Rate it!

Add your review!