JSON Tool

SQL to YAML Converter

Turn SQL INSERT statements into YAML records, for fixtures and seed files.

Runs in your browserSQL → YAML

Loading tool…

Example

Input

INSERT INTO users (id, name, admin) VALUES
  (1, 'Ada', TRUE),
  (2, 'O''Brien', NULL);

Output

- id: 1
  name: Ada
  admin: true
- id: 2
  name: O'Brien
  admin: null

How to use the SQL to YAML Converter

Paste or type your SQL into the input area, or open a file from your device.
Adjust the options above the editor if the tool offers any.
Review the YAML result, then copy it or download it as a file.

Privacy and limitations

Your data is processed on your device and is not uploaded to any server.

SQL to JSON ConverterConvert SQL INSERT statements into JSON records. Handles multi-row VALUES, quoted strings, NULL and booleans.SQL to HTML TableRender rows from SQL INSERT statements as an HTML table, with one table per database table and a safe preview.SQL to XML ConverterConvert SQL INSERT statements into XML, with one element per row and one child element per column.SQL to CSV ConverterExtract rows from SQL INSERT statements into CSV, ready for Excel or another database import.SQL MinifierCompress SQL onto one line by removing comments and extra whitespace, without touching string literals.SQL FormatterBeautify SQL queries with dialect-aware formatting for MySQL, PostgreSQL, SQL Server, Oracle, SQLite and more.

Browse all sql converters →