Csv To Sql API

POST https://api.findutils.com/api/tools/csv-to-sql/execute

Convert CSV text into SQL INSERT statements, optionally preceded by a CREATE TABLE. The first row is the header and becomes the column list. Column types are inferred from the first 50 data rows as integer, numeric, boolean, or text, and identifiers are quoted for the chosen dialect (Postgres, MySQL, or SQLite). Empty cells become NULL by default. Nothing is executed against a database.

Open the tool Try it

Request body

application/json

csv

string required

CSV text with a header row.
table

string optional

Target table name. Default: "my_table". Default "my_table".
dialect

string optional

Identifier quoting and type names. Default: postgres. One of postgres · mysql · sqlite. Default "postgres".
create_table

boolean optional

Emit a CREATE TABLE before the inserts. Default: true. Default true.
null_empty

boolean optional

Write an empty cell as NULL rather than an empty string. Default: true. Default true.
batch

boolean optional

Emit one multi-row INSERT instead of one statement per row. Default: false. Default false.

Example arguments

Verified

{
  "csv": "id,name\n1,Ada\n2,\"Doe, John\"",
  "table": "people",
  "dialect": "postgres"
}

curl -X POST https://api.findutils.com/api/tools/csv-to-sql/execute \
  -H "Content-Type: application/json" \
  -d '{
    "csv": "id,name\n1,Ada\n2,\"Doe, John\"",
    "table": "people",
    "dialect": "postgres"
  }'

const response = await fetch('https://api.findutils.com/api/tools/csv-to-sql/execute', {
  method: 'POST',
  headers: { 'Content-Type': 'application/json' },
  body: JSON.stringify({"csv":"id,name\n1,Ada\n2,\"Doe, John\"","table":"people","dialect":"postgres"}),
});
const data = await response.json();

import requests

response = requests.post(
    "https://api.findutils.com/api/tools/csv-to-sql/execute",
    json={"csv":"id,name\n1,Ada\n2,\"Doe, John\"","table":"people","dialect":"postgres"},
)
data = response.json()

$ch = curl_init('https://api.findutils.com/api/tools/csv-to-sql/execute');
curl_setopt_array($ch, [
    CURLOPT_POST => true,
    CURLOPT_HTTPHEADER => ['Content-Type: application/json'],
    CURLOPT_POSTFIELDS => '{"csv":"id,name\n1,Ada\n2,\"Doe, John\"","table":"people","dialect":"postgres"}',
    CURLOPT_RETURNTRANSFER => true,
]);
$data = json_decode(curl_exec($ch), true);

Also an MCP tool

Call csv_to_sql from Claude, Cursor or any MCP client. Same arguments, same output.

https://mcp.findutils.com

MCP reference

Rate limit: 60 a minute, per IP
Auth: None
REST id: csv-to-sql
MCP name: csv_to_sql
Category: Data
Machine-readable: openapi.json · markdown.md

Request body

Example arguments

More Data tools

More to explore