Schema & Code Converter 100% In-Browser

Convert PostgreSQL DDL to Prisma Schema Models Online

Transpile Postgres CREATE TABLE DDL into Prisma schema models with @id, @default(now()), and @unique constraints.

SQL Dialect:

Target Output:

SQL DDL Input (PostgreSQL)

prisma Output✓ Parsed 1 table (AST transpiler)

model Users {
  id               Int @id @default(autoincrement())
  email            String @unique
  full_name        String?
  age              Int? @default(18)
  is_active        Boolean? @default(true)
  created_at       DateTime? @default(now())

  @@map("users")
}

Did this converter save you time? Completely optional · From $3 — keeps Microdeck fast and free.

Privacy-Friendly Sponsor Unit

Contextual tech, developer, & creator tools sponsorship slot. Zero intrusive tracking.

Sample Conversion: PostgreSQL DDL → Prisma Schema

Input (PostgreSQL DDL)

CREATE TABLE accounts (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  username VARCHAR(50) UNIQUE NOT NULL
);

Output (Prisma Schema)

model Account {
  id       String @id @default(uuid())
  username String @unique
}

Frequently Asked Questions

How are Postgres UUIDs converted in Prisma?

UUID columns map to String with @default(uuid()).

Other Popular Database Schema Conversions

SQL DDL to Prisma Schema SQL DDL to Drizzle ORM SQL DDL to Zod Schema SQL DDL to TypeScript Interfaces PostgreSQL DDL to Drizzle pgTable MySQL DDL to Prisma Schema MySQL DDL to Drizzle mysqlTable