stack-auth · mantrakp04 · Mar 13, 2026
diff --git a/.context/retros/2026-03-12-1.json b/.context/retros/2026-03-12-1.json
@@ -0,0 +1,24 @@
+{
+  "date": "2026-03-12",
+  "window": "7d",
+  "metrics": {
+    "commits": 7,
+    "prs_merged": 2,
+    "insertions": 3003,
+    "deletions": 165,
+    "net_loc": 2838,
+    "test_loc": 473,
+    "test_ratio": 0.16,
+    "active_days": 3,
+    "sessions": 6,
+    "deep_sessions": 0,
+    "avg_session_minutes": 7,
+    "loc_per_session_hour": 4200,
+    "feat_pct": 0.29,
+    "fix_pct": 0.57,
+    "peak_hour": 10
+  },
+  "version_range": ["package-bump", "package-bump"],
+  "streak_days": 0,
+  "tweetable": "Week of Mar 5: 7 commits, 3.0k LOC, 16% tests, 2 PRs, peak: 10am | Streak: 0d"
+}
diff --git a/CLAUDE.md b/CLAUDE.md
@@ -3,3 +3,8 @@
 ## Commands
 - **Lint**: `pnpm lint`
 - **Typecheck**: `pnpm typecheck`
+
+## gstack
+- Use the `/browse` skill from `gstack` for all web browsing.
+- Never use `mcp__claude-in-chrome__*` tools.
+- Available gstack skills: `/plan-ceo-review`, `/plan-eng-review`, `/review`, `/ship`, `/browse`, `/retro`
diff --git a/apps/backend/prisma/migrations/20260312120000_replay_ai_analytics/migration.sql b/apps/backend/prisma/migrations/20260312120000_replay_ai_analytics/migration.sql
@@ -0,0 +1,70 @@
+CREATE TYPE "ReplayAiAnalysisStatus" AS ENUM ('PENDING', 'READY', 'ERROR');
+CREATE TYPE "ReplayIssueSeverity" AS ENUM ('LOW', 'MEDIUM', 'HIGH', 'CRITICAL');
+
+CREATE TABLE "ReplayIssueCluster" (
+  "id" UUID NOT NULL DEFAULT gen_random_uuid(),
+  "tenancyId" UUID NOT NULL,
+  "fingerprint" TEXT NOT NULL,
+  "title" TEXT NOT NULL,
+  "summary" TEXT,
+  "severity" "ReplayIssueSeverity" NOT NULL,
+  "confidence" DOUBLE PRECISION NOT NULL,
+  "occurrenceCount" INTEGER NOT NULL,
+  "affectedUserCount" INTEGER NOT NULL,
+  "firstSeenAt" TIMESTAMP(3) NOT NULL,
+  "lastSeenAt" TIMESTAMP(3) NOT NULL,
+  "topEvidence" JSONB NOT NULL DEFAULT '[]'::jsonb,
+  "textEmbedding" JSONB,
+  "visualEmbedding" JSONB,
+  "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  "updatedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+  CONSTRAINT "ReplayIssueCluster_pkey" PRIMARY KEY ("id")
+);
+
+CREATE TABLE "ReplayAiSummary" (
+  "id" UUID NOT NULL DEFAULT gen_random_uuid(),
+  "tenancyId" UUID NOT NULL,
+  "sessionReplayId" UUID NOT NULL,
+  "issueClusterId" UUID,
+  "status" "ReplayAiAnalysisStatus" NOT NULL,
+  "issueFingerprint" TEXT,
+  "issueTitle" TEXT,
+  "summary" TEXT,
+  "whyLikely" TEXT,
+  "severity" "ReplayIssueSeverity",
+  "confidence" DOUBLE PRECISION,
+  "evidence" JSONB NOT NULL DEFAULT '[]'::jsonb,
+  "visualArtifacts" JSONB NOT NULL DEFAULT '[]'::jsonb,
+  "relatedReplayIds" JSONB NOT NULL DEFAULT '[]'::jsonb,
+  "textEmbedding" JSONB,
+  "visualEmbedding" JSONB,
+  "providerMetadata" JSONB NOT NULL DEFAULT '{}'::jsonb,
+  "errorMessage" TEXT,
+  "analyzedAt" TIMESTAMP(3),
+  "lastAnalyzedChunkCount" INTEGER NOT NULL DEFAULT 0,
+  "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  "updatedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+  CONSTRAINT "ReplayAiSummary_pkey" PRIMARY KEY ("id")
+);
+
+CREATE UNIQUE INDEX "ReplayIssueCluster_tenancyId_fingerprint_key" ON "ReplayIssueCluster"("tenancyId", "fingerprint");
+CREATE UNIQUE INDEX "ReplayAiSummary_tenancyId_sessionReplayId_key" ON "ReplayAiSummary"("tenancyId", "sessionReplayId");
+CREATE INDEX "ReplayAiSummary_tenancyId_issueClusterId_idx" ON "ReplayAiSummary"("tenancyId", "issueClusterId");
+
+ALTER TABLE "ReplayIssueCluster"
+  ADD CONSTRAINT "ReplayIssueCluster_tenancyId_fkey"
+  FOREIGN KEY ("tenancyId") REFERENCES "Tenancy"("id") ON DELETE CASCADE ON UPDATE CASCADE;
+
+ALTER TABLE "ReplayAiSummary"
+  ADD CONSTRAINT "ReplayAiSummary_tenancyId_fkey"
+  FOREIGN KEY ("tenancyId") REFERENCES "Tenancy"("id") ON DELETE CASCADE ON UPDATE CASCADE;
+
+ALTER TABLE "ReplayAiSummary"
+  ADD CONSTRAINT "ReplayAiSummary_tenancyId_sessionReplayId_fkey"
+  FOREIGN KEY ("tenancyId", "sessionReplayId") REFERENCES "SessionReplay"("tenancyId", "id") ON DELETE CASCADE ON UPDATE CASCADE;
+
+ALTER TABLE "ReplayAiSummary"
+  ADD CONSTRAINT "ReplayAiSummary_issueClusterId_fkey"
+  FOREIGN KEY ("issueClusterId") REFERENCES "ReplayIssueCluster"("id") ON DELETE SET NULL ON UPDATE CASCADE;
diff --git a/...prisma/migrations/20260312120000_replay_ai_analytics/tests/creates-replay-ai-artifacts.ts b/...prisma/migrations/20260312120000_replay_ai_analytics/tests/creates-replay-ai-artifacts.ts
@@ -0,0 +1,114 @@
+import { randomUUID } from "crypto";
+import type { Sql } from "postgres";
+import { expect } from "vitest";
+
+export const preMigration = async (sql: Sql) => {
+  const projectId = `test-${randomUUID()}`;
+  const tenancyId = randomUUID();
+  const projectUserId = randomUUID();
+  const sessionReplayId = randomUUID();
+
+  await sql`INSERT INTO "Project" ("id", "createdAt", "updatedAt", "displayName", "description", "isProductionMode") VALUES (${projectId}, NOW(), NOW(), 'Test', '', false)`;
+  await sql`INSERT INTO "Tenancy" ("id", "createdAt", "updatedAt", "projectId", "branchId", "hasNoOrganization") VALUES (${tenancyId}::uuid, NOW(), NOW(), ${projectId}, 'main', 'TRUE'::"BooleanTrue")`;
+  await sql`INSERT INTO "ProjectUser" ("projectUserId", "tenancyId", "mirroredProjectId", "mirroredBranchId", "createdAt", "updatedAt", "lastActiveAt") VALUES (${projectUserId}::uuid, ${tenancyId}::uuid, ${projectId}, 'main', NOW(), NOW(), NOW())`;
+  await sql`
+    INSERT INTO "SessionReplay" ("id", "tenancyId", "projectUserId", "sessionRefreshTokenId", "sessionReplaySegmentId", "startedAt", "lastEventAt", "createdAt", "updatedAt")
+    VALUES (${sessionReplayId}::uuid, ${tenancyId}::uuid, ${projectUserId}::uuid, 'placeholder-refresh-token', 'segment-1', NOW(), NOW(), NOW(), NOW())
+  `;
+
+  return { tenancyId, sessionReplayId };
+};
+
+export const postMigration = async (sql: Sql, ctx: Awaited<ReturnType<typeof preMigration>>) => {
+  await sql`
+    INSERT INTO "ReplayIssueCluster" (
+      "id",
+      "tenancyId",
+      "fingerprint",
+      "title",
+      "summary",
+      "severity",
+      "confidence",
+      "occurrenceCount",
+      "affectedUserCount",
+      "firstSeenAt",
+      "lastSeenAt",
+      "topEvidence",
+      "textEmbedding",
+      "visualEmbedding",
+      "createdAt",
+      "updatedAt"
+    )
+    VALUES (
+      ${randomUUID()}::uuid,
+      ${ctx.tenancyId}::uuid,
+      'frontend-error:/sign-in',
+      'Frontend error surfaced during replay',
+      'The replay captured a frontend error.',
+      'HIGH'::"ReplayIssueSeverity",
+      0.92,
+      1,
+      1,
+      NOW(),
+      NOW(),
+      '[]'::jsonb,
+      '{"provider":"local-hash","model":"gemini-embedding-001","dimensions":2,"generated_at_millis":1,"values":[0.1,0.9]}'::jsonb,
+      NULL,
+      NOW(),
+      NOW()
+    )
+  `;
+
+  await sql`
+    INSERT INTO "ReplayAiSummary" (
+      "id",
+      "tenancyId",
+      "sessionReplayId",
+      "status",
+      "issueFingerprint",
+      "issueTitle",
+      "summary",
+      "whyLikely",
+      "severity",
+      "confidence",
+      "evidence",
+      "visualArtifacts",
+      "relatedReplayIds",
+      "providerMetadata",
+      "lastAnalyzedChunkCount",
+      "createdAt",
+      "updatedAt"
+    )
+    VALUES (
+      ${randomUUID()}::uuid,
+      ${ctx.tenancyId}::uuid,
+      ${ctx.sessionReplayId}::uuid,
+      'READY'::"ReplayAiAnalysisStatus",
+      'frontend-error:/sign-in',
+      'Frontend error surfaced during replay',
+      'The replay captured a frontend error.',
+      'A direct browser error event was captured.',
+      'HIGH'::"ReplayIssueSeverity",
+      0.92,
+      '[]'::jsonb,
+      '[]'::jsonb,
+      '[]'::jsonb,
+      '{}'::jsonb,
+      1,
+      NOW(),
+      NOW()
+    )
+  `;
+
+  const [summary] = await sql`
+    SELECT "status"::text AS "status", "severity"::text AS "severity"
+    FROM "ReplayAiSummary"
+    WHERE "tenancyId" = ${ctx.tenancyId}::uuid
+      AND "sessionReplayId" = ${ctx.sessionReplayId}::uuid
+  `;
+
+  expect(summary).toMatchObject({
+    status: "READY",
+    severity: "HIGH",
+  });
+};
diff --git a/apps/backend/prisma/schema.prisma b/apps/backend/prisma/schema.prisma
@@ -73,6 +73,8 @@ model Tenancy {
   emailOutboxes     EmailOutbox[]
   sessionReplays SessionReplay[]
   sessionReplayChunks SessionReplayChunk[]
+  replayAiSummaries ReplayAiSummary[]
+  replayIssueClusters ReplayIssueCluster[]
   managedEmailDomains ManagedEmailDomain[]
 
   // Email capacity boost - when set and in the future, email capacity is multiplied by 4
@@ -349,6 +351,7 @@ model SessionReplay {
   tenancy     Tenancy     @relation(fields: [tenancyId], references: [id], onDelete: Cascade)
 
   chunks SessionReplayChunk[]
+  replayAiSummary ReplayAiSummary?
 
   @@id([tenancyId, id])
   @@map("SessionReplay")
@@ -390,6 +393,86 @@ model SessionReplayChunk {
   @@index([tenancyId, sessionReplayId, createdAt])
 }
 
+enum ReplayAiAnalysisStatus {
+  PENDING
+  READY
+  ERROR
+}
+
+enum ReplayIssueSeverity {
+  LOW
+  MEDIUM
+  HIGH
+  CRITICAL
+}
+
+model ReplayIssueCluster {
+  id String @id @default(uuid()) @db.Uuid
+
+  tenancyId String @db.Uuid
+  tenancy   Tenancy @relation(fields: [tenancyId], references: [id], onDelete: Cascade)
+
+  fingerprint String
+  title       String
+  summary     String?
+  severity    ReplayIssueSeverity
+  confidence  Float
+
+  occurrenceCount   Int
+  affectedUserCount Int
+
+  firstSeenAt DateTime
+  lastSeenAt  DateTime
+
+  topEvidence     Json
+  textEmbedding   Json?
+  visualEmbedding Json?
+
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+
+  replayAiSummaries ReplayAiSummary[]
+
+  @@unique([tenancyId, fingerprint])
+}
+
+model ReplayAiSummary {
+  id String @id @default(uuid()) @db.Uuid
+
+  tenancyId       String @db.Uuid
+  sessionReplayId String @db.Uuid
+  issueClusterId  String? @db.Uuid
+
+  tenancy        Tenancy          @relation(fields: [tenancyId], references: [id], onDelete: Cascade)
+  sessionReplay  SessionReplay    @relation(fields: [tenancyId, sessionReplayId], references: [tenancyId, id], onDelete: Cascade)
+  issueCluster   ReplayIssueCluster? @relation(fields: [issueClusterId], references: [id], onDelete: SetNull)
+
+  status           ReplayAiAnalysisStatus
+  issueFingerprint String?
+  issueTitle       String?
+  summary          String?
+  whyLikely        String?
+  severity         ReplayIssueSeverity?
+  confidence       Float?
+
+  evidence         Json
+  visualArtifacts  Json
+  relatedReplayIds Json
+  textEmbedding    Json?
+  visualEmbedding  Json?
+  providerMetadata Json
+
+  errorMessage           String?
+  analyzedAt             DateTime?
+  lastAnalyzedChunkCount Int      @default(0)
+
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+
+  @@unique([tenancyId, sessionReplayId])
+  @@index([tenancyId, issueClusterId])
+}
+
 enum ContactChannelType {
   EMAIL
   // PHONE

diff --git a/apps/backend/src/app/api/latest/analytics/events/batch/route.tsx b/apps/backend/src/app/api/latest/analytics/events/batch/route.tsx
@@ -9,11 +9,12 @@ import { StatusError } from "@stackframe/stack-shared/dist/utils/errors";
 const UUID_RE = /^[0-9a-f]{8}-[0-9a-f]{4}-[1-8][0-9a-f]{3}-[089ab][0-9a-f]{3}-[0-9a-f]{12}$/i;
 
 const MAX_EVENTS = 500;
+const ALLOWED_EVENT_TYPES = ["$page-view", "$click", "$input", "$submit", "$error", "$network-error"] as const;
 
 export const POST = createSmartRouteHandler({
   metadata: {
     summary: "Upload analytics event batch",
-    description: "Uploads a batch of auto-captured analytics events ($page-view, $click).",
+    description: "Uploads a batch of auto-captured analytics events for replay analysis and behavior insights.",
     tags: ["Analytics Events"],
     hidden: true,
   },
@@ -30,7 +31,7 @@ export const POST = createSmartRouteHandler({
       sent_at_ms: yupNumber().defined().integer().min(0),
       events: yupArray(
         yupObject({
-          event_type: yupString().defined().oneOf(["$page-view", "$click"]),
+          event_type: yupString().defined().oneOf(ALLOWED_EVENT_TYPES),
           event_at_ms: yupNumber().defined().integer().min(0),
           data: yupMixed().defined(),
         }).defined(),
@@ -86,6 +87,7 @@ export const POST = createSmartRouteHandler({
       clickhouse_settings: {
         date_time_input_format: "best_effort",
         async_insert: 1,
+        wait_for_async_insert: 1,
       },
     });