⚡
Dashboard
// PLATFORM INTELLIGENCE

PLATFORM-WIDE METRICS
AT A GLANCE.

Sigma is the analytics layer for the entire MelTuc ecosystem. It aggregates 19 live KPIs from across every active blueprint — DRA research output, BRI idea velocity, AI cost burn, Kronos job success rates, SRM ticket volume, Herald alert count, GHT repo tracking, and more — into a single dashboard that auto-refreshes every 5 minutes. Set threshold alert rules on any metric and Sigma notifies you via Telegram and Herald the moment a number crosses your line.

The centrepiece is a 14-day stacked bar chart showing DRA, BRI, and RRV pipeline throughput per day — giving you an instant visual read on whether content generation is accelerating, stalling, or idle. Supporting stat panels break out AI cost tracking, platform health indicators, and content pipeline depth all in one place.

PREMIER v1.0.0 ACTIVE
19
Live KPIs
14d
Pipeline Chart
12+
Source Tables
∞
Alert Rules
// HOW IT WORKS

From Blueprint Tables to Dashboard in 5 Steps

Sigma queries a dozen existing blueprint tables every 5 minutes and surfaces 19 live KPIs — with zero data duplication. Its only table of its own holds your alert rules.

01
Page Load / Refresh
The dashboard opens or the 5-minute auto-refresh fires, triggering a single fetch to /sigma/api/platform-metrics.
02
19 SQL Queries Run
Each KPI is a separate COUNT or SUM query against a live blueprint table — DRA, BRI, RRV, AIF, NLG, TKN, Kronos, SRM, Herald, GHT, FMR, PRL — all defined in one metric registry.
03
Safe Aggregation
Every query is individually wrapped in try/except. A missing or broken table returns 0 — the rest of the dashboard continues unaffected.
04
KPI Grid + Chart Render
The KPI tiles, 14-day stacked bar chart, and 3 stat panels all update simultaneously from the single API response — no separate calls.
05
Color-Coded Output
Teal for content throughput, amber for AI costs, red for errors and alerts. At a glance you know whether the platform is healthy or needs attention.
// KPI OVERVIEW GRID

Every Platform Number in One Grid

The top section of the Sigma dashboard is a 4-column KPI grid of headline metrics. Each tile shows a label and a live number — refreshed on page load and every 5 minutes automatically. Teal values are content/throughput metrics. Amber values are AI cost numbers. Red values are error/failure counts. All values come from a single GET /sigma/api/platform-metrics call that runs 19 separate SQL queries, each individually wrapped in try/except.

meltuc.tech/sigma/app
SIGMA ANALYTICS
Last updated 3m ago
↻ Refresh
12
DRA Reports (7d)
31
BRI Ideas (7d)
8
RRV Published (7d)
47
NLG Pool Ready
$2.81
AI Cost (7d)
$9.33
AI Cost (30d)
284
Kronos Runs (7d)
3
Kronos Errors (7d)
7
SRM Open
2
Herald Unacked
1,842
GHT Repos
14
FMR Active Models
// 14-DAY PIPELINE THROUGHPUT CHART

Content Generation at a Glance

Below the KPI grid, a Chart.js bar chart shows per-day DRA, BRI, and RRV output over the trailing 14 days. A generate_series query fills in zero values for days with no output — so a flat day is visible rather than absent. Teal bars are DRA research reports, amber bars are BRI ideas, blue bars are RRV blog posts. The chart redraws cleanly on every refresh without page reload.

meltuc.tech/sigma/app — Pipeline Throughput
PIPELINE THROUGHPUT — 14 DAYS
DRA BRI RRV
04-26
04-27
04-28
04-29
04-30
05-01
05-02
05-03
05-04
05-05
05-06
05-07
05-08
05-09
// THREE SUPPORTING STAT PANELS

Content, AI, and Health — At a Glance

Below the chart, three key-value panels drill deeper into three platform dimensions. The Content Pipeline panel shows 30-day DRA output, RRV drafts, and PRL prompt library size. The AI Infrastructure panel shows FMR model count alongside 7d and 30d Claude API cost. The Platform Health panel computes the Kronos job success rate and shows open SRM tickets and Herald unacked alerts.

meltuc.tech/sigma/app — Stat Panels
Content Pipeline
DRA (30d)48
RRV Drafts12
PRL Prompts203
AI Infrastructure
FMR Models14
Cost (7d)$2.81
Cost (30d)$9.33
Platform Health
Job Success Rate98.9%
SRM Open7
Unacked Alerts2
// WHAT YOU GET

Everything You Need to Monitor Platform Health

Sigma reads from a dozen existing blueprint tables and owns only one table of its own (alert rules). Every query is individually wrapped in try/except, so a missing table degrades gracefully.

📊
Content Pipeline KPIs
DRA research reports, BRI ideas, and RRV blog posts tracked over 7d and 30d windows. See your content generation velocity at a glance.
💰
AI Cost Tracking
Claude API spend summed from tkn_turns.cost_usd over 7-day and 30-day windows — always current, never stale.
⚙️
Kronos Job Health
Total runs and error counts from kronos_runs in the last 7 days. Job success rate computed automatically.
📬
NLG Content Pool
Count of ready-to-use newsletter items where consumed_at IS NULL — your newsletter backlog depth at a glance.
🚨
Herald Unacked Alerts
Count of unacknowledged Herald alerts. Non-zero means active issues need attention — visible in red immediately on the dashboard.
🔍
GHT + SRM + PRL + FMR
GitHub repo count, open SRM tickets, active PromptLibrary prompts, and free-tier AI models registered in FMR — all in one grid.
📈
14-Day Pipeline Chart
Stacked bar chart showing per-day DRA, BRI, and RRV output over the trailing 14 days. Zero-fill via generate_series means flat days are visible, not absent.
🔔
Threshold Alert Rules
Define rules on any metric — metric_key + operator (>, >=, <, <=, ==) + threshold. Kronos evaluates them on a schedule and fires Telegram + Herald alerts when breached.
📥
CSV Export & MCP Access
Pull every metric as a CSV with ?format=csv, or query the same data programmatically — metric and alert-rule endpoints accept a SWIP session or an MCP key.
// GET STARTED

Know Your Platform Numbers. Always.

19 live KPIs. 14-day throughput chart. AI cost burn. Threshold alerts. All in one dashboard.

PREMIER v1.0.0 ACTIVE

Requires a MelTuc account. Create one free.