← back to flaviocopes.com

SQL ↔ Prisma ↔ Drizzle converter

← All tools

Paste a CREATE TABLE, Prisma model, or Drizzle pgTable — get the other two formats. Handy when you are prototyping in SQL and moving to an ORM.

~~~

Input format

Input

Parse error —

~~~
SQL output
Prisma output
Drizzle output

Everything runs in your browser — your schema never leaves this page.

~~~

About this tool

Moving between raw SQL and ORM schemas is tedious copy-paste work. This converter handles common Postgres column types, primary keys, NOT NULL, defaults, unique constraints, and simple foreign key references — one table at a time.

Limitations are intentional: no composite keys, no enums, no indexes, no check constraints beyond what maps cleanly, and no multi-table migrations. Treat the output as a starting point — review types and relation names before you run prisma db push or generate a Drizzle migration.

~~~

Read more