Array, list, JSON, CSV, SQL, and TOON tools

Compare two lists and find values only in A, only in B, shared values, union, or symmetric difference with configurable matching rules.

Convert lists between newline, comma, tab, pipe, semicolon, space, and custom delimiters with trimming, quotes, and deduplication.

Remove duplicate lines while preserving order, keep first or last occurrence, and control case, whitespace, blank lines, and Unicode normalization.

Sort text lines alphabetically, naturally, numerically, by length, or in reverse with trimming, blank-line, and duplicate controls.

Split a list by items per batch, target batch count, or maximum characters and copy or download each generated chunk.

Filter pasted lines with plain text or safe regular expressions, preserve original line numbers, and keep, remove, or extract matching content.

Parse JSON arrays and safe JavaScript, Python, or PHP-style scalar arrays into text lines, CSV, or a custom-delimited list without executing code.

Generate combinations, permutations, selections with repetition, or Cartesian products from pasted lists with exact counts and safe output limits.

Infer TypeScript interfaces, type aliases, and Zod schemas from JSON objects or arrays using every sample record and explicit conflict diagnostics.

Convert nested JSON to modern or legacy PHP array syntax and safely parse supported PHP scalar arrays back to JSON without executing code.

Convert CSV or TSV to JSON and JSON arrays to CSV using quoted-field parsing, header controls, type detection, table preview, and downloads.

Extract one or more CSV columns by header or index and export them as text lines, JSON, code arrays, or SQL values.

Evaluate RFC 9535 JSONPath expressions safely against JSON and inspect matched values, normalized paths, and JSON Pointers without executing query code.

Convert JSON arrays to JSONL or NDJSON and line-delimited records back to JSON with exact line errors, record counts, and downloads.

Flatten nested JSON into path-value pairs or safely unflatten paths using dot, bracket, slash, or custom separators with collision detection.

Merge multiple JSON objects using shallow, deep, or RFC 7396 Merge Patch behavior with configurable array and conflict strategies.

Compare arrays of JSON objects by one or more identity properties and report added, removed, changed, unchanged, and duplicate-key records.

Generate JSON Schema Draft 2020-12 or Draft 7 from objects and arrays with required-field intersection, nullable types, formats, and conflict reports.

Convert pasted IDs, strings, numbers, or UUIDs into SQL IN or NOT IN clauses, escaped literals, or parameterized placeholders.

Convert arrays of JSON objects into reviewed CREATE TABLE and batched INSERT statements with multi-record type inference and SQL dialect controls.

Convert JSON to TOON specification 4.1 and TOON back to JSON using the official codec, strict decoding, round-trip checks, and size comparisons.

Validate TOON 4.1 strictly, inspect line-aware decoding errors, preview JSON structure, and format valid documents through canonical re-encoding.