JSON to SQL

Open JSON to SQL on Happytails.ai. This view has the same page content and links, with explicit tool capabilities. Read the processing notes before using a tool.

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,
      "inputMaxLength": 1000000,
      "inputMode": "text",
      "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.",
      "helpParts": [
        "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