I use these commands to see drupal data, but not often enough to remember them when I need them.
drush sqlq --database=default "show tables"
drush sqlq --database=default "describe tablename"
drush sqlq --database=default "SELECT * FROM tablename"
drush sqlq --database=default "TRUNCATE TABLE tablename"
Get the number of rows in a table: