How to fix P2011: Null constraint violation on the field in Prisma

model User {
  id    String  @id @default(cuid())     // Required: must have a default or be provided
  email String                            // Required: must be provided
  name  String?                           // Optional: can be null
  age   Int?                              // Optional: can be null
}

// WRONG - missing required email field
const user = await prisma.user.create({
  data: {
    name: "John Doe"
  }
});

// CORRECT - providing required email field
const user = await prisma.user.create({
  data: {
    email: "[email protected]",
    name: "John Doe"
  }
});

model Post {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  published Boolean  @default(false)
  title     String
}

const post = await prisma.post.create({
  data: {
    title: "My First Post"
    // id, createdAt, and published are auto-generated
  }
});

npx prisma db pull

git diff prisma/schema.prisma

model User {
  id       String  @id @default(cuid())
  email    String
  phone    String?  // Optional: can be null
  nickname String?  // Optional: can be null
}

const user = await prisma.user.create({
  data: {
    email: "[email protected]"
    // phone and nickname are not required
  }
});

import { z } from 'zod';

const userSchema = z.object({
  email: z.string().email(),
  name: z.string().min(1),
  age: z.number().optional()
});

const data = { name: "John" }; // Missing email

try {
  const validatedData = userSchema.parse(data);
  const user = await prisma.user.create({ data: validatedData });
} catch (error) {
  if (error instanceof z.ZodError) {
    console.error("Validation failed:", error.errors);
  }
}

import { Prisma } from '@prisma/client';

try {
  const user = await prisma.user.create({
    data: {
      email: userInput.email,
      name: userInput.name
    }
  });
} catch (error) {
  if (error instanceof Prisma.PrismaClientKnownRequestError) {
    if (error.code === 'P2011') {
      console.error("Null constraint violation:", error.message);
      // Return user-friendly error message
      throw new Error(
        `Cannot create record: missing required field. Check that all required fields have values.`
      );
    }
  }
  throw error;
}

# Error message shows empty brackets
P2011: Null constraint violation on the fields: ()

-- Check your custom domain definition
SELECT typname, typnotnull FROM pg_type WHERE typname = 'your_domain';

npx prisma migrate dev