Troubleshooting

# Check if installed
pnpm list better-auth-studio

# Install as dev dependency
pnpm add -D better-auth-studio

# Or use pnpx without installation
pnpx better-auth-studio start

# pnpm
pnpm store prune

# npm
npm cache clean --force

# yarn
yarn cache clean

node --version

# Using nvm
nvm install 18
nvm use 18

# Using fnm
fnm install 18
fnm use 18

pnpx better-auth-studio start --config ./src/lib/auth.ts

# Check if file exists
ls -la src/auth.ts

// auth.ts - Ensure you export auth instance
import { betterAuth } from "better-auth";

export const auth = betterAuth({
  database: /* ... */,
  // ... other config
});

# Run TypeScript check
pnpm tsc --noEmit

import { prismaAdapter } from "better-auth/adapters/prisma";
import { PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

export const auth = betterAuth({
  database: prismaAdapter(prisma, {
    provider: "postgresql",
  }),
});

# PostgreSQL
pg_isready

# MySQL
mysqladmin ping

# Check Docker containers
docker ps

# Check .env file
cat .env | grep DATABASE_URL

# PostgreSQL
DATABASE_URL="postgresql://user:password@localhost:5432/dbname"

# MySQL
DATABASE_URL="mysql://user:password@localhost:3306/dbname"

# SQLite
DATABASE_URL="file:./dev.db"

# Prisma
pnpm prisma db push

# Drizzle
pnpm drizzle-kit push

# Prisma
pnpm prisma migrate dev

# Drizzle
pnpm drizzle-kit push

# Better Auth migration
pnpm better-auth migrate

# Prisma - check schema
pnpm prisma db pull

# View current tables
pnpm prisma studio

# ⚠️ This deletes all data!
pnpm prisma migrate reset

// schema.prisma
model User {
  id           String    @id
  email        String
  // ... other fields
  lastSeenAt   DateTime? // Add this field
}

pnpm prisma migrate dev --name add-last-seen-at

# Linux/Mac
lsof -i :3002

# Windows
netstat -ano | findstr :3002

# Linux/Mac
kill -9 <PID>

# Windows
taskkill /PID <PID> /F

pnpx better-auth-studio start --port 3001

# Reinstall dependencies
rm -rf node_modules
pnpm install

pnpx better-auth-studio start --no-open --port 3003

pnpx better-auth-studio start --watch

# Look for this message:
# 👀 Watch mode enabled - config changes will reload automatically

# Ensure file is writable
ls -la src/auth.ts

pnpx better-auth-studio start --watch --config ./src/auth.ts

# Validate TypeScript
pnpm tsc --noEmit

# Stop with Ctrl+C, then restart
pnpx better-auth-studio start --watch

// studio.config.ts
const config: StudioConfig = {
  basePath: "/api/studio", // Must match your route
};

// app/api/studio/[[...path]]/route.ts
import { betterAuthStudio } from "better-auth-studio/nextjs";
import studioConfig from "@/studio.config";

const handler = betterAuthStudio(studioConfig);

export { handler as GET, handler as POST };

access: {
  roles: ["admin"],
  allowEmails: ["[email protected]"],
}

# Next.js - check if route exists in build
ls -la .next/server/app/api/studio

access: {
  roles: ["admin"],
  allowEmails: ["[email protected]"],
}

pnpm add better-auth-studio

// package.json
{
  "dependencies": {
    "better-auth-studio": "latest" // Not in devDependencies!
  }
}

# Clear build cache
rm -rf .next
pnpm build

metadata: {
  basePath: "/api/studio",
}

CREATE INDEX idx_user_email ON user(email);
CREATE INDEX idx_user_created_at ON user(createdAt);