GROWTH PATTERN

Adding Activation to Next.js + PlanetScale + NextAuth Apps

Next.js + PlanetScale + NextAuth excels at user management, but misses the opportunity to automatically trigger workflows when users hit key milestones.

Next.js + PlanetScale + NextAuth

Last updated:

What's Missing in Standard Next.js + PlanetScale + NextAuth Architecture

Without an infrastructure layer listening to PlanetScale events, you rely on manual cron jobs or messy webhooks to track when users reach their first value milestone. Most setups require custom code to detect activation.

Standard Next.js + PlanetScale + NextAuth Flow vs Optimized Skene Flow

Standard Flow
1

User signs up via NextAuth

2

User record created in PlanetScale

3

No automatic trigger - manual follow-up required

Skene Flow
1

Watch PlanetScale 'users' table for new signups using mysql.connect()

2

Detect when user completes first key action (e.g., creates first project) using PlanetScale queries

3

Trigger activation email sequence via Resend with personalized onboarding

4

Track activation completion and send milestone emails

Visual comparison of the flows:

Loading diagram...

How Skene Fixes This

The Skene setup for Next.js + PlanetScale + NextAuth watches PlanetScale events and triggers activation workflows when users hit key milestones. It uses mysql.connect() to send personalized onboarding sequences.

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 Activation Loop pattern for Next.js + PlanetScale + NextAuth.

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: 'activation',
  opinion: 'Detect when users complete their first key action and trigger personalized onboarding',
  steps: [
    {
      trigger: {
        type: 'database',
        table: 'users',
        event: 'insert'
      },
      condition: {
        type: 'query',
        query: `SELECT * FROM user_actions WHERE user_id = $1 AND action_type = 'first_project_created'`,
        timeout: '5m'
      },
      action: {
        type: 'email',
        provider: 'resend',
        template: 'activation_welcome',
        personalization: {
          name: '{{user.name}}',
          activationLink: '{{user.activation_link}}'
        }
      }
    }
  ],
  recovery: {
    retries: 3,
    backoff: 'exponential'
  }
});

Frequently asked questions