Supabase Integration

Quick Links

What You Can Query

Unlike Stripe (which has fixed metric blocks), Supabase skills are fully flexible -- you query whatever your application stores.

Common Patterns

• User signups -- Users created in a period
• Active users -- Users with recent activity
• Feature adoption -- Events or actions taken
• Retention -- Cohort analysis from user + activity tables
• Custom metrics -- Anything in your database

Query Modes

Visual Builder -- Point-and-click query building. Select a table, pick columns, add filters, set sort order. No SQL required. Great for simple queries.

Raw SQL -- Full PostgreSQL support including joins, CTEs, window functions, aggregations, and subqueries. Use $1, $2 parameter placeholders for dynamic values.

SELECT u.email, u.created_at, count(e.id) as event_count
FROM users u
LEFT JOIN events e ON e.user_id = u.id
WHERE u.created_at > now() - interval $1
GROUP BY u.email, u.created_at
ORDER BY event_count DESC
LIMIT $2

Combined Pro -- Pair Supabase queries with Stripe data and join on a shared key (email, customer ID).

See Query Syntax for the full reference.

Security

• OAuth + project picker -- No API keys to copy or paste
• AES-256 encryption -- Credentials encrypted at rest
• Read-only enforcement -- Write statements are rejected at the application level
• RLS respected -- Row Level Security policies apply to all queries
• Disconnect anytime -- Revoke from alice or Supabase Dashboard

See Connect Supabase for setup and Security for the full security model.