SQL to Pydantic models converter

Paste your CREATE TABLE statements and get Pydantic BaseModel classes — typed fields, Optional[...] for nullable columns, ready for a FastAPI project.

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);

PYTHON OUTPUT

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

from typing import Optional
from pydantic import BaseModel
from datetime import datetime

class Users(BaseModel):
    id: int
    email: str
    full_name: Optional[str] = None
    created_at: Optional[datetime] = None
    last_login_at: Optional[datetime] = None

class Orders(BaseModel):
    id: int
    user_id: Optional[int] = None
    status: str
    total_cents: int
    currency: Optional[str] = None
    placed_at: Optional[datetime] = None
    shipped_at: Optional[datetime] = None

class OrderItems(BaseModel):
    id: int
    order_id: Optional[int] = None
    product_id: int
    quantity: int

class Products(BaseModel):
    id: int
    sku: str
    name: str
    price_cents: int
    inventory_count: Optional[int] = None
    active: Optional[bool] = None

class Payments(BaseModel):
    id: int
    order_id: Optional[int] = None
    amount_cents: int
    method: str
    processed_at: Optional[datetime] = None

class Sessions(BaseModel):
    id: int
    token: str
    expires_at: Optional[datetime] = None

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 Pydantic models converter

Find the gaps beforeproduction does.

Find the gaps before
production does.