MusicBrainz × ClickHouse

Fast exploratory dashboard on top of a sizable MusicBrainz artist dataset.

Source code: github.com/cleovneumann/musicbrainz-clickhouse-stats

Build log / write-up: cleovn.dev/til/2026-02-16-building-clickhouse-powered-app-end-to-end

rows read: 2,803,984 · compute: 39.93 ms

Artists

2,803,984

Distinct areas

15,412

Ended artists

175,582

Active artists

2,628,402

rows read: 135,272 · compute: 14.99 ms

Top area IDs by artist count

rows read: 2,803,984 · compute: 153.44 ms

Most common artist initials

Pareto concentration

rows read: 135,272 · compute: 27.98 ms

79 out of 13812 areas ( 0.57%) cover 80% of artists.

Pareto by area (artist concentration)

Materialized rollup speed demo (same top-area query)

Raw table

rows read: 2,803,984 · compute: 37.30 ms

Materialized rollup

rows read: 15,413 · compute: 4.17 ms

Most edited artists

rows read: 2,803,984 · compute: 436.47 ms

  • A.D.A.M. Music Project9 edits
  • Xאתני9 edits
  • Madilyn Mei7 edits
  • anyoca5 edits
  • Martina la Peligrosa5 edits
  • Kleerup5 edits
  • Lockyn5 edits
  • 3rdEyeGirl5 edits
  • Kevens5 edits
  • MinimusNoah5 edits
  • Vito Venusian5 edits
  • MIscha4 edits

Recently updated artist records

rows read: 2,803,984 · compute: 138.41 ms

  • DJ Tones2026-02-14 00:19:31.213508+00
  • inch'allah2026-02-14 00:13:01.296062+00
  • Röda Stan2026-02-14 00:10:07.491671+00
  • Sam Hogin2026-02-14 00:08:37.959132+00
  • Bob & The Rockbillies2026-02-14 00:08:36.126676+00
  • Phil Barnhart2026-02-14 00:04:26.622288+00
  • Black Brothers2026-02-14 00:00:37.47934+00
  • Ana Stamp2026-02-14 00:00:30.575467+00
  • Waylon Jennings and The Waymore Blues Band2026-02-14 00:00:25.932088+00
  • ZDaddy2026-02-14 00:00:25.544095+00