Numeric types

SQL INT, INTEGER, SMALLINT, TINYINT, MEDIUMINT, BIGINT, SERIAL, and BIGSERIAL all map to TypeScript number. FLOAT, DOUBLE, DOUBLE PRECISION, REAL, NUMERIC, and DECIMAL also map to number. In Prisma, integers map to Int or BigInt, while decimals map to Decimal or Float. For JavaScript safety with very large integers (BIGINT), consider using BigInt type instead of number.

// SQL → TypeScript type mapping reference

// Integers
// SMALLINT, INT2                → number
// INTEGER, INT, INT4            → number
// BIGINT, INT8                  → bigint (or string)
// SERIAL, BIGSERIAL             → number (auto-increment)

// Floating point
// REAL, FLOAT4                  → number
// DOUBLE PRECISION, FLOAT8      → number
// DECIMAL, NUMERIC              → string (arbitrary precision)

// Text
// VARCHAR(n), CHAR(n), TEXT     → string

// Boolean
// BOOLEAN                       → boolean

// Date/Time
// TIMESTAMP, TIMESTAMPTZ        → Date (or string)
// DATE                          → string (YYYY-MM-DD)

// JSON
// JSON, JSONB                   → Record<string, unknown>

// UUID
// UUID                          → string

String and text types

VARCHAR(n), CHAR(n), TEXT, and all text variants (TINYTEXT, MEDIUMTEXT, LONGTEXT) map to TypeScript string. UUID also maps to string since TypeScript has no built-in UUID type. ENUM types typically map to string, though you can use string literal union types for type safety (e.g., 'active' | 'inactive').

Date, time, and boolean types

TIMESTAMP, TIMESTAMPTZ, DATETIME, DATE, TIME, and TIME WITH TIME ZONE all map to TypeScript Date. BOOLEAN and BOOL map to boolean. In Prisma, date types map to DateTime and boolean types map to Boolean. Drizzle preserves the specific column type function (timestamp, date, time) for accurate database mapping.

JSON and binary types

JSON and JSONB map to TypeScript Record<string, unknown> (or you can use a more specific type). BYTEA, BLOB, BINARY, and VARBINARY map to Buffer. In Prisma, JSON types map to Json and binary types map to Bytes. When working with JSON columns, consider defining a specific TypeScript interface for the expected shape of the JSON data.