JSON to SQL | agent view
The same page content and links, with explicit tool capabilities. Tools marked with an API can run directly through HTTP. Other tools require the browser interface or are not connected yet.
Tool capabilities
{
"id": "json-to-sql",
"category": "data-tools",
"built": true,
"requirements": "SQL dialect, table name and escaped literals; no execution; infer column types transparently.",
"implementation": {
"fields": [
{
"key": "delimiter",
"label": "CSV separator",
"value": ",",
"type": "select",
"values": [
",",
";",
"\t"
]
},
{
"key": "table",
"label": "SQL table",
"value": "data",
"type": "text"
}
],
"note": "ANSI-style quoted identifiers and string values. Review column types before executing SQL.",
"experience": {
"automatic": true,
"single": false,
"label": "JSON",
"placeholder": "{\"name\":\"Ada\",\"count\":2}",
"help": "Use double-quoted property names and valid JSON values. Results update as you type. Up to 1,000,000 characters.",
"action": null
},
"mode": "automatic",
"interactive": false
},
"execution": "POST /api/v1/tools/json-to-sql/run",
"api": {
"id": "json-to-sql",
"name": "JSON to SQL",
"category": "data-tools",
"description": "Convert JSON to SQL.",
"notes": "ANSI-style quoted identifiers and string values. Review column types before executing SQL.",
"human_path": "/en/data-tools/json-to-sql/",
"method": "POST",
"endpoint": "/api/v1/tools/json-to-sql/run",
"schema_url": "/api/v1/tools/json-to-sql",
"input_schema": {
"type": "object",
"additionalProperties": false,
"properties": {
"input": {
"type": "string",
"maxLength": 1000000,
"default": "",
"description": "Plain text input. File tools use files instead unless otherwise documented."
},
"options": {
"type": "object",
"additionalProperties": false,
"properties": {
"delimiter": {
"type": "string",
"description": "CSV separator",
"default": ",",
"enum": [
",",
";",
"\t"
]
},
"table": {
"type": "string",
"description": "SQL table",
"default": "data"
}
}
}
}
},
"output_schema": {
"type": "object",
"required": [
"tool",
"result"
],
"properties": {
"tool": {
"type": "string"
},
"result": {
"type": "object",
"required": [
"text",
"files"
],
"properties": {
"text": {
"type": [
"string",
"null"
]
},
"data": {
"description": "Parsed JSON when the textual result is JSON."
},
"name": {
"type": "string"
},
"mime": {
"type": "string"
},
"files": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"mime",
"bytes",
"base64"
],
"properties": {
"name": {
"type": "string"
},
"mime": {
"type": "string"
},
"bytes": {
"type": "integer"
},
"base64": {
"type": "string",
"contentEncoding": "base64"
}
}
}
}
}
}
}
},
"processing": "Server; same transformation code as browser tools",
"limits": {
"request_bytes": 8388608,
"input_characters": 1000000,
"files_bytes": 5242880,
"max_files": 0,
"timeout_seconds": 12
}
},
"agent_processing": "Server; same transformation code as browser tools",
"browser_agent": {
"supported": true,
"name": "run_current_tool",
"discovery": "WebMCP on the human page in a supporting browser",
"verification": "See audit/API-AUDIT.md; availability is not verification"
}
}Page guide
Convert JSON to SQL.
Useful next steps
How to use JSON to SQL
- Enter json in the input field.
- The result updates as you type. Adjust the available settings if needed.
- Review the result, then use Copy result or a download link when available.
What to expect
Convert JSON to SQL. Paste the source content and review the available settings. Inspect nested values, numbers, empty cells, and column names before reusing the result. ANSI-style quoted identifiers and string values. Review column types before executing SQL.