๐Ÿฅ› Dairy HR Console
Provisioning ยท Subscriptions ยท Permissions ยท Analytics
connectingโ€ฆ
Analytics Dashboard
Live from Supabase ยท Demo data shown if tables not found
๐Ÿ“ˆ Calculations Over Time
๐Ÿงฎ By Product
๐Ÿ‘ฅ Users by Role
๐Ÿ’ณ Monthly Revenue (โ‚น)
Signup Requests
Review, verify payment and provision new users
User Management
Edit role, plant, products, tabs โ€” runs SQL in Supabase
Plants
Manage dairy plant registrations
Subscriptions
Payment tracking and subscription periods
Tab Permissions
Control which tabs each role sees in the dairy calculator
Stored in tab_permissions ยท Applied per role at login ยท Click ๐Ÿ‘/๐Ÿšซ to toggle
โšก SQL Runner
Execute SQL directly in Supabase via Management API
✅ Secured via Edge Function
No token needed
🔒 SQL runs via run-sql Edge Function · Service Role Key stored on Supabase server · Your browser never sees it
๐Ÿ“ Templates
SQL Editor
Project: xzykcgwrjmehhdgsxnbm
โœ… Security
โ€ข SQL runs via Supabase Edge Function
โ€ข Service Role Key never exposed to browser
โ€ข Protected by x-admin-key secret on server
๐Ÿ’ณ Subscription Plans
Create, edit, delete and assign plans
Loading plans...
๐Ÿ”— Assign Plan
Assign a subscription plan to a user or plant
Assign To
Select Plan
Select User
Start Date
End Date
๐Ÿ›ก Role โ†’ profiles.role
๐Ÿญ Plant โ†’ profiles.plant_id
๐Ÿ‘ค Status โ†’ profiles.is_active
๐Ÿงฎ Products โ†’ user_product_permissions
๐Ÿ‘ Tabs โ†’ tab_permissions (for role)
Provision New User