Python Hyperschema is an open source public domain project that creates useful and really cool HTML hypermaps from SQL database schema, consisting of two small PL/SQL files and one Python (or C) source code file. The generated HTML pages have mousover data displays for all foreign keys, hyperlinked to the foreign key tables, as well as a hyperlinked list of all foreign keys pointing to each table and a master index of all tables.

Version 3.0 is now out, in addition to the translation from C to Python this has minor bug fixes over the version 2.1 release.

Instructions are in the README file included with the .zip and .tgz distributions at the Sourceforge project site for Hyperschema.

You should take a look at this simple example schema hypermap if you're interested in the project.

Norman Dunbar of LYNX Financial Systems in the UK has contributed to the original project, providing bug fixes and C cross-compilation advice. Thanks, Norman!

If you find Hyperschema to be useful, you may also be interested in HyperSQL. HyperSQL is like a doxygen for SQL, hypermapping SQL views, packages, procedures, and functions to HTML source code listings and showing all code locations where these are used. The internal "where used" functionality also scans C++ and Java source files.

Randy Phillips

Python Hyperschema is hosted by SourceForge.net