SQL to Zod schema converter

Paste your CREATE TABLE statements and get a Zod object schema per table, plus a z.infer'd TypeScript type — ready to drop into request validation.

YOUR SQL

DIALECT

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  full_name TEXT,
  created_at TIMESTAMP DEFAULT now(),
  last_login_at TIMESTAMP
);

CREATE TABLE orders (
  id SERIAL PRIMARY KEY,
  user_id INTEGER REFERENCES users(id),
  status TEXT NOT NULL,
  total_cents INTEGER NOT NULL,
  currency TEXT DEFAULT 'usd',
  placed_at TIMESTAMP DEFAULT now(),
  shipped_at TIMESTAMP
);

CREATE TABLE order_items (
  id SERIAL PRIMARY KEY,
  order_id INTEGER REFERENCES orders(id),
  product_id INTEGER NOT NULL,
  quantity INTEGER NOT NULL DEFAULT 1
);

CREATE TABLE products (
  id SERIAL PRIMARY KEY,
  sku TEXT UNIQUE NOT NULL,
  name TEXT NOT NULL,
  price_cents INTEGER NOT NULL,
  inventory_count INTEGER DEFAULT 0,
  active BOOLEAN DEFAULT true
);

CREATE TABLE payments (
  id SERIAL PRIMARY KEY,
  order_id INTEGER REFERENCES orders(id),
  amount_cents INTEGER NOT NULL,
  method TEXT NOT NULL,
  processed_at TIMESTAMP
);

CREATE TABLE sessions (
  id SERIAL PRIMARY KEY,
  token TEXT UNIQUE NOT NULL,
  expires_at TIMESTAMP
);

CREATE INDEX idx_order_items_order_id ON order_items(order_id);
CREATE INDEX idx_payments_order_id ON payments(order_id);

TYPESCRIPT OUTPUT

// Generated by ERD Factory - review relation/field names before use.

import { z } from "zod";

export const usersSchema = z.object({
  id: z.number(),
  email: z.string(),
  full_name: z.string().nullable(),
  created_at: z.string().nullable(),
  last_login_at: z.string().nullable(),
});

export type Users = z.infer<typeof usersSchema>;

export const ordersSchema = z.object({
  id: z.number(),
  user_id: z.number().nullable(),
  status: z.string(),
  total_cents: z.number(),
  currency: z.string().nullable(),
  placed_at: z.string().nullable(),
  shipped_at: z.string().nullable(),
});

export type Orders = z.infer<typeof ordersSchema>;

export const orderItemsSchema = z.object({
  id: z.number(),
  order_id: z.number().nullable(),
  product_id: z.number(),
  quantity: z.number(),
});

export type OrderItems = z.infer<typeof orderItemsSchema>;

export const productsSchema = z.object({
  id: z.number(),
  sku: z.string(),
  name: z.string(),
  price_cents: z.number(),
  inventory_count: z.number().nullable(),
  active: z.boolean().nullable(),
});

export type Products = z.infer<typeof productsSchema>;

export const paymentsSchema = z.object({
  id: z.number(),
  order_id: z.number().nullable(),
  amount_cents: z.number(),
  method: z.string(),
  processed_at: z.string().nullable(),
});

export type Payments = z.infer<typeof paymentsSchema>;

export const sessionsSchema = z.object({
  id: z.number(),
  token: z.string(),
  expires_at: z.string().nullable(),
});

export type Sessions = z.infer<typeof sessionsSchema>;

See these 6 tables as an interactive diagram, get AI-suggested fixes, and save your schema — free.

Open in the full editor

Find the gaps before
production does.

Paste a schema and see your first analysis in under ten seconds.

Try ERD Factory free

ERD Factory

Schema visualization & analysis for people who ship databases.

PRODUCTFeatures Pricing Roadmap

RESOURCESDocumentation Free Tools DDL reference Blog

COMPANYAbout Contact

LEGALPrivacy Policy Cookie Policy

SQL to Zod schema converter

Find the gaps beforeproduction does.

Find the gaps before
production does.