prisma-cli-db-seed

// TypeScript with tsx
seed: 'tsx prisma/seed.ts'
 
// TypeScript with ts-node
seed: 'ts-node prisma/seed.ts'
 
// JavaScript
seed: 'node prisma/seed.js'

// prisma/seed.ts
import { PrismaClient } from '../generated/client'
 
const prisma = new PrismaClient()
 
async function main() {
  // Create users
  const alice = await prisma.user.upsert({
    where: { email: 'alice@prisma.io' },
    update: {},
    create: {
      email: 'alice@prisma.io',
      name: 'Alice',
      posts: {
        create: {
          title: 'Hello World',
          published: true,
        },
      },
    },
  })
 
  const bob = await prisma.user.upsert({
    where: { email: 'bob@prisma.io' },
    update: {},
    create: {
      email: 'bob@prisma.io',
      name: 'Bob',
    },
  })
 
  console.log({ alice, bob })
}
 
main()
  .then(async () => {
    await prisma.$disconnect()
  })
  .catch(async (e) => {
    console.error(e)
    await prisma.$disconnect()
    process.exit(1)
  })

prisma db seed

prisma db seed -- --environment development

# v7 workflow
prisma migrate dev --name init
prisma generate
prisma db seed  # Must run explicitly

// Good: Can run multiple times
await prisma.user.upsert({
  where: { email: 'alice@prisma.io' },
  update: {},  // Don't change existing
  create: { email: 'alice@prisma.io', name: 'Alice' },
})
 
// Bad: Fails on second run
await prisma.user.create({
  data: { email: 'alice@prisma.io', name: 'Alice' },
})

prisma migrate reset --force
prisma db seed

// prisma/seed.ts
const count = await prisma.user.count()
if (count === 0) {
  // Only seed if empty
  await seedUsers()
}

// prisma/seed.ts
const env = process.env.NODE_ENV || 'development'
 
if (env === 'development') {
  await seedDevData()
} else if (env === 'test') {
  await seedTestData()
}