Seeding a Database with Prisma (TypeScript)

 by Robin Wieruch
 - Edit this Post

A short tutorial about seeding a database with Prisma in a TypeScript application. I decided to write this tutorial, because many of my other tutorials depend on a database with an initial seeding and I want to reference it.

Prisma: Seeding with TypeScript

We will assume the following model for our database in the *prisma/schema.prisma** file:

model Post {
id String @id @default(cuid())
name String

We will create a new TypeScript file called seed.ts in the prisma folder. This file will contain the code to seed the database. We will use the Prisma Client to interact with the database:

import { PrismaClient } from '@prisma/client';
const prisma = new PrismaClient();
const initialPosts = [
{ name: 'Post 1' },
{ name: 'Post 2' },
{ name: 'Post 3' },
const seed = async () => {
// clean up before the seeding (optional)
// you could also use createMany
// but it is not supported for databases
// e.g. SQLite
for (const post of initialPosts) {
data: post,

Next we need to execute the seeding from the command line. Because we are dealing with a TypeScript file here, we need to add an extra dependency to our project:

npm install tsx --save-dev

Afterward, include it in your package.json:

"scripts": {
"prisma-seed": "tsx prisma/seed.ts"

Finally, you can run the seeding with the following command:

npm run prisma-seed

You should see the seeded data in your database:

npx prisma studio

That's it! You have successfully seeded your database with Prisma in a TypeScript application.

Keep reading about 

TypeScript is getting more popular these days for frontend and backend applications. Here you will learn how to set up TypeScript in Node.js for a backend project. The previous tutorial already…

A short tutorial about setting up a Next.js application with Prisma and SQLite. I decided to write this tutorial, because many of my other Next.js tutorials depend on a database and I want to…

The Road to React

Learn React by building real world applications. No setup configuration. No tooling. Plain React in 200+ pages of learning material. Learn React like 50.000+ readers.

Get it on Amazon.