MariaDB [prometheusconfig]> select cgm.id, cg.name, cgm.type, cgm.value from projects as p join contact_groups as cg join contact_group_members as cgm on p.default_contact_group_id=cg.id and cg.id=cgm.contact_group_id where p.name = 'deployment-prep';
+----+-------------+-------+----------------------------------------+
| id | name        | type  | value                                  |
+----+-------------+-------+----------------------------------------+
|  9 | betacluster | EMAIL | betacluster-alerts@lists.wikimedia.org |
| 10 | betacluster | IRC   | #wikimedia-releng                      |
| 11 | betacluster | PHAB  | PHID-PROJ-dthybs72vou24ydhgpbq         |
+----+-------------+-------+----------------------------------------+
3 rows in set (0.003 sec)

MariaDB [prometheusconfig]> describe alerts;
+-------------+---------------+------+-----+---------+----------------+
| Field       | Type          | Null | Key | Default | Extra          |
+-------------+---------------+------+-----+---------+----------------+
| id          | int(11)       | NO   | PRI | NULL    | auto_increment |
| project_id  | int(11)       | NO   | MUL | NULL    |                |
| name        | varchar(255)  | NO   |     | NULL    |                |
| expr        | varchar(2048) | NO   |     | NULL    |                |
| duration    | varchar(32)   | NO   |     | 1m      |                |
| severity    | varchar(32)   | NO   |     | warn    |                |
| annotations | longtext      | NO   |     | NULL    |                |
+-------------+---------------+------+-----+---------+----------------+
7 rows in set (0.003 sec)

MariaDB [prometheusconfig]> describe scrapes;
+------------+----------------------------------+------+-----+----------+----------------+
| Field      | Type                             | Null | Key | Default  | Extra          |
+------------+----------------------------------+------+-----+----------+----------------+
| id         | int(11)                          | NO   | PRI | NULL     | auto_increment |
| project_id | int(11)                          | NO   | MUL | NULL     |                |
| name       | varchar(255)                     | NO   |     | NULL     |                |
| path       | varchar(255)                     | NO   |     | /metrics |                |
| scheme     | enum('tcp','udp','http','https') | NO   |     | http     |                |
+------------+----------------------------------+------+-----+----------+----------------+
5 rows in set (0.004 sec)

MariaDB [prometheusconfig]> select p.name, a.* from alerts a join projects p on
a.project_id = p.id where p.name = 'quarry'\G
*************************** 1. row ***************************
       name: quarry
         id: 29
 project_id: 16
       name: Down
       expr: up{project="quarry",job="app"} == 0
   duration: 5m
   severity: critical
annotations: {"summary": "Quarry application is unreachable"}
1 row in set (0.002 sec)

MariaDB [prometheusconfig]> select s.id, p.name, s.name, s.scheme, sds.host, s.path, sds.port from scrapes s join scrape_discovery_static sds on s.id = sds.scrape_id join projects p on s.project_id = p.id where p.name = 'quarry' and s.name
= 'app'\G
*************************** 1. row ***************************
    id: 10
  name: quarry
  name: app
scheme: https
  host: quarry.wmcloud.org
  path: /app/metrics
  port: 443
1 row in set (0.004 sec)

MariaDB [prometheusconfig]> show tables like 'scrape\_%';
+----------------------------------------+
| Tables_in_prometheusconfig (scrape\_%) |
+----------------------------------------+
| scrape_blackbox_dns                    |
| scrape_blackbox_http                   |
| scrape_discovery_openstack             |
| scrape_discovery_static                |
+----------------------------------------+
4 rows in set (0.003 sec)

MariaDB [prometheusconfig]> describe scrape_blackbox_http;
+------------------------+--------------+------+-----+---------+----------------+
| Field                  | Type         | Null | Key | Default | Extra          |
+------------------------+--------------+------+-----+---------+----------------+
| id                     | int(11)      | NO   | PRI | NULL    | auto_increment |
| scrape_id              | int(11)      | YES  | UNI | NULL    |                |
| method                 | varchar(255) | NO   |     | NULL    |                |
| headers                | longtext     | YES  |     | NULL    |                |
| follow_redirects       | tinyint(1)   | NO   |     | NULL    |                |
| valid_status_codes     | longtext     | YES  |     | NULL    |                |
| require_body_match     | longtext     | YES  |     | NULL    |                |
| require_body_not_match | longtext     | YES  |     | NULL    |                |
| host                   | varchar(255) | YES  |     | NULL    |                |
+------------------------+--------------+------+-----+---------+----------------+
9 rows in set (0.004 sec)

MariaDB [prometheusconfig]> select s.id, p.name, s.name, sbbh.host, sbbh.method, sbbh.valid_status_codes, sbbh.require_body_match from scrape_blackbox_http sbbh
 join scrapes s on sbbh
G
*************************** 1. row ***************************
                id: 21
              name: project-proxy
              name: main-nginx-https
              host: download.wmcloud.org
            method: GET
valid_status_codes: [200]
require_body_match: ["Index of"]
*************************** 2. row ***************************
                id: 28
              name: project-proxy
              name: main-proxy-https-vip
              host: NULL
            method: GET
valid_status_codes: [404]
require_body_match: ["Not Found"]
2 rows in set (0.003 sec)