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.
This page documents the HTTP endpoint POST /api/tools/csv-to-sql/execute. See the MCP reference →
Call it over REST
POST https://api.findutils.com/api/tools/csv-to-sql/execute · no API keys · 60 requests/min per IP
Execute — verified arguments
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"
}' Parameter schema for this endpoint
curl https://api.findutils.com/api/tools/csv-to-sql Input schema
| Argument | Type | Required | Description |
|---|---|---|---|
| csv | string | yes | CSV text with a header row. |
| table | string | no | Target table name. Default: "my_table". Default: "my_table". |
| dialect | string (postgres | mysql | sqlite) | no | Identifier quoting and type names. Default: postgres. Default: "postgres". |
| create_table | boolean | no | Emit a CREATE TABLE before the inserts. Default: true. Default: true. |
| null_empty | boolean | no | Write an empty cell as NULL rather than an empty string. Default: true. Default: true. |
| batch | boolean | no | 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"
} Also an MCP tool
Claude, Cursor, and any MCP client can call this tool as
findutils:csv_to_sql after one connect command.
Connect once
claude mcp add findutils --transport http https://mcp.findutils.com/ More Data tools
Api Docs Generator
Return API documentation generated from a list of endpoints, as Markdown (with table of contents, request/response examples) or as an OpenAP
Bookmarks Html To Csv
Convert a browser bookmarks.html export from Chrome, Firefox, Edge, Safari or any other browser that writes the Netscape bookmark format int
Csv To Bookmarks Html
Convert a CSV of links into a Netscape bookmarks.html file that Chrome, Firefox, Edge and Safari import.
Csv To Json
Parse CSV text into an array of objects keyed by the header row.
Graphql To Typescript
Convert a GraphQL SDL schema into TypeScript type definitions and return the generated code with counts of emitted types, enums, and inputs.
Html Table To Json
Convert an HTML <table> into JSON — an array of objects keyed by the header row, or an array of row arrays.
Jq Playground
Returns the result of running a jq-style filter over a JSON document.
Json Comparer
Returns a git-style line diff of two JSON documents after both are pretty-printed with 2-space indentation.