GROWTH PATTERN

Adding Freemium Gating to Nuxt + Supabase Apps

The Nuxt + Supabase + payments setup processes payments, but there's no automated connection between feature usage and subscription limits.

Nuxt + Supabase

Last updated:

What's Missing in Standard Nuxt + Supabase Architecture

Nuxt + Supabase subscriptions work, but there's no system to track usage and automatically enforce subscription-based feature limits without custom implementation.

Standard Nuxt + Supabase Flow vs Optimized Skene Flow

Standard Flow
1

User subscribes via payments

2

Subscription status stored in Supabase

3

Features accessible but no usage limits enforced

Skene Flow
1

Track usage in Supabase 'subscriptions' and 'usage' tables

2

Detect when free tier user hits limit (e.g., 5 workflows completed)

3

Block feature access and trigger upgrade prompt email

4

Track conversion from free to paid

Visual comparison of the flows:

Loading diagram...

How Skene Fixes This

This Skene Prompt installs usage tracking that correlates Supabase feature usage with payments subscription tiers. When free users hit limits (like 100 API calls), it automatically blocks features and sends upgrade prompts.

Implementation Comparison

Using Skene Infrastructure

Install via Prompt

cursor.mdc
@task: Initialize Skene.
@action: Analyze my local code, validating subscription via `npx skene login`, and generate `skene.config.ts` to implement the Freemium Gating pattern for Nuxt + Supabase.

Copy Skene Prompt for Cursor

Generated skene.config.ts

skene.config.ts
// skene.config.ts - The Automated Way
import { defineLoop } from '@skene/sdk';

export default defineLoop({
  type: 'freemium',
  opinion: 'Enforce usage limits for free tier users and trigger upgrade prompts',
  steps: [
    {
      trigger: {
        type: 'api',
        endpoint: '/api/features/*',
        method: 'POST'
      },
      condition: {
        type: 'usage',
        limit: {
          free: 100,
          paid: Infinity
        },
        period: '30d'
      },
      action: {
        type: 'block',
        message: 'You've reached your free tier limit. Upgrade to continue.',
        upgradePrompt: {
          type: 'email',
          provider: 'resend',
          template: 'upgrade_prompt'
        }
      }
    }
  ],
  recovery: {
    retries: 0 // No retries for blocking actions
  }
});

Frequently asked questions