GROWTH PATTERN

Implementing User Segmentation with Turso

The standard Turso setup creates user records, but lacks the infrastructure to detect value-achievement milestones.

Turso

Last updated:

What's Missing in Standard Turso Architecture

Turso creates user sessions, but lacks the infrastructure to detect when users first achieve value in your application without custom implementation.

Standard Turso Flow vs Optimized Skene Flow

Standard Flow
1

User signs up via authentication

2

User record created in Turso

3

No automatic trigger - manual follow-up required

Skene Flow
1

Watch Turso 'users' table for new signups using standard API

2

Detect when user completes first key action (e.g., sharing their first resource) using Turso 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

We created a Skene configuration that tracks user progress after signup and automatically sends milestone emails when users complete key actions like sharing their first resource in Turso.

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 Retention Loop pattern for Turso.

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