Inspect a SQLAlchemy Model

sqlalchemy-inspect.py

# http://docs.sqlalchemy.org/en/latest/faq/ormconfiguration.html#how-do-i-get-a-list-of-all-columns-relationships-mapped-attributes-etc-given-a-mapped-class
from sqlalchemy import inspect
from models import *

mapper = inspect(Task)

for f in 'attrs column_attrs relationships all_orm_descriptors columns'.split():
    print '%s:'% f
    for x in  getattr(mapper, f):
        print '   %s' % x

for f in 'mapped_table local_table'.split():
    print '%s: %s' % (f, getattr(mapper, f))