SQL to TypeScript Types

This tool handles the most common SQL column types: VARCHAR, TEXT, CHAR, and NVARCHAR map to string; INT, INTEGER, BIGINT, SMALLINT, TINYINT, SERIAL, BIGSERIAL, and NUMERIC/DECIMAL map to number; BOOLEAN and BOOL map to boolean; TIMESTAMP, DATETIME, DATE, and TIME map to Date in the TypeScript interface; JSON and JSONB map to unknown. Any unrecognized type also maps to unknown.

Columns with NOT NULL constraint become required fields in the TypeScript interface (no ? optional modifier). Columns that allow NULL (no NOT NULL, or explicitly NULL) become optional fields with the type unioned with null, e.g. name?: string | null. This mirrors how database queries return nullable columns.

Zod is a TypeScript-first schema validation library. The generated z.object({...}) schema lets you validate API inputs, database query results, or form data at runtime. For example, you can use it in tRPC inputs, Next.js API routes, or Fastify request validation. The generated Zod schema mirrors the TypeScript interface — required fields use the base type and optional fields use .nullable().optional().

Yes. The parser handles multiple CREATE TABLE statements in one paste. Each table generates its own TypeScript interface and Zod schema block. The output blocks are separated by blank lines. Table names are converted to PascalCase for the interface name and camelCase for the Zod variable name.