SQL Data Type Mapper
Paste column definitions (one per line: name TYPE) or a full CREATE TABLE block and convert types to another dialect. Runs entirely in your browser.
How to use:
- Paste column definitions (name TYPE per line) or a full CREATE TABLE statement
- Pick Columns or Full-DDL mode — DDL mode preserves constraints and formatting
- Select your target SQL dialect
- Output updates live as you type — or press Ctrl+Enter to convert on demand
- Copy the converted types for your migration
Columns (name TYPE per line) 103 chars · 7 lines
Converted
Converted columns will appear here.
Mappings are closest-fit equivalents — precision, auto-increment, and unicode semantics can differ between databases. Verify converted DDL against the target database before migrating.
About this tool
SQL Data Type Mapper is a free online tool that translates column data types between MySQL, PostgreSQL, SQL Server (T-SQL), Oracle, and SQLite. Paste a list of column definitions and get the equivalent type in the target dialect — useful when migrating schemas or writing cross-database DDL.
- Dialects
- MySQL, PostgreSQL, SQL Server (T-SQL), Oracle, SQLite
- Input
- Column definitions (name TYPE per line) or a full CREATE TABLE block
- Output
- Converted column definitions for the target dialect, with constraints preserved in Full-DDL mode
- Coverage
- 30+ type shapes including SERIAL, NUMERIC(p,s), NVARCHAR, TIMESTAMPTZ, JSONB, ENUM/SET, MONEY, UUID — unrecognized types are reported, never silently passed off as converted
- Signup
- Not required
- Processing
- Entirely in your browser — pasted schema text is never uploaded
- Difference
- Full CREATE TABLE mode with honest unmapped-type reporting instead of silent passthrough
- Price
- Free, no usage limits
Limitations
- Mappings are closest-fit equivalents — precision, auto-increment, and unicode semantics can differ between databases
- Verify converted DDL against the target database before migrating
Data Type Mapper — FAQ
Is the Data Type Mapper free?
Yes. The Data Type Mapper is completely free with no signup and no usage limits, like all SqlInt mini tools.
Which database dialects are covered?
MySQL, PostgreSQL, SQL Server (T-SQL), Oracle, and SQLite — 30+ type shapes including SERIAL, NUMERIC(p,s), NVARCHAR, TIMESTAMPTZ, and JSONB.
Can I paste a full CREATE TABLE statement?
Yes. Full-DDL mode maps types in place while preserving constraints, commas, and formatting — and reports any unrecognized types instead of silently passing them through.
Does my data leave my browser?
No. Every mini tool processes data locally in your browser — pasted text and uploaded files never leave your device.