Live demo — your changes won't be saved. Import and export are disabled.

PumaQuery — JSON / CSV explorer with SQL

SQL editor

Ready Run with ⌘/Ctrl+ · Save with ⌘/Ctrl+S

Result

Drop a .json, .csv, or .tsv file anywhere on this window — or paste with ⌘/Ctrl+V.
Then write SQL above and press ⌘/Ctrl+.