Skip to main content
Castov
SQL & Database · 100% Client-Side & Private

SQL to Prisma Schema Converter — Convert CREATE TABLE to Prisma Models

Convert SQL CREATE TABLE statements into Prisma schema models with @id, @unique, types, and timestamp defaults.

sql
7 lines
prisma
10 lines
Real-time instant in-browser transformation (Zero data leaves your device)
Target File:sql-to-prisma-output.prisma

How the SQL DDL to Prisma Schema Works

Translates relational SQL CREATE TABLE statements into Prisma ORM schema models.

Why Developers Use This Conversion

Quickly migrate existing SQL database tables into a modern Prisma ORM codebase.

Before & After Transformation Example

INPUT (SQL)
CREATE TABLE posts (id INT PRIMARY KEY, title TEXT);
OUTPUT (PRISMA)
model Posts {
  id Int @id @default(autoincrement())
  title String?
}

Frequently Asked Questions

Does it handle primary keys?
Yes, columns marked with PRIMARY KEY or SERIAL are mapped to Prisma's @id @default(autoincrement()).

Related Developer Converters

Browse All
SQL & Database

SQL DDL to TypeScript

Convert SQL CREATE TABLE statements into TypeScript interfaces. Automatically maps SQL types to number, string, boolean, Date, and nullable fields.

Convert now
JSON & Schemas

JSON to Prisma Schema

Generate production Prisma models from JSON objects. Automatically detects IDs, UUIDs, relations, DateTime fields, and JSON types.

Convert now
SQL & Database

JSON to SQL (CREATE & INSERT)

Generate SQL CREATE TABLE and INSERT INTO statements from any JSON object or array of objects. Handles escaped quotes and types.

Convert now