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.

Needs an API key. Running a tool needs an API key. Keys are not for sale yet: ask for early access. About API keys

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 "Authorization: Bearer YOUR_API_KEY" \
  -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', Authorization: 'Bearer YOUR_API_KEY' },
  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",
    headers={"Authorization": "Bearer YOUR_API_KEY"},
    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', 'Authorization: Bearer YOUR_API_KEY'],
    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: API key
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