Sql To Csv API

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

Read rows out of SQL INSERT statements and return CSV, one file per table. Parses a mysqldump, a SQLite dump or a pg_dump made with --inserts as text — nothing is executed against a database. PostgreSQL COPY blocks (the pg_dump default) are not read. Column names come from the INSERT column list, then from a CREATE TABLE in the same input, then from positions. NULL becomes an empty cell. Dump noise such as SET, LOCK TABLES and comments is ignored, and an INSERT ... SELECT with no literal VALUES is reported rather than guessed at.

Open the tool Try it

Request body

application/json

sql

string required

SQL dump text containing INSERT statements.
table

string optional

Return only this table. Default: every table found.
delimiter

string optional

Output field separator. Default: a comma. Default ",".
max_rows

integer optional

Stop after this many rows per table. Default 50000, maximum 200000. Default 50000.

Example arguments

Verified

{
  "sql": "INSERT INTO people (id, name) VALUES (1, 'Ada'), (2, 'Doe, John');"
}

curl -X POST https://api.findutils.com/api/tools/sql-to-csv/execute \
  -H "Content-Type: application/json" \
  -d '{
    "sql": "INSERT INTO people (id, name) VALUES (1, '\''Ada'\''), (2, '\''Doe, John'\'');"
  }'

const response = await fetch('https://api.findutils.com/api/tools/sql-to-csv/execute', {
  method: 'POST',
  headers: { 'Content-Type': 'application/json' },
  body: JSON.stringify({"sql":"INSERT INTO people (id, name) VALUES (1, 'Ada'), (2, 'Doe, John');"}),
});
const data = await response.json();

import requests

response = requests.post(
    "https://api.findutils.com/api/tools/sql-to-csv/execute",
    json={"sql":"INSERT INTO people (id, name) VALUES (1, 'Ada'), (2, 'Doe, John');"},
)
data = response.json()

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

Also an MCP tool

Call sql_to_csv 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: sql-to-csv
MCP name: sql_to_csv
Category: Data
Machine-readable: openapi.json · markdown.md

Request body

Example arguments

More Data tools

More to explore