JSON SQL Analyzer
Desktop Required
JSON SQL Analyzer is optimized for desktop use. Please open this tool on a larger screen.
JSON SQL Analyzer
Query massive JSON, CSV, TSV, and Parquet files instantly with SQL in your browser.
Loading query engine...
DuckDB WASM is initializing
Your data never leaves this device. All processing happens locally in your browser.
What is JSON SQL Analyzer?
Query massive JSON, CSV, TSV, and Parquet files directly in your browser using standard SQL. This tool uses DuckDB compiled to WebAssembly to provide a blazing fast SQL engine without sending any data to a server.
- Fully local processing. Your files never leave your device. Suitable for highly sensitive logs and datasets.
- Supports JSON arrays, NDJSON, CSV, TSV, and Parquet. Large files up to 1GB chunked efficiently.
- Nested objects are fully supported! Query them using JSON dot notation directly in SQL.
You might also like
Validate, format, and beautify your JSON data with ease.
Shuffle and randomize any list. Import from CSV, Excel, or add items manually. Save and reload versions.
Generate universally unique identifiers (UUIDs). Support for v1 (timestamp) and v4 (random) with bulk generation.
Decode and inspect JSON Web Tokens to check their payload and signature.