JSON Analysis

Query JSON and NDJSON files with SQL

SQL for Files turns JSON arrays and newline-delimited JSON into DuckDB tables so you can filter, join, and summarize nested exports locally.

Open the editorRead the docs

Supports JSON arrays and NDJSON records

Useful for API exports, logs, and application data snapshots

DuckDB SQL support for filtering, grouping, joining, and unnesting

All processing happens in the browser

Example queries

Filter imported JSON records

SELECT id, status, created_at
FROM events
WHERE status = 'active'
ORDER BY created_at DESC;

Summarize JSON events

SELECT type, COUNT(*) AS events
FROM events
GROUP BY type
ORDER BY events DESC;