# JSON to SQL

- Human page: https://happytails.ai/en/data-tools/json-to-sql/
- Markdown: https://happytails.ai/en/data-tools/json-to-sql.md
- Structured JSON: https://happytails.ai/agents/en/data-tools/json-to-sql/index.json
- Visibility: public

## Tool capabilities

| Property | Value |
| --- | --- |
| Tool ID | `json-to-sql` |
| Category | data-tools |
| Implementation | Registered implementation. Registration alone is not a production-quality guarantee. |
| Browser execution | Automatic updates after valid input or file selection. |
| Browser processing | Browser; see tool notes for network behavior. |
| HTTP API | /api/v1/tools/json-to-sql/run |
| Browser-agent interface | run_current_tool |

### Implementation notes

ANSI-style quoted identifiers and string values. Review column types before executing SQL.

### Inputs and settings

Text input: JSON.

Example or placeholder shown in the interface (not a validated fixture):

```text
{"name":"Ada","count":2}
```

Use double-quoted property names and valid JSON values. Results update as you type. Up to 1,000,000 characters.

| Setting | Meaning | Control type | Default | Constraints |
| --- | --- | --- | --- | --- |
| `delimiter` | CSV separator | select | "," | Allowed: ,, ;, 	 |
| `table` | SQL table | text | "data" |  |

### HTTP contract

API calls process supplied data on the server. The website origin is `https://happytails.ai`. Server API hosting is not connected on the public website yet. Use your local server origin to test these requests.

```http
POST https://happytails.ai/api/v1/tools/json-to-sql/run
Content-Type: application/json
```

[Detailed operation reference](https://happytails.ai/en/api/tools/json-to-sql.md) · [Shared API guide](https://happytails.ai/en/api.md)

#### Limits

| Limit | Value |
| --- | --- |
| request_bytes | 8388608 |
| input_characters | 1000000 |
| files_bytes | 5242880 |
| max_files | 0 |
| timeout_seconds | 12 |

#### Complete input schema

```json
{
  "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"
        }
      }
    }
  }
}
```

#### Complete output schema

```json
{
  "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"
              }
            }
          }
        }
      }
    }
  }
}
```

#### Error and retry handling

Failures return a non-200 status and `error.code` plus `error.message`. Correct invalid input before retrying; retry server-busy responses with bounded backoff. Returned files contain Base64 data, not persistent download URLs. Decode and inspect the output before treating conversion as successful. See the shared API guide for the complete status and timeout rules.

### Browser-agent workflow

1. Open the human page in a browser that supports WebMCP.
2. Discover the interface exposed by that page; use its actual schema.
3. Select files on the page first when the tool requires files.
4. Call `run_current_tool` with valid input and settings.
5. Inspect the returned result or error and the displayed output. Retrieve files from the displayed download links.

Calls do not automatically copy or download results. Browser permissions still apply. Interface availability alone is not proof of successful execution.

### Planning specification

SQL dialect, table name and escaped literals; no execution; infer column types transparently.

This describes intended requirements. Use the implementation notes, interface schema and observed output to determine current support.

### Complete machine-readable capability record

```json
{
  "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

- [CSV to JSON](https://happytails.ai/en/data-tools/csv-to-json/): Convert CSV to JSON. ([Markdown](https://happytails.ai/en/data-tools/csv-to-json.md))

- [JSON to CSV](https://happytails.ai/en/data-tools/json-to-csv/): Convert JSON to CSV. ([Markdown](https://happytails.ai/en/data-tools/json-to-csv.md))

- [TSV to CSV](https://happytails.ai/en/data-tools/tsv-to-csv/): Convert TSV to CSV. ([Markdown](https://happytails.ai/en/data-tools/tsv-to-csv.md))

## How to use JSON to SQL

1. Enter json in the input field.
2. The result updates as you type. Adjust the available settings if needed.
3. 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.