Schema & Code Converter 100% In-Browser

Convert SQL CREATE TABLE to TypeScript Interfaces Online

Instantly transform SQL table definitions into clean, strictly-typed TypeScript interface declarations.

SQL Dialect:

Target Output:

SQL DDL Input (PostgreSQL)

typescript Output✓ Parsed 1 table (AST transpiler)

export interface Users {
  id: number;
  email: string;
  full_name?: string | null;
  age?: number | null;
  is_active?: boolean | null;
  created_at?: Date | string | null;
}

Did this converter save you time? Completely optional · From $3 — keeps Microdeck fast and free.

Privacy-Friendly Sponsor Unit

Contextual tech, developer, & creator tools sponsorship slot. Zero intrusive tracking.

Sample Conversion: SQL DDL → TypeScript Interfaces

Input (SQL DDL)

CREATE TABLE customers (
  id INT PRIMARY KEY,
  email VARCHAR(255) NOT NULL,
  phone VARCHAR(20),
  balance NUMERIC(12,2) NOT NULL
);

Output (TypeScript Interfaces)

export interface Customer {
  id: number;
  email: string;
  phone?: string | null;
  balance: number;
}

Frequently Asked Questions

Are nullable columns represented as optional in TypeScript?

Yes, columns without a NOT NULL constraint are generated as optional (? : type | null).

Other Popular Database Schema Conversions

SQL DDL to Prisma Schema SQL DDL to Drizzle ORM SQL DDL to Zod Schema PostgreSQL DDL to Prisma Schema PostgreSQL DDL to Drizzle pgTable MySQL DDL to Prisma Schema MySQL DDL to Drizzle mysqlTable