DATA TOOLS

Convert JSON, XML, and SQL data

Convert between JSON, XML, and SQL INSERT representations. Check your source data and choose formatting options for the generated output.

Paste the source, select a conversion direction, and copy or download the result.

01 / CONVERSION

Select a direction

What convert

Преобразуйте JSON в XML с метками типов для обратной конвертации.

Conversion settings

operate without reboot

Root name XML element

Dialect SQL

Table name

Indent

Keep JSON types and structure to XML for reverse conversion Wrap XML attributes in properties with prefix @ Recognize numbers, true/false and null in XML text Remove whitespace around the edges of XML text Add CREATE TABLE Add INSERT records Normalize column names to ASCII snake_case

SOURCE DATA

JSON

RESULT

XML

Выберите проверку или преобразование.

JSON, XML and SQL conversion

Convert JSON and XML back and forth, generate SQL for MySQL/MariaDB, PostgreSQL or SQLite, and parse INSERT queries into JSON or XML. For SQL output, you can specify the table name and enable CREATE TABLE and INSERT separately.

JSON ↔ XML with arrays, nested objects, attributes and repeating elements;
saving the original JSON types in XML with special tags for more accurate reverse conversion;
generates SQL with escaping identifiers and values for the selected dialect;
checking the source, opening the file, copying and downloading result.

SQL → JSON/XML parses INSERT queries with an explicit list of columns and simple literals in VALUES. This is not a database connection or a general-purpose SQL parser: SELECT queries, functions, subqueries and calculated expressions are not supported.

Convert JSON, XML, and SQL data

Select a direction

Conversion settings

JSON

XML

JSON, XML and SQL conversion

How to select a conversion

Check the source data