AD-01 Super Admin Platform Dashboard | Admin App Specification

Live Atomic Design System Simulation

Design System Parity: 100%

Managed Clients

48 +12% mo

36 Standard, 12 Premium

Total MRR

$1,032 $12.3k ARR

Stripe billing automated

Active Trials

14 7d window

6 converting this week

Support Queue

3 Open 0 urgent

Avg response: 18 min

Active Organizations Directory View All Clients →

Organization	Plan Tier	Status	Employees	Actions
Apex Logistics Global	Premium $29	Active	42 Active	Manage
Beacon Construction LLC	Standard $19	Trial (3d)	18 Active	Manage

Super Admin Telemetry Dashboard Wireflow

Click to Zoom Fullscreen

graph LR
    DashboardPage[AD-01 Dashboard Component] --> LoadStats[getAdminStats Function]
    LoadStats --> RPC[supabase.rpc 'get_all_companies_admin']
    LoadStats --> TicketsQuery[supabase.from 'support_tickets']
    RPC --> ScaleCard[Platform Scale Card: Managed Teams]
    RPC --> FunnelCard[Subscription Funnel Card: Trials & Conversion]
    RPC --> RevenueCard[Financial Card: MRR & ARR Calculations]
    TicketsQuery --> SupportCard[Operations Card: Open Tickets & Resolution Rate]

Dashboard Server Component & Query Tree

• admin/src/app/dashboard/page.tsx (Server Component)
• RPC: get_all_companies_admin() (Fetches companies, employee_count, trial_ends_at, subscription_status)
• Query: support_tickets (Selects id, status)

Super Admin Dashboard Security Guardrails

Super Admin Table Whitelist: Only users present in the super_admins table can invoke server RPC calls or access dashboard telemetry metrics.

sequenceDiagram
    autonumber
    actor Admin as Super Admin Operator
    participant Page as dashboard/page.tsx
    participant Supabase as Supabase Server Client
    participant DB as PostgreSQL Database

    Admin->>Page: Request /dashboard
    Page->>Supabase: Promise.all([rpc('get_all_companies_admin'), from('support_tickets')])
    Supabase->>DB: Execute Stored Procedure & Select Queries
    DB-->>Supabase: Return Raw Companies & Tickets Arrays
    Page->>Page: Calculate MRR, ARR, Conversion Rate, Resolution %
    Page-->>Admin: Render Server Component with MetricCards

Component	Codebase Path / Token
MetricCard Container	admin/src/components/owner/ownerUi.tsx
Platform Scale Card	admin/src/app/dashboard/page.tsx (Line 148)
Subscription Funnel Card	admin/src/app/dashboard/page.tsx (Line 174)
Financial & Revenue Card	admin/src/app/dashboard/page.tsx (Line 197)
Operations & Support Card	admin/src/app/dashboard/page.tsx (Line 221)

Super Admin Platform Overview

Page Visual Switcher

Super Admin Telemetry Dashboard Wireflow

Super Admin Platform Overview

Page Visual Switcher

Super Admin Telemetry Dashboard Wireflow

AD-01 Super Admin Dashboard Wireflow