mysqlshow_all_tables.sh

#!/bin/bash

output="./output.txt"
db="db_name"
user="root"

tables=$(mysql -uroot ${db} -e "SHOW TABLES;")
for table in ${tables}
do
  if [ "${table}" == "Tables_in_dev_foo" ]; then
    continue
  fi
  mysqlshow -u${user} ${db} "${table//_/\_}" >> "${output}"
  echo "" >> "${output}"
done

output

Database: db_name  Table: alembic_version
+-------------+-------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field       | Type        | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
+-------------+-------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| version_num | varchar(32) | utf8mb4_general_ci | NO   | PRI |         |       | select,insert,update,references |         |
+-------------+-------------+--------------------+------+-----+---------+-------+---------------------------------+---------+

...