Json To Sql

Data REST API MCP

Convert a JSON array of objects into SQL INSERT statements, optionally preceded by a CREATE TABLE. Column types come from the real JSON values, so booleans stay booleans and null becomes NULL rather than the text "null". A nested object or array is stored as JSON text. Identifiers are quoted for the chosen dialect (Postgres, MySQL or SQLite). A single object is treated as one row, and NDJSON is accepted. Nothing is executed against a database.

This page documents the HTTP endpoint POST /api/tools/json-to-sql/execute. See the MCP reference →

Use in the browser View as Markdown

Call it over REST

POST https://api.findutils.com/api/tools/json-to-sql/execute · no API keys · 60 requests/min per IP

Execute — verified arguments

curl -X POST https://api.findutils.com/api/tools/json-to-sql/execute \
  -H "Content-Type: application/json" \
  -d '{
    "json": "[{\"id\":1,\"name\":\"Ada\",\"active\":true}]",
    "table": "people",
    "dialect": "postgres"
  }'

Parameter schema for this endpoint

curl https://api.findutils.com/api/tools/json-to-sql

Interactive docs · OpenAPI 3.1 spec · All REST tools

Input schema

Argument	Type	Required	Description
json	string	yes	A JSON array of objects, a single object, or NDJSON.
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.
batch	boolean	no	Emit multi-row INSERTs instead of one statement per row. Default: false. Default: false.

Example arguments (verified)

{
  "json": [
    {
      "id": 1,
      "name": "Ada",
      "active": true
    }
  ],
  "table": "people",
  "dialect": "postgres"
}

Arguments that carry JSON as a string are shown decoded for readability. The Copy button copies the exact wire arguments.

Also an MCP tool

Claude, Cursor, and any MCP client can call this tool as findutils:json_to_sql after one connect command.

Connect once

claude mcp add findutils --transport http https://mcp.findutils.com/

Open the MCP reference for Json To Sql →

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.

Csv To Sql

Convert CSV text into SQL INSERT statements, optionally preceded by a CREATE TABLE.

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.