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

Convert toLive preview on · Ctrl+Enter to convert

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.

Try these tools next

View all tools →

CSV to SQL

Converter

Turn CSV into CREATE TABLE + INSERTs with auto-detected types.

Open tool

JSON ↔ SQL

Converter

Convert JSON arrays to SQL — and INSERTs back to JSON — live.

Open tool

Timestamp Converter

Converter

Convert between epoch time and human-readable dates.

Open tool

Data Anonymizer

Converter

Mask emails, SSNs, cards & IPs with realistic format-preserving fakes.

Open tool

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

Convert toLive preview on · Ctrl+Enter to convert

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

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.