# box/Anemometer

Box SQL Slow Query Monitor

Repository: https://github.com/box/Anemometer
Canonical: https://ross.abutalabs.com/products/anemometer
Language: JavaScript
License: Apache-2.0
License Family: permissive
Last push: 2021-12-08T23:39:55+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 5276, "days_push": 1729, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1392, forks 306 (observed 2026-08-28T04:04:36.106659+00:00)

## What it is
Box Anemometer is a PHP web application for analyzing MySQL slow query logs collected via pt-query-digest. It stores query analysis data in MySQL and provides a web UI to identify and review problematic queries.

## Use cases
- analyze mysql slow query logs
- find slow queries in mysql database
- review and explain problematic sql queries
- monitor query performance across mysql instances
- visualize pt-query-digest output in a web ui

## When to choose
- you run MySQL and want a self-hosted UI over pt-query-digest output
- you need to triage and annotate slow queries across many MySQL servers

## When to avoid
- you use non-MySQL databases like PostgreSQL
- you want a modern actively developed monitoring stack (project is in maintenance mode)

## Facets
- artifact type: application
- maturity: maintenance
- function: monitoring, analytics, database, http-server
- domain: databases, monitoring, performance
- platform: php, self-hosted
- tags: mysql, slow-query-log, query-analysis, pt-query-digest, database-performance, devops, web-server, linux

## Member repositories
- box/Anemometer (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:36.106659+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:39:31.854456+00:00, confidence not recorded.
  - readme: https://github.com/box/Anemometer (fetched 2026-08-28T04:04:36.106659+00:00, sha a99de2080553)
- Data as of 2026-08-30T08:39:29.467469+00:00.