Fathom is Python3 package that provides database inspection. It creates an objective model of database schema and allows you to easily retrieve information about it. Currently Fathom works with:

• Sqlite3
• PostgreSQL
• MySQL
• Oracle

If you wish to see Fathom in action you can take a look at either Fathom-Tools which provide some small database tools and utility functions or QFathom which is a graphical database inspection tool written using PyQt. All code is built on top of Fathom library.

Example

Example use on sample database created by Django project:

>>> import fathom
>>> db = fathom.get_sqlite3_database('example/example.db')
>>> list(db.tables.keys())
['auth_permission', 'auth_group', 'auth_user_user_permissions', 'django_site',
'fbinteg_facebookuserprofile', 'django_content_type', 'django_session','auth_user_groups',
'decisions_vote', 'decisions_optioncomment', 'decisions_unpublishedoption', 
'django_admin_log', 'auth_group_permissions', 'decisions_decision', 
'common_temporaryfile', 'common_settings', 'decisions_decisioncomment',
'common_userprofile', 'auth_message', 'decisions_option', 'auth_user', 
'decisions_unpublisheddecision']
>>> list(db.tables['auth_user'].columns.keys())
['username', 'first_name', 'last_name', 'is_active', 'email', 
'is_superuser', 'is_staff', 'last_login', 'password', 'id', 'date_joined']