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.
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.