Which module facilitates looking up database schemas of custom content type? I am setting up some reports using DB API to query custom content fields, and rendering them in tables and charts. I am looking for a way to easily look up the names of tables and fields in the Drupal DB.

My Question: Is there a Devel-type module that provides an easy reference of the live DB schema?

Currently I'm using drush sql-cli and/or phpmyadmin, so the solution should be something simpler than that.
I think the Schema Module can handle that...


  
  Schema documentation: hyperlinked display of the schema's embedded documentation explaining what each table and field is for.
  


I confess I haven't tried it but the module page mentions 


  the INFORMATION_SCHEMA database that the Schema module uses to inspect the database.


so I imagine it has the functionality you're looking for, plus inspection of the live db if you need it.

Or if you don't mind wading through a large krumo array you can always use drupal_get_schema()

dpm(drupal_get_schema());