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 MCP tool findutils:json_to_sql. See the REST reference →

Use in the browser View as Markdown

Call it over MCP

Tool name findutils:json_to_sql · no API keys · 120 requests/min per IP

Claude Code

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

Claude Desktop — claude_desktop_config.json

{
  "mcpServers": {
    "findutils": {
      "url": "https://mcp.findutils.com/"
    }
  }
}

Raw JSON-RPC (any MCP client) — verified example

curl -X POST https://mcp.findutils.com/ \
  -H "Content-Type: application/json" \
  -d '{
    "jsonrpc": "2.0",
    "id": 1,
    "method": "tools/call",
    "params": {
      "name": "json_to_sql",
      "arguments": {
        "json": "[{\"id\":1,\"name\":\"Ada\",\"active\":true}]",
        "table": "people",
        "dialect": "postgres"
      }
    }
  }'

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 a REST endpoint

The same tool answers plain HTTP at POST /api/tools/json-to-sql/execute — no key, 60 requests/min.

Open the REST 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.