CREATE TABLE from PostgreSQL, MySQL, SQLite. The tool extracts columns, types, constraints, and generates Prisma models.

Does it detect relationships?

Foreign keys are mapped to Prisma relations. Many-to-many joins (with explicit junction tables) are recognized and mapped appropriately.

Postgres ENUM types become Prisma enums. MySQL CHECK-constraint enums need manual review — Prisma prefers explicit enum definitions.

Will the Prisma schema round-trip?

Run `prisma migrate diff` to compare. Minor drift is likely (defaults, indexes). Use this as a starter; hand-tune the Prisma schema for production.

Convert SQL CREATE TABLE statements to Prisma schema. Part of the DevTools Surf developer suite. Browse more tools in the Data / SQL collection.

Prisma was founded in 2016 in Berlin by Johannes Schickling — it evolved from Graphcool, a GraphQL backend-as-a-service, into a standalone ORM for Node.js and TypeScript.
Prisma's schema language (PSL) was designed to be database-agnostic — a single schema file can target PostgreSQL, MySQL, SQLite, MongoDB, or SQL Server with a one-line change.
The Prisma Migrate engine generates SQL migration files that are human-readable and version-controlled, bridging the gap between schema-first and migration-first workflows.

Which SQL dialects?: CREATE TABLE from PostgreSQL, MySQL, SQLite. The tool extracts columns, types, constraints, and generates Prisma models.
Does it detect relationships?: Foreign keys are mapped to Prisma relations. Many-to-many joins (with explicit junction tables) are recognized and mapped appropriately.
What about enums?: Postgres ENUM types become Prisma enums. MySQL CHECK-constraint enums need manual review — Prisma prefers explicit enum definitions.
Will the Prisma schema round-trip?: Run `prisma migrate diff` to compare. Minor drift is likely (defaults, indexes). Use this as a starter; hand-tune the Prisma schema for production.

Convert SQL CREATE TABLE statements to Prisma schema. Part of the DevTools Surf developer suite. Browse more tools in the Data / SQL collection.

Prisma was founded in 2016 in Berlin by Johannes Schickling — it evolved from Graphcool, a GraphQL backend-as-a-service, into a standalone ORM for Node.js and TypeScript.
Prisma's schema language (PSL) was designed to be database-agnostic — a single schema file can target PostgreSQL, MySQL, SQLite, MongoDB, or SQL Server with a one-line change.
The Prisma Migrate engine generates SQL migration files that are human-readable and version-controlled, bridging the gap between schema-first and migration-first workflows.

Which SQL dialects?: CREATE TABLE from PostgreSQL, MySQL, SQLite. The tool extracts columns, types, constraints, and generates Prisma models.
Does it detect relationships?: Foreign keys are mapped to Prisma relations. Many-to-many joins (with explicit junction tables) are recognized and mapped appropriately.
What about enums?: Postgres ENUM types become Prisma enums. MySQL CHECK-constraint enums need manual review — Prisma prefers explicit enum definitions.
Will the Prisma schema round-trip?: Run `prisma migrate diff` to compare. Minor drift is likely (defaults, indexes). Use this as a starter; hand-tune the Prisma schema for production.