What does the datasource block do?

It tells Prisma which database engine to target and where to find the connection string. The provider names the engine such as postgresql, and url pulls from env DATABASE_URL so the secret stays out of the schema file.

How are ids and timestamps generated?

The stub gives each model an id field marked with the id attribute and a default. For string ids it uses cuid, and it adds a createdAt DateTime field defaulting to now. You can switch to autoincrement integers if you prefer.

How is the one-to-many relation expressed?

The parent model holds a list field of the child type, and the child holds a foreign-key scalar plus a relation field annotated with the relation attribute mapping fields to references. This is the standard Prisma pattern for one-to-many.

What is the difference between an optional and required field?

A required field has a plain type like String, while an optional field appends a question mark, like String question-mark, allowing null in the database. The builder toggles this per field.

Do I run a migration after copying this?

Yes. After saving the schema run prisma migrate dev to generate and apply a migration, then prisma generate to build the typed client. The stub is migration-ready, not a runtime artifact on its own.

Prisma Schema Stub Builder

Email me this result

Get this tool's output sent to your inbox, plus one useful tool a week. No spam, unsubscribe any time.

A Prisma schema needs a datasource, a generator, and your models before you can migrate. This builder produces a valid schema.prisma stub with sensible defaults — ids, timestamps, typed fields, and an optional one-to-many relation — so you can go straight to prisma migrate dev.

How it works

Every schema starts with two blocks: a datasource naming the database provider and pulling the connection string from env("DATABASE_URL"), and a generator for the JavaScript client. Models follow, with field attributes like @id, @default, and @unique:

model User {
  id        String   @id @default(cuid())
  email     String   @unique
  name      String?
  createdAt DateTime @default(now())
  posts     Post[]
}

A one-to-many relation pairs a list field on the parent (posts Post[]) with a foreign key and @relation annotation on the child, mapping the child’s authorId to the parent’s id.

Tips and notes

Append ? to a field type to make it nullable. Keep the connection string in .env as DATABASE_URL — never inline it. After copying the schema, run npx prisma migrate dev --name init to create the tables and npx prisma generate to build the typed client. Switch the id default to @default(autoincrement()) with an Int type if you prefer numeric primary keys over cuids.