Next.js MCP Server Template

// This is your Prisma schema file, // learn more about it in the docs: https://pris.ly/d/prisma-schema generator client { provider = "prisma-client-js" } datasource db { provider = "postgresql" url = env("DATABASE_URL") } model Account { id String @id @default(cuid()) email String @unique name String? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt // Relations xeroConnections XeroConnection[] oauthTokens OAuthToken[] mcpSessions MCPSession[] oauthStates OAuthState[] @@map("accounts") } model OAuthState { id String @id @default(cuid()) state String @unique accountId String? expiresAt DateTime createdAt DateTime @default(now()) // Relations account Account? @relation(fields: [accountId], references: [id]) @@map("oauth_states") @@index([state]) @@index([expiresAt]) } model XeroConnection { id String @id @default(cuid()) tenantId String @unique tenantName String tenantType String accountId String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt // Relations account Account @relation(fields: [accountId], references: [id], onDelete: Cascade) oauthTokens OAuthToken[] webhookEvents WebhookEvent[] @@map("xero_connections") } model OAuthToken { id String @id @default(cuid()) accessToken String // Encrypted refreshToken String // Encrypted expiresAt DateTime tokenType String @default("Bearer") scope String accountId String tenantId String? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt // Relations account Account @relation(fields: [accountId], references: [id], onDelete: Cascade) xeroConnection XeroConnection? @relation(fields: [tenantId], references: [tenantId]) @@map("oauth_tokens") @@index([accountId]) @@index([tenantId]) } model WebhookEvent { id String @id @default(cuid()) eventType String resourceId String resourceType String payload Json processed Boolean @default(false) tenantId String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt // Relations xeroConnection XeroConnection @relation(fields: [tenantId], references: [tenantId], onDelete: Cascade) @@map("webhook_events") @@index([tenantId]) @@index([processed]) } model MCPSession { id String @id @default(cuid()) sessionId String @unique accountId String tenantId String? expiresAt DateTime createdAt DateTime @default(now()) updatedAt DateTime @updatedAt // Relations account Account @relation(fields: [accountId], references: [id], onDelete: Cascade) @@map("mcp_sessions") @@index([sessionId]) @@index([accountId]) }