Paste a CSV sample, get a MySQL-dialect DDL with proper types and lengths.
Open the Schema Inferrer →Generate a MySQL CREATE TABLE from any CSV sample. Types are mapped to MySQL conventions: BOOLEAN values become TINYINT(1), UUIDs become CHAR(36), timestamps become DATETIME, and string columns are bucketed into VARCHAR(N) sizes that fit InnoDB row limits. Output is ready to paste into MySQL Workbench, the mysql CLI, or your favorite migration tool.
Sample values and the dialect-native type they map to.
| Sample value | Inferred type |
|---|---|
| 0, 1, 42 | INT |
| 12345678901234 | BIGINT |
| 0.99, 12.50 | DECIMAL(10,2) |
| true, 0, yes, NO | TINYINT(1) |
| 2024-03-15 | DATE |
| 2024-03-15 09:30:00 | DATETIME |
| a3bb189e-8bf9-3888-… | CHAR(36) |
| "short text" | VARCHAR(64) |
| very long article body | TEXT |
order_id,user_id,total,placed_at,paid 1001,42,29.99,2024-03-15 14:22:10,1 1002,99,150.00,2024-03-15 14:25:01,0
CREATE TABLE orders (
order_id INT NOT NULL,
user_id INT NOT NULL,
total DECIMAL(10,2) NOT NULL,
placed_at DATETIME NOT NULL,
paid TINYINT(1) NOT NULL
);
No signup, no install — runs entirely in your browser.
Open the Schema Inferrer →