SchemaGraph 1.0

This PHP script creates graphs out of MySQL database schemas
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
price:
FREE!
developed by:
Weston Ruter
homepage:
weston.ruter.net
license type:
GPL
operating system(s):
Windows / Linux / Mac OS / BSD / Solaris
category:
C: \ Development Tools \ Schema

FREE!

In a hurry? Add it to your Download Basket!

user rating 1

5.0/5
 

0/5

Rate it!
1 Screenshot
SchemaGraph - Database schema

Add your review!

SUBMIT