SQL ↔ Prisma Converter

Translate database DDL statements into Prisma schema models or generate SQL CREATE TABLE tables from Prisma schemas.

Presets:

SQL DDL Input (postgresql)

Prisma Schema Output

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model User {
  id             Int        @id @default(autoincrement())
  email          String     @unique
  passwordHash   String     @map("password_hash")
  firstName      String?    @map("first_name")
  lastName       String?    @map("last_name")
  isVerified     Boolean?   @default(false) @map("is_verified")
  createdAt      DateTime?  @default(now()) @map("created_at")
  updatedAt      DateTime?  @default(now()) @map("updated_at")

  @@map("users")
}

model UserSession {
  id             String     @id @default(uuid())
  userId         Int        @map("user_id")
  token          String     @unique
  expiresAt      DateTime   @map("expires_at")
  createdAt      DateTime?  @default(now()) @map("created_at")

  @@map("user_sessions")
}

Frequently Asked Questions

Which SQL dialects are supported for Prisma schema generation?

PostgreSQL, MySQL, SQLite, and Microsoft SQL Server (MSSQL) DDL CREATE TABLE statements are supported, including primary keys, foreign key constraints, default timestamps, and nullable fields.

Can this tool convert Prisma schemas back into raw SQL CREATE TABLE statements?

Yes. Use the Swap toggle button or select Prisma-to-SQL mode to generate equivalent DDL SQL schemas from standard Prisma model definitions.

Are my database schemas stored or transmitted across the web?

No. The entire AST generation and regex lexical tokenizer run directly inside your local browser runtime.

SQL ↔ Prisma Converter

SQL DDL Input (postgresql)

Prisma Schema Output

Frequently Asked Questions

Explore Related Developer Utilities

Word & Character Counter

JSON Formatter & Validator

JSON to SQL inserts

CSV to Markdown table