Files
Query JSON files with SQL on Windows
Turn JSON and JSON Lines files into tables you can query with SQL. Point DataCraft at a folder and start asking questions, with no loading step.
Download FreeFree is $0 with a free account. For 64-bit Windows 10 and 11.
See it working
Real app screenshots from test workspaces with sample data, some cropped to the working area. A Pro build is shown.
What you get with JSON
SQL on JSON
Filter and sort records with SQL instead of writing a script.
JSON Lines too
Works with .json, .jsonl and .ndjson.
Read-only and safe
Your files aren’t changed.
Clear types
Column types are inferred and marked as inferred.
See the shape
Browse each file’s columns and statistics in the tree.
Export the answer
Save your results to a file.
Example
SELECT id, name
FROM "customers.json"
ORDER BY id
LIMIT 2;Free and Pro
Connections, the explorer, the query editor, autocomplete, results and export are in the Free plan. Pro adds saved workspaces, searchable history, visual builders, guided import, data migration, health diagnostics and the AI assistant, where JSON supports them. Compare plans.
Free is $0 with a free account. For 64-bit Windows 10 and 11.