CSV to SQL Converter — Data Migration Tools

Overview

Converts CSV into SQL INSERT statements for the dialect of your choice. Column types are inferred from the data.

Features

Four dialects: MySQL, PostgreSQL, SQL Server, SQLite.
Custom table name.
Type inference.

Use cases

Seeding a database from a spreadsheet.
Generating test fixtures.

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: "csv" and to: "sql".

Example

curl -X POST https://data-migration-tools.com/api/v1/tools/convert \
  -H "Content-Type: application/json" \
  -d '{"from":"csv","to":"sql","input":"id,name\n1,Ada\n2,Grace"}'

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