How to use the SQL Type Mapper
1. Use the search box to filter by generic type name or database-specific type.
2. Find the row for your type and read across the columns for each database equivalent.
3. Click the copy icon on any row to copy all five equivalents to your clipboard.
What is it?
Every major SQL database uses slightly different type names — and sometimes entirely different underlying implementations. For example, "boolean" is BOOLEAN in PostgreSQL, TINYINT(1) in MySQL, BIT in MS SQL Server, and INTEGER (0/1) in SQLite.
This reference table covers the most common data types across MySQL, PostgreSQL, MS SQL Server, SQLite, and Oracle, making it easy to plan schema migrations or design cross-database compatible schemas.
Benefits
Generate INSERT and CREATE TABLE statements instantly
Convert JSON, CSV, or a field list into ready-to-run SQL in seconds — no manual quoting, no counting columns, no copy-paste errors from spreadsheet data.
Build SELECT queries without memorising syntax
The visual query builder constructs WHERE conditions, ORDER BY, LIMIT, and DISTINCT clauses interactively — useful for anyone who writes SQL occasionally rather than daily.
Migrate between MongoDB and relational databases
Convert MongoDB find, insert, update, and delete operations directly to SQL equivalents — speed up data migration planning or schema exploration.
All your data stays in the browser
No SQL query, schema definition, or database content is ever uploaded to a server. Everything runs entirely client-side, making these tools safe to use with sensitive data.
Frequently asked questions
Why does SQLite have so few types?
SQLite uses dynamic typing and only has 5 storage classes: NULL, INTEGER, REAL, TEXT, and BLOB. All other types are mapped to these. This is by design — SQLite is embedded and optimised for simplicity.
What's the difference between JSON and JSONB in PostgreSQL?
JSON stores the raw text. JSONB stores parsed binary JSON — it's larger to store but much faster to query and index. For almost all use cases, JSONB is preferred.