{"id":"293daaf8-228c-4c42-9584-7f1c3b12afd3","share_slug":"dikjdnv0","kind":"query","title":"MCP on Hacker News, month by month, with the sparkline drawn in the query","summary":"One statement over hackernews.items: monthly counts of the token 'mcp' since January 2025, with bar() drawing the sparkline in the result set. A hump, not a line: the peak was March 2026. hasToken is a whole-token match over a full-text index, so it counts the token, not the sense; rows land every few minutes, so your run will differ from this one by the day. Measured 2026-09-09: 0.76 s, 6,027,149 rows read, $0.0030 of machine time, $0 charged.","payload":{"params":[],"snapshot":{"as_of":"2026-09-09T13:28:32Z","billing_mode":"free_slack","burden_nanodollars":3009072,"columns":[{"name":"m","type":"Nullable(Date)"},{"name":"n","type":"UInt64"},{"name":"spark","type":"String"}],"duration_ms":765,"freshness_lag_seconds":150,"read_bytes":2075137127,"read_rows":6027149,"row_count":20,"rows":[["2025-01-01",65,"▌"],["2025-02-01",103,"▉"],["2025-03-01",946,"████████▌"],["2025-04-01",1209,"██████████▉"],["2025-05-01",1410,"████████████▊"],["2025-06-01",1188,"██████████▊"],["2025-07-01",1270,"███████████▌"],["2025-08-01",1027,"█████████▎"],["2025-09-01",809,"███████▎"],["2025-10-01",819,"███████▍"],["2025-11-01",809,"███████▎"],["2025-12-01",833,"███████▌"],["2026-01-01",968,"████████▊"],["2026-02-01",1637,"██████████████▉"],["2026-03-01",2060,"██████████████████▋"],["2026-04-01",1407,"████████████▊"],["2026-05-01",1049,"█████████▌"],["2026-06-01",881,"████████"],["2026-07-01",959,"████████▋"],["2026-08-01",1113,"██████████"]],"spend_nanodollars":0,"truncated":false},"sql":"SELECT toStartOfMonth(original_timestamp) AS m, count() AS n,\n       bar(n, 0, 2200, 20) AS spark\nFROM hackernews.items\nWHERE original_timestamp >= '2025-01-01'\n  AND original_timestamp < toStartOfMonth(today())\n  AND hasToken(search_text_lc, 'mcp')\nGROUP BY m ORDER BY m LIMIT 100"},"is_public":true,"created_at":"2026-09-09T13:30:18Z","updated_at":"2026-09-09T13:30:18Z"}