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.

Popular uses

sql
ddl
create table
typescript
zod
prisma
schema
postgres

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

JSON to SQL INSERT

Converters

Generate SQL INSERT statements from a JSON array of objects.

SQLite Database Viewer & Query Runner

Dev Utilities

Open a .sqlite/.db file in your browser and run SQL against it.

SQL Formatter

Dev Utilities

Format and indent SQL queries for readability.

SQL Playground & Query Runner

Dev Utilities

Write schema and seed SQL, then run queries against an in-memory database.

SQL Query Analyzer

Dev Utilities

Find expensive SQL patterns, missing filters and index opportunities.

Sql To Json

Converters

Parse simple SQL INSERT INTO statements into JSON rows.

Works well with

Next steps from other categories.

.gitignore Generator

Generators

Build a .gitignore file from built-in language and OS presets.

Fake User Generator

Generators

Generate random fake user records with names, emails, and addresses.

Mock JSON Generator

Generators

Generate arrays of mock JSON records from a simple field schema.

Password Generator

Generators

Create secure passwords with custom length and character sets.

All Converters tools

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

Popular uses

Examples

Keyboard shortcuts

Related tools

JSON to SQL INSERT

SQLite Database Viewer & Query Runner

SQL Formatter

SQL Playground & Query Runner

SQL Query Analyzer

Sql To Json

Works well with

.gitignore Generator

Fake User Generator

Mock JSON Generator

Password Generator

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