gistfile1.txt

client =  Mysql2::Client.new(:default_file => 'my-client.cnf', :default_group => 'client'")
results = client.query("SHOW DATABASES")
results.each do |row|
puts "#{row['Database']}"
end

---

Output

information_schema
monitoring
mysql
notification

---

What I want to do is then loop through the output and run this query, but exclude mysql and information_schema

mysql> SELECT COUNT(DISTINCT `table_name`) FROM `information_schema`.`columns` WHERE `table_schema` = 'monitoring';
+------------------------------+
| COUNT(DISTINCT `table_name`) |
+------------------------------+
|                            4 |
+------------------------------+