Schema & Code Converter 100% In-Browser

Convert MySQL CREATE TABLE to Prisma Schema Online

Convert MySQL table definitions with AUTO_INCREMENT and VARCHAR lengths into Prisma schema models.

SQL Dialect:

Target Output:

SQL DDL Input (MySQL)

prisma Output✓ Parsed 1 table (AST transpiler)

model Tags {
  id               Int @id @default(autoincrement())
  slug             String @unique
  created_at       DateTime? @default(now())

  @@map("tags")
}

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

Input (MySQL DDL)

CREATE TABLE categories (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(100) NOT NULL
);

Output (Prisma Schema)

model Category {
  id    Int    @id @default(autoincrement())
  title String
}

Frequently Asked Questions

Does Prisma support MySQL autoincrement keys?

Yes, INT AUTO_INCREMENT maps directly to Int @id @default(autoincrement()).

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 Prisma Schema PostgreSQL DDL to Drizzle pgTable MySQL DDL to Drizzle mysqlTable