SQL to CSV Converter — Data Migration Tools

Overview

Parses SQL INSERT statements and emits CSV rows.

Features

Parses multi-row INSERTs.
Handles quoted strings.

Use cases

Auditing a SQL seed file.
Extracting test data.

API reference

POST /api/v1/tools/convert

Convert text between CSV, JSON, XML, YAML, and SQL by pivoting through JSON when no direct converter exists.

Returns: The converted text, the row count from the last step that reported one, and the converter chain that ran.

Parameters

Name	Type	Required	Default	Description
`input`	string	Yes	—	The text to convert, in the source format.
`autoTypes`	boolean	No	`true`	Infer number/boolean/null types when parsing CSV rather than treating every cell as a string.
`dialect`	string (mysql\|postgres\|sqlserver\|sqlite)	No	—	SQL dialect for CSV-to-SQL output. Ignored for other target formats.
`table`	string	No	`"data"`	Table name for CSV-to-SQL INSERT statements. Ignored for other target formats.
`rootElement`	string	No	`"root"`	Root XML element name for JSON-to-XML output. Ignored for other target formats.

For this tool, use from: "sql" and to: "csv".

Example

curl -X POST https://data-migration-tools.com/api/v1/tools/convert \
  -H "Content-Type: application/json" \
  -d '{"from":"sql","to":"csv","input":"INSERT INTO users (id, name) VALUES (1, '\''Ada'\''), (2, '\''Grace'\'');"}'

See the full API reference for all examples and error codes.