MySQL & PostgresType Mapping100% Private
model Users {
  id  Int @id @default(autoincrement())
  email  String @unique
  name  String?
  password_hash  String
  is_active  Boolean @default(true)
  created_at  DateTime @default(now())
  updated_at  DateTime @default(now()) @updatedAt
}

model Posts {
  id  Int @id @default(autoincrement())
  title  String
  content  String?
  published  Boolean @default(false)
  author_id  Int
  created_at  DateTime @default(now())
}

FAQ

What SQL dialects are supported?
MySQL, PostgreSQL, and standard SQL CREATE TABLE statements are all handled.
Does it handle constraints?
Yes. PRIMARY KEY, NOT NULL, UNIQUE, DEFAULT values, and AUTO_INCREMENT/SERIAL are converted to Prisma attributes.
Does it handle relations?
Foreign key columns are detected and typed, but relation fields need to be added manually in Prisma.
Share:

Explore More

Love this tool? Explore 999+ more

Free online tools for images, PDFs, text, code, and more. All running in your browser.

Explore All Tools