SQL to TypeScript interfaces converter

Paste your CREATE TABLE statements and get a TypeScript interface per table, with SQL types mapped to their closest TS equivalent and nullable columns typed as | null.

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.

export interface Users {
  id: number;
  email: string;
  full_name: string | null;
  created_at: string | null;
  last_login_at: string | null;
}

export interface Orders {
  id: number;
  user_id: number | null;
  status: string;
  total_cents: number;
  currency: string | null;
  placed_at: string | null;
  shipped_at: string | null;
}

export interface OrderItems {
  id: number;
  order_id: number | null;
  product_id: number;
  quantity: number;
}

export interface Products {
  id: number;
  sku: string;
  name: string;
  price_cents: number;
  inventory_count: number | null;
  active: boolean | null;
}

export interface Payments {
  id: number;
  order_id: number | null;
  amount_cents: number;
  method: string;
  processed_at: string | null;
}

export interface Sessions {
  id: number;
  token: string;
  expires_at: string | null;
}

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 TypeScript interfaces converter

Find the gaps beforeproduction does.

Find the gaps before
production does.