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.