JSON to MySQL

About this tool

Paste a JSON object and get a MySQL CREATE TABLE statement. Column types are guessed from each field value: whole numbers become INT or BIGINT, fractional numbers become DOUBLE, booleans become TINYINT(1), and strings become DATETIME when they look like an ISO date-time, VARCHAR(255) when short, or TEXT when long. Nested objects and arrays are stored as TEXT (JSON). The table name is configurable and defaults to my_table.

This gives you a first-draft schema from a sample record that you can refine with keys, indexes and constraints. The whole tool is plain JavaScript running locally in your browser — no build step, no server, no upload — so it is safe for private or proprietary payloads.

Related tools

JSON FormatterJSON to TypeScriptJSON to JSON SchemaJSON to Protobuf