SQL & Database · 100% Client-Side & Private

SQL to TypeScript Interface Converter — Free Online Table-to-Type Generator

Convert SQL CREATE TABLE statements into TypeScript interfaces. Automatically maps SQL types to number, string, boolean, Date, and nullable fields.

Converter:

sqlInput Source

7 lines

typescriptConverted Output

8 lines

export interface Products {
  id: number;
  name: string;
  price: number;
  description?: string;
  created_at?: Date | string;
}

Real-time instant in-browser transformation (Zero data leaves your device)

Target File:sql-to-typescript-output.ts

How the SQL DDL to TypeScript Works

Converts SQL table schemas directly into TypeScript type definitions.

Gives backend developers full compile-time type safety when querying relational tables via pg, mysql2, or sqlite3.

INPUT (SQL)

CREATE TABLE logs (id INT, message TEXT);

OUTPUT (TYPESCRIPT)

export interface Logs {
  id?: number;
  message?: string;
}

How does it handle nullable columns?

Columns that do not have NOT NULL or PRIMARY KEY are marked as optional TypeScript properties (e.g. col?: string).

Convert SQL CREATE TABLE statements into Prisma schema models with @id, @unique, types, and timestamp defaults.

Convert JSON to clean TypeScript interfaces with nested object resolution, primitive mapping, and optional properties.

Generate SQL CREATE TABLE and INSERT INTO statements from any JSON object or array of objects. Handles escaped quotes and types.