/** * Public /status — human-readable platform health dashboard. * * Unlike /healthz (LB liveness JSON) and /readyz (DB readiness JSON), * /status renders a full HTML page anyone can load. Shows DB reachability, * autopilot state, totals (users/repos/gate runs), and the most recent * autopilot tick's task breakdown. * * Accessible without auth. Uses softAuth so the nav bar renders correctly * for logged-in visitors. */ import { Hono } from "hono"; import { sql } from "drizzle-orm"; import { db } from "../db"; import { users, repositories, gateRuns } from "../db/schema"; import { Layout } from "../views/layout"; import { softAuth } from "../middleware/auth"; import type { AuthEnv } from "../middleware/auth"; import { getLastTick, getTickCount } from "../lib/autopilot"; import { recentRedChecks } from "../lib/synthetic-monitor"; const status = new Hono(); status.use("*", softAuth); const started = Date.now(); function fmtUptime(ms: number): string { const s = Math.floor(ms / 1000); const d = Math.floor(s / 86400); const h = Math.floor((s % 86400) / 3600); const m = Math.floor((s % 3600) / 60); if (d > 0) return `${d}d ${h}h`; if (h > 0) return `${h}h ${m}m`; return `${m}m`; } status.get("/status", async (c) => { const user = c.get("user"); let dbOk = false; try { await db.execute(sql`SELECT 1`); dbOk = true; } catch { dbOk = false; } let userCount = 0; let repoCount = 0; let publicRepoCount = 0; let gateRunCount = 0; let greenRate: number | null = null; try { const [u] = await db.select({ n: sql`count(*)::int` }).from(users); userCount = Number(u?.n ?? 0); const [r] = await db .select({ n: sql`count(*)::int` }) .from(repositories); repoCount = Number(r?.n ?? 0); const [pr] = await db .select({ n: sql`count(*)::int` }) .from(repositories) .where(sql`${repositories.isPrivate} = false`); publicRepoCount = Number(pr?.n ?? 0); const [gr] = await db .select({ n: sql`count(*)::int` }) .from(gateRuns); gateRunCount = Number(gr?.n ?? 0); if (gateRunCount > 0) { const [g] = await db .select({ n: sql`count(*)::int` }) .from(gateRuns) .where(sql`${gateRuns.status} IN ('passed','repaired')`); greenRate = (Number(g?.n ?? 0) / gateRunCount) * 100; } } catch { // counts stay 0 } const tick = getLastTick(); const ticks = getTickCount(); const autopilotDisabled = process.env.AUTOPILOT_DISABLED === "1"; const uptimeMs = Date.now() - started; // BLOCK S4 — Show any red synthetic-monitor results from the last 24h // on the public status page. Never blocks the render. let recentIncidents: Awaited> = []; try { recentIncidents = await recentRedChecks(24, 10); } catch { recentIncidents = []; } const overallOk = dbOk && recentIncidents.length === 0; return c.html(

{overallOk ? "All systems operational" : "Service degraded"}

Live platform status. Reloads on refresh; no client-side polling.

Components

Database

Neon PostgreSQL

{dbOk ? "operational" : "down"}

Autopilot

Periodic platform-maintenance loop

{autopilotDisabled ? "disabled" : "running"}

Git Smart HTTP

Clone, fetch, push

operational

Platform stats

{userCount.toLocaleString()}

Developers

{repoCount.toLocaleString()}

Repositories

{publicRepoCount.toLocaleString()}

Public repos

{gateRunCount.toLocaleString()}

Gate runs

{greenRate === null ? "—" : `${greenRate.toFixed(1)}%`}

Green rate

{fmtUptime(uptimeMs)}

Uptime

{recentIncidents.length > 0 ? ( <>

Recent incidents (last 24h)

{recentIncidents.map((r) => (

{r.name} — {r.error || "(no error message)"}

{r.checkedAt.toISOString()}

))}

) : null}

Latest autopilot tick

{tick ? (

Finished {tick.finishedAt}

Total ticks this process {ticks}

{tick.tasks.map((t) => (

{t.name} {t.ok ? "ok" : `failed: ${t.error || "unknown"}`} {t.durationMs}ms

))}

) : (

{autopilotDisabled ? "Autopilot is disabled via AUTOPILOT_DISABLED=1." : "No ticks have completed yet. Check back after the first 5-minute interval elapses."}

)}

Liveness: /healthz · Readiness:{" "} /readyz · Metrics:{" "} /metrics · Platform JSON:{" "} /api/platform-status

); }); /** * Shields-style status badge. Reads the latest autopilot tick + DB * reachability and returns an SVG. Embed in READMEs with: * ![status](https://your-host/status.svg) */ status.get("/status.svg", async (c) => { let dbOk = false; try { await db.execute(sql`SELECT 1`); dbOk = true; } catch { dbOk = false; } const tick = getLastTick(); const lastOk = tick ? tick.tasks.every((t) => t.ok) : true; const overall = dbOk && lastOk; const label = "gluecron"; const value = overall ? "operational" : "degraded"; const fill = overall ? "#2da44e" : "#cf222e"; const labelW = 70; const valueW = overall ? 78 : 68; const totalW = labelW + valueW; const svg = ``; c.header("Content-Type", "image/svg+xml; charset=utf-8"); c.header("Cache-Control", "no-cache, max-age=0"); return c.body(svg); }); export default status;