SchemaSnap
Free forever

CSV to Prisma Schema

Prisma models are close to SQL but not identical: types are named differently (Int, DateTime, Decimal), nullability is expressed with a trailing ?, and the primary key needs an explicit @id attribute plus @default(autoincrement()) if it is a serial column.

SchemaSnap builds the same underlying schema it uses for SQL and re-emits it as a Prisma model block, field by field, so you can drop it straight into schema.prisma instead of translating a CREATE TABLE statement by hand.

Example

Run on a small sample CSV at build time, so this is real output, not a mockup.

Table structure (Postgres baseline)

CREATE TABLE customers (
  id SERIAL PRIMARY KEY,
  name VARCHAR(32) NOT NULL,
  email VARCHAR(32) NOT NULL,
  plan VARCHAR(32) NOT NULL,
  price NUMERIC(10,2) NOT NULL,
  signup_date DATE NOT NULL
);

Generated Prisma model

model Customers {
  id Int @id @default(autoincrement())
  name String
  email String
  plan String
  price Decimal
  signup_date DateTime
}

Try it

Drop a .csv file here, or click to choose one. Or just paste below.

Outputs

Paste or drop a CSV, then hit Convert. Nothing you enter here leaves your browser.

Other conversions