Skip to main content
kitlocal.dev

Database Type Reference

Runs locally

100% processed in your browser. Inputs and outputs never leave your device.

Compare data types across PostgreSQL, MySQL, SQLite, and MongoDB

Base Concept
PostgreSQL
MySQL
SQL Server
Small Integer
SMALLINTSMALLINTSMALLINT
Standard Integer
INTEGERINTINT
Large Integer
BIGINTBIGINTBIGINT
Auto-increment Key
SERIAL / BIGSERIALINT AUTO_INCREMENTINT IDENTITY(1,1)
Decimal (Exact)
NUMERIC(p,s)DECIMAL(p,s)DECIMAL(p,s)
Short String (Var)
VARCHAR(n)VARCHAR(n)VARCHAR(n) / NVARCHAR(n)
Long String (Text)
TEXTTEXT / LONGTEXTVARCHAR(MAX) / NVARCHAR(MAX)
Boolean / Truth
BOOLEANTINYINT(1)BIT
Timestamp (w/ Zone)
TIMESTAMPTZTIMESTAMPDATETIMEOFFSET
JSON Object Payload
JSONB (or JSON)JSONNVARCHAR(MAX) (with CHECK)
Unique Identifier
UUIDVARCHAR(36) / BINARY(16)UNIQUEIDENTIFIER
Binary Data Array
BYTEABLOBVARBINARY(MAX)
Data Migration Safety Note
When migrating between engines (e.g. PostgreSQL to MySQL), verify character limits and JSON/TEXT engine constraints to avoid silent truncation.