🏠 Overview › 👥 User Roles ›📖 Monitor Real-Time Subscription Health Across Organ...

Monitor Real-Time Subscription Health Across Organizations

The Global Administrator needs visibility into the real-time subscription infrastructure that powers coordinator dashboards and assignment status tracking. Supabase Realtime channels are used for live assignment status updates, peer mentor availability changes, and notification events. The admin must be able to detect channel connection failures, high reconnection rates, or throughput bottlenecks that degrade the user experience for coordinators managing active assignments.

HIGH story-supabase-backend-core-global-admin-006 5 pts
5
Story Points
High
Priority
Supabase Backend Core
Feature

User Story

As a Global Administrator
I want to monitor the health and performance of Supabase Realtime channel subscriptions across all active organizations
So that So that coordinators and peer mentors receive live updates on assignment statuses and availability without polling failures going undetected

Acceptance Criteria

  • Given multiple organizations have active real-time subscriptions, when the admin views Supabase platform metrics, then active connection counts and message throughput are visible per channel
  • Given a Realtime channel experiences repeated disconnections, when the reconnection logic executes, then the subscription recovers without manual intervention and the admin can see the reconnection events in logs
  • Given the admin reviews channel configuration, when listing active subscriptions, then each channel shows its filter criteria (e.g., assignment_id, organization_id) confirming no cross-organization data leakage via Realtime
  • Given Supabase Realtime throughput limits are approached, when the admin checks platform usage, then warnings are visible before limits are reached, allowing capacity planning
  • Given a channel subscription is cleaned up after a user session ends, when the admin reviews active connections, then stale subscriptions are not accumulating

Business Value

Real-time subscriptions enable coordinators to see live assignment status updates and peer mentor availability — a key differentiator over polling-based approaches. For Blindeforbundet's encrypted assignment dispatch workflow, coordinators rely on real-time delivery confirmations to know when sensitive personal data has been received. Undetected subscription failures would silently degrade this critical workflow, potentially delaying time-sensitive peer mentor assignments.

Components

Supabase Backend Core
Related Feature
Global Administrator
User Role