INSERT rows to YAML
Column names become YAML keys and each INSERT row becomes an object-style item, with CREATE TABLE support when column lists are omitted.
Rows
0
Columns
0
Tables
0
Warnings
0
Diagnostics
SQL YAML output
This SQL to YAML converter online turns common SQL INSERT statements into YAML without running a database. Paste INSERT rows, optionally include CREATE TABLE definitions when column names are missing, then choose auto table groups, rows array or group-by-table output with indentation or compact flow style. It helps developers, QA teams and migration work turn seed data into config-like fixtures, documentation snippets and readable review files directly in the browser.
Column names become YAML keys and each INSERT row becomes an object-style item, with CREATE TABLE support when column lists are omitted.
Choose auto table groups, rows array or group-by-table output, then switch between 2-space, 4-space and compact flow-style YAML.
The converter quotes strings that could be misread by YAML, such as dates, reserved values, leading symbols and text containing comments or punctuation.
The converter works best with INSERT INTO table (columns) VALUES (...) statements. If the INSERT does not include columns, add CREATE TABLE first so the parser can use the table's column order.
Column names become keys, row values become YAML scalars, and supported SQL NULL, boolean and numeric values are preserved where possible. Strings are quoted when plain YAML could be ambiguous.
This tool parses SQL locally in the browser and does not execute queries, connect to a database, infer schemas or guarantee every SQL dialect. Review generated YAML for indentation, quoting, nulls, dates, complex expressions, binary values and vendor-specific INSERT syntax. For production migrations or config files, validate the YAML and confirm the receiving system reads the values as intended.
It is designed for common SQL INSERT statements, including multi-row VALUES blocks. A matching CREATE TABLE statement can provide column order when INSERT rows omit columns.
No. It parses SQL text locally in the browser and converts rows into YAML output. It does not run queries, connect to databases or inspect schemas.
The page supports auto table groups, rows array and group-by-table modes, with 2-space, 4-space and compact flow-style output controls.
Column names become YAML keys, and each INSERT row becomes an object-style YAML item. Supported SQL NULL, boolean and numeric values are converted where possible.
Use YAML Validator to check syntax and YAML Formatter to reformat or inspect the output before using it in configs, fixtures or migration notes.
Complex expressions, stored procedures, SELECT results, binary values, malformed INSERT statements and vendor-specific dump quirks may need manual cleanup.