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.

Which Drizzle dialect is generated?

It follows the dialect you pick: pgTable for PostgreSQL, mysqlTable for MySQL/MariaDB and sqliteTable for SQLite, including enums, references and composite primary keys.

Can I download the diagram?

Yes. The Diagram tab shows tables, primary/foreign keys and relationship lines, and Download saves it as an SVG image.

SQL DDL to TypeScript / Zod / Prisma / Drizzle

Generate TypeScript, Zod, Prisma, Drizzle, JSON Schema and an ER diagram 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 / Drizzle

Paste PostgreSQL, MySQL, or SQLite CREATE TABLE statements and instantly get TypeScript interfaces, Zod validation schemas, a Prisma schema, Drizzle ORM tables, JSON Schema definitions and a downloadable entity-relationship diagram 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

From SQL DDL to TypeScript, Zod, Prisma and Drizzle — plus clean CSV data, all offline
Turn CREATE TABLE statements into type-safe schemas and an ER diagram, then inspect, clean and export CSV files without uploading your data anywhere.

Version 2.0.0 · Updated 2026-10-08 · Runs entirely in your browser

SQL DDL to TypeScript / Zod / Prisma / Drizzle

About the SQL DDL to TypeScript / Zod / Prisma / Drizzle

Examples

Keyboard shortcuts

Related tools

Sql To Json

Android strings.xml ↔ JSON Converter

Csv To Json

Csv To Markdown Table

CSV to SQL INSERT

CSV to XML

Frequently asked questions

Which SQL dialects are supported?

Are foreign keys turned into Prisma relations?

Is my schema uploaded anywhere?

Does it support ALTER TABLE or views?

Which Drizzle dialect is generated?

Can I download the diagram?

Read more