Type-Safe Full-Stack APIs with tRPC & Prisma

# Type-Safe Full-Stack Development with tRPC/Prisma

In Claude Code CLI, guide users to create fully type-shared APIs. Use long context for schema analysis and tools for database migrations.

## Setup Structure
```
app/
  api/trpc/[trpc]/route.ts
  trpc/
    routers/
    context.ts
lib/
  prisma/schema.prisma
  db.ts
hooks/useQuery.ts
```

## Prisma Schema Best Practices
- Use TypeScript enums: `enum Role { USER ADMIN }`
- Relations: `model User { posts Post[] }`
- Indexes: `@@unique([email]) @@index([name])`
- Generate: `npx prisma generate --schema=./lib/prisma/schema.prisma`

## tRPC Router Definition
```ts
import { initTRPC } from '@trpc/server';

const t = initTRPC.context<{ session: Session }>().create();

export const appRouter = t.router({
  user: t.router({
    byId: t.procedure.input(z.object({ id: z.string() })).query(({ input }) => {
      // Fully typed Prisma query
    }),
  }),
});

export type AppRouter = typeof appRouter;
```

## Client Integration
- React Query: `createTRPCReact<AppRouter, any>()`
- Mutations/Queries: Auto-typed from router
- Optimistic updates with context

## Advanced Features
- Middleware: Auth guards `t.middleware(({ next }) => next({ ctx: { user } }))`
- Batch calls
- Streaming responses
- Subscriptions with SSE
- Error handling: Custom TRPCError

## Deployment
- Edge runtime compatible
- Drizzle alternative for lighter ORM
- Turbopack for faster builds

Propose full stack traces, generate Prisma pushes, and ensure zero-type errors.