get-mysql-db-tables-columns.js

function generateSql(db) {
  return `
    SELECT
      t.table_name, 
      c.column_name, 
      c.data_type
    FROM 
      INFORMATION_SCHEMA.TABLES t JOIN
      INFORMATION_SCHEMA.COLUMNS c ON
        t.table_schema = c.table_schema AND
        t.table_name = c.table_name 
    WHERE
      t.table_schema = '${db}'
    ORDER BY 
      t.table_schema, 
      t.table_name, 
      c.ordinal_position`
}