Micro Tools
Advertisement

TOML to SQL Insert

Convert TOML to SQL Insert free, in seconds. Paste your data below, press Convert, then copy the result and run it against MySQL, PostgreSQL or SQLite. Everything runs in your browser, so nothing is ever uploaded.

TOML input

Paste your TOML below, then press Convert.

Tables and [[arrays of tables]] are supported, including dotted keys.
Used in the INSERT INTO clause.

SQL Insert output

Waiting for TOML input.

Private by design: conversion runs entirely in your browser with a built-in TOML parser, so your data never leaves your device.
Advertisement

How this conversion works

Paste TOML into the input box and press Convert (or just keep typing, conversion happens as you type). The tool parses it with a built-in TOML parser that understands tables, arrays of tables, dotted keys and inline tables, then generates a single multi-row INSERT statement, quoting strings, passing numbers through and turning blanks into NULL. Conversion runs entirely in your browser with a built-in TOML parser, so your data never leaves your device.

Running the SQL

The output is one multi-row INSERT statement, which loads faster than one statement per row. Strings are single-quoted with inner quotes doubled, numbers pass through unquoted, booleans become TRUE or FALSE, and empty values become NULL. Edit the Table name field before converting to target your real table; the name is sanitized to safe characters automatically.

Related tools

JSON formatterFormat and validate JSON, privately. Regex testerTest regex live with highlighting. Base64 encoderBase64 encode and decode, plus URL encoder and JWT decoder.

TOML to SQL Insert FAQs

Why convert TOML to SQL INSERT?
INSERT statements are the universal way to seed a database: run the output in MySQL, PostgreSQL, SQLite or MariaDB to load exported data into a table in one step. It is handy for migrations, demos and test fixtures.
How is my TOML parsed?
With a built-in TOML parser that supports [tables], [[arrays of tables]], dotted keys, inline tables, multiline arrays and all scalar types (strings, integers, floats, booleans and dates).
Can I change the table name?
Yes. Edit the Table name field above the output before pressing Convert. It defaults to my_table and is sanitized to letters, numbers, underscores and dollar signs.
How are values quoted?
Strings are single-quoted with inner quotes doubled, numbers pass through unquoted, booleans become TRUE or FALSE, and empty values become NULL. Everything goes into one multi-row INSERT statement for speed.
Is my data sent to a server?
No. conversion runs entirely in your browser with a built-in TOML parser, so your data never leaves your device.
Advertisement