SQL 转 TypeScript

将 SQL CREATE TABLE 语句转换为 TypeScript 接口。保持您的类型与数据库同步。

Use interfacesNullable as optional (?)

SQL CREATE TABLE Statements

TypeScript Types

SQL to TypeScript Type Mapping:

INT/SERIAL → number

VARCHAR/TEXT → string

BOOLEAN → boolean

TIMESTAMP → Date

JSON/JSONB → Record

DECIMAL → number

UUID → string

BYTEA → Buffer

Database Type Safety - 技术详情

Generating TypeScript types from SQL schemas ensures your application code matches your database structure. Column types are mapped to TypeScript equivalents, and NULL columns become optional properties.

命令行替代方案

-- SQL\nCREATE TABLE users (\n  id SERIAL PRIMARY KEY,\n  email VARCHAR(255) NOT NULL\n);\n\n// TypeScript\ninterface Users {\n  id: number;\n  email: string;\n}

参考

查看官方规范