Which SQL dialects are supported?

PostgreSQL, MySQL/MariaDB, and SQLite CREATE TABLE syntax, including Postgres CREATE TYPE … AS ENUM and MySQL inline ENUM columns.

Are foreign keys turned into Prisma relations?

Yes. Inline REFERENCES and table-level FOREIGN KEY constraints become @relation fields with back-relations on the referenced model.

Is my schema uploaded anywhere?

No. Parsing and code generation run locally in your browser; nothing is sent to a server.

Does it support ALTER TABLE or views?

Not yet — only CREATE TABLE and enum type definitions are read. Merge ALTER statements into your CREATE TABLE first.

Does it work offline and on mobile?

Yes. Once the page has loaded it keeps working without a network connection, and the layout is responsive so it stays usable on phones and tablets.

SQL DDL to TypeScript / Zod / Prisma

Generate TypeScript interfaces, Zod schemas, and Prisma models from CREATE TABLE SQL.

Support

Works Offline

Privacy First

No Login

No API

DialectNullable columns

camelCase fields

Dates as ISO strings

BIGINT as bigint

SQL DDL input

Paste CREATE TABLE (and Postgres CREATE TYPE … AS ENUM) statements.

Open .sql

Output · 2 tables

JavaScript

import { z } from "zod";

export const UserRoleSchema = z.enum(["admin", "editor", "viewer"]);

export const UserSchema = z.object({
  id: z.string().uuid(),
  email: z.string().max(255),
  displayName: z.string().nullable(),
  role: UserRoleSchema,
  tags: z.array(z.string()).nullable(),
  settings: z.unknown().nullable(),
  createdAt: z.coerce.date(),
});

export type User = z.infer<typeof UserSchema>;

export const PostSchema = z.object({
  id: z.number().int(),
  authorId: z.string().uuid(),
  title: z.string().max(200),
  body: z.string().nullable(),
  published: z.boolean(),
  updatedAt: z.coerce.date().nullable(),
});

export type Post = z.infer<typeof PostSchema>;

About the SQL DDL to TypeScript / Zod / Prisma

Paste PostgreSQL, MySQL, or SQLite CREATE TABLE statements and instantly get TypeScript interfaces, Zod validation schemas, and a Prisma schema with enums, defaults, unique constraints, composite keys, and foreign-key relations — generated entirely in your browser.

Examples

Users table

SQLCREATE TABLE users (id SERIAL PRIMARY KEY, email TEXT NOT NULL);

Output

JavaScriptexport const UserSchema = z.object({ id: z.number().int(), email: z.string() });

Keyboard shortcuts

Copy the main outputCtrl / ⌘ + Shift + C
Download the resultCtrl / ⌘ + S
Share this toolCtrl / ⌘ + Shift + S
Reset the inputsAlt + R
Open the tool search paletteCtrl / ⌘ + K

Related tools

Sql To Json

Converters

Parse simple SQL INSERT INTO statements into JSON rows.

Android strings.xml ↔ JSON Converter

Converters

Convert Android string resources to JSON and back.

Csv To Json

Converters

Convert between CSV and JSON with delimiter and header options.

Csv To Markdown Table

Converters

Convert CSV into a Markdown or HTML table with alignment options.

CSV to SQL INSERT

Converters

Generate SQL INSERT statements from CSV data.

CSV to XML

Converters

Convert CSV data into well-formed XML with custom tag names.

Frequently asked questions

Version 1.0.0 · Updated 2026-10-04 · Runs entirely in your browser