a apiary.
← All tools

JSON & XML / BROWSER UTILITY

XML to SQL INSERT

Map XML records and fields to SQL INSERT statements for your database dialect.

Processed locally in your browser. Your data is not uploaded.

Want SQL that generates an XML file? Use XML to SQL Script. This tool imports XML values into a database table.

1. Discover the XML structure

UTF-8 files up to 1 MB. Up to 250,000 characters, 20,000 elements, 40,000 total nodes and 200 distinct element and attribute paths.

Good to know

Choose the XML element representing one database row. Leaf elements and attributes are matched by namespace and full path, including optional fields in later records. Values remain text unless you choose Number or NULL. Nested repeating fields cannot fit a single SQL column; omit them or select a different record. The tool generates SQL only and does not connect to a database. Comments and processing instructions are not database fields.

Example: Select /records/record, map code to record_code and name to record_name, and generate INSERT statements for your chosen dialect.