Convert PHP array to SQL free in your browser. Paste your PHP array on the left, press Convert, and copy clean SQL INSERT on the right. No sign-up, no uploads.
Converter
Paste PHP array below, press Convert, and copy the SQL INSERT output.
Advertisement
How the PHP array becomes SQL
A small recursive parser walks the array() or [] structure token by token, honoring 'key' => value pairs, nested arrays, quoted strings with escapes, numbers, booleans and null. Each top-level associative array becomes one row, and the SQL INSERT serializer then renders those rows in the target format with correct escaping for SQL.
Tips for the SQL output
Set the table name before converting, and check that the auto-detected columns match your schema, adding NOT NULL defaults or indexes afterwards in your own migration. The single multi-row INSERT keeps imports fast, and because strings are escaped with doubled quotes, the output runs as-is in MySQL, MariaDB, PostgreSQL and SQLite.
Both array(...) and [...] syntax work, with 'key' => value pairs, nested arrays, quoted strings, numbers, booleans and null. You can include the opening <?php tag and a $variable = assignment, they are stripped automatically. A list of associative arrays converts cleanest; plain lists become single-column rows.
Can I control the table and column names?
Yes, type the target table name in the field above the input; it is sanitized to letters, digits, _ and $. Column names come from your PHP array headers and are backtick-quoted. Strings are single-quoted with '' escaping, NULL stays NULL, and every row lands in one multi-row INSERT.
What happens to nested PHP arrays?
Nested arrays are preserved as nested structures in the output where the format allows it (JSON, PHP, XML), and rendered as compact JSON text in flat formats like SQL INSERT. Scalar lists become rows with a single value column.
Is there a size limit for PHP array input?
No hard limit, but everything runs in your browser tab, so tens of thousands of rows convert in seconds while millions of rows may slow the page. For very large PHP array files, split them into smaller chunks and convert each separately.
Is my PHP array data private, and who uses this?
Yes. The conversion runs 100% in your browser; nothing is uploaded to any server. Developers, analysts and DBAs use it to move PHP array data into SQL INSERT for migrations, reports and config work without installing anything.