Skip to content

Type Mapping ​

Database to TypeScript ​

Typelizer maps database column types to TypeScript types:

Column TypeTypeScript Type
booleanboolean
integernumber
floatnumber
decimalnumber
stringstring
textstring
citextstring
uuidstring
datestring
datetimestring
timestring

Unknown column types map to unknown.

Database to OpenAPI ​

When generating OpenAPI schemas, column types map to OpenAPI types with optional format specifiers:

Column TypeOpenAPI TypeFormat
integerinteger
bigintintegerint64
floatnumberfloat
decimalnumberdouble
booleanboolean
stringstring
textstring
citextstring
uuidstringuuid
datestringdate
datetimestringdate-time
timestringtime
jsonobject
jsonbobject
binarystringbinary
inetstring
cidrstring

Custom Type Mapping ​

Override the default mapping in your configuration:

ruby
Typelizer.configure do |config|
  config.type_mapping = config.type_mapping.merge(
    jsonb: "Record<string, unknown>",
    inet: "string"
  )
end

This affects TypeScript generation. OpenAPI mappings use a separate, fixed table.