supabase-analytics - Set Up Supabase-Native Analytics for Multi-Tenant Platform
Sets up Supabase-native analytics including custom event tables with RLS, per-tenant views, query performance monitoring, and Logflare logs.
Tags
Updated: 2026-09-21Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Create analytics events database table
- Configure row level security policies
- Create per-tenant analytics aggregated views
- Implement server-side analytics tracking service
- Monitor queries using pg_stat_statements extension
- Configure Logflare structured log drains
Inputs
- Command line arguments
- Supabase project configuration
- Database schema definition file
- Tenant helper utility
- Supabase environment variables
Outputs
- analytics_events database table
- Row level security policies
- Analytics aggregated database views
- Analytics tracking service file
- Slow query check script
Requirements
- Supabase project with SQL editor or MCP access
- Drizzle ORM development toolchain
- PostgreSQL pg_stat_statements extension support
- Superuser database permissions