Load JSON or NDJSON, inspect tables/columns, infer keys and relationships, and export evidence and DDL.
Quick Start
- Upload or paste your JSON/NDJSON dump.
- Check Overview → Adapter Diagnostics; enable “Extract nested arrays” if child tables exist.
- Use Keys and FKs tabs to validate uniqueness and relationships. Toggle confirm passes in Settings for full-table verification.
Keys & FKs
- Keys show uniqueness, duplicates, confidence (surrogate/natural hints), and CSV export.
- FKs show coverage, orphans, confidence, and “Confirmed” after confirm passes. Orphan samples can be previewed and exported.
Deep Links
- Keys dupes:
#tab=Keys&table=Orders&keyCols=id&open=dupes&dupeKey=123 - FK orphans:
#tab=FKs&edgeFrom=Orders&edgeFromCols=customer_id&edgeTo=Customers&edgeToCols=id&open=orphans&orphanKey=999
Exports & DDL
- Structured HTML report with graph, issues, keys, FKs, and CSV links (All/Broken FKs include deltas, confidence, confirmed).
- DDL: configure NOT NULL threshold, ON DELETE/UPDATE policies; strings sized by sample; decimals inferred; TZ detected.
JSONPath
- Run simple paths against the result; builders help target columns and types; save/load presets.
Troubleshooting
- Ambiguous adapter scores or small samples: adjust thresholds or confirm passes in Settings.
- Type coercion (trim/numeric) affects FK checks; tune in Settings.
Tip: Press ? to open this help. Share with #help=open.