SELECT
    SUBSTRING_INDEX(table_schema, '_', 1) as tool
  , count(1) as tables
FROM information_schema.TABLES
WHERE table_schema regexp '^[psu][0-9]'
GROUP BY tool
ORDER BY tables desc;

-- labsdb1001.eqiad.wmnet

+--------------+--------+
| tool         | tables |
+--------------+--------+
| s51187       |    355 |
| p50380g50497 |    159 |
| p50380g50491 |    105 |
| u2815        |     79 |
| s51111       |     73 |
| p50380g50692 |     54 |
| p50380g50512 |     49 |
| s52365       |     49 |
| u3532        |     46 |
| u4817        |     35 |
| p50380g50816 |     30 |
| s51454       |     26 |
| p50380g50728 |     21 |
| p50380g50921 |     21 |
| u12219       |     18 |
| p50380g50494 |     17 |
| s51362       |     16 |
| s51127       |     14 |
| p50380g50551 |     12 |
| s51892       |     11 |
| u3617        |      9 |
| s52690       |      8 |
| s53311       |      8 |
| s52467       |      7 |
| u2041        |      7 |
| s51755       |      6 |
| s51154       |      6 |
| s53381       |      6 |
| s51698       |      5 |
| p50380g50553 |      5 |
| s52490       |      5 |
| u3533        |      4 |
| s51329       |      4 |
| p50380g50900 |      4 |
| s52037       |      4 |
| u2402        |      4 |
| u2248        |      4 |
| u11049       |      3 |
| u3356        |      3 |
| u3945        |      3 |
| u4301        |      2 |
| u2043        |      2 |
| u3949        |      2 |
| s51306       |      2 |
| u3290        |      2 |
| u3570        |      2 |
| p50380g40014 |      1 |
| s51058       |      1 |
| u2117        |      1 |
| s51172       |      1 |
| s53012       |      1 |
| u2843        |      1 |
| u10276       |      1 |
| s51055       |      1 |
| s52744       |      1 |
| s52107       |      1 |
| u2745        |      1 |
| s51223       |      1 |
| s51417       |      1 |
| u2029        |      1 |
| u4974        |      1 |
| p50380g50592 |      1 |
| s51206       |      1 |
| s52524       |      1 |
| s53151       |      1 |
| u3214        |      1 |
| p50380g50838 |      1 |
| s51073       |      1 |
| s53024       |      1 |
| u3182        |      1 |
| p50380g50824 |      1 |
| s51334       |      1 |
+--------------+--------+
72 rows in set (1.09 sec)

-- labsdb1003.eqiad.wmnet

+--------------+--------+
| tool         | tables |
+--------------+--------+
| s51187       |    688 |
| s51117       |    343 |
| p50380g50497 |    261 |
| p50380g50921 |    138 |
| u2815        |     89 |
| s51362       |     86 |
| p50380g50491 |     73 |
| s51111       |     72 |
| p50380g50769 |     39 |
| s52107       |     35 |
| u3710        |     33 |
| s51892       |     33 |
| s52861       |     25 |
| u4529        |     20 |
| p50380g50729 |      9 |
| p50380g50553 |      8 |
| p50380g50692 |      7 |
| s51072       |      5 |
| s51580       |      4 |
| s52957       |      3 |
| p50380g50552 |      3 |
| s53311       |      3 |
| s51206       |      2 |
| u2170        |      2 |
| s51447       |      2 |
| u3949        |      2 |
| s51430       |      1 |
| s53012       |      1 |
| s51392       |      1 |
| u3617        |      1 |
| s51837       |      1 |
| u2718        |      1 |
| s52690       |      1 |
| s52524       |      1 |
| s51172       |      1 |
+--------------+--------+
35 rows in set (1.36 sec)