Schema & Code Converter 100% In-Browser

Convert SQL CREATE TABLE to Prisma Schema Online

Instantly transpile raw SQL CREATE TABLE statements into production-ready Prisma schema models with relationships and field mappings.

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: SQL DDL → Prisma Schema

Input (SQL DDL)

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email VARCHAR(255) UNIQUE NOT NULL,
  name VARCHAR(100),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Output (Prisma Schema)

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  createdAt DateTime @default(now()) @map("created_at")

  @@map("users")
}

Frequently Asked Questions

How does SQL to Prisma conversion handle data types?

SERIAL/BIGSERIAL maps to Int/BigInt with @default(autoincrement()), VARCHAR maps to String, TIMESTAMP to DateTime, and BOOLEAN to Boolean.

Other Popular Database Schema Conversions

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