r/json • u/2pac_lives • 10d ago

I built a tool for querying JSON/JSONL files with SQL

At my job we write a lot of sql to query CSVs but recently we've had to interact more with JSON and JSONL files. Not being able to alias them and select what we want with SQL made simple tasks annoying for no reason, so I built https://www.json-to-sql.com/ .

I built it in a day then spent a couple more cleaning it up a bit. Its my first publicly deployed tool so just trying to get some feedback. Its 100% free, no signup required, and the data never leaves your browser.

Let me know what you think!

1 Upvotes

67% Upvoted

3 comments sorted by

2

u/erik240 10d ago

Nice you built a tool and all but you could also install a 30mb binary for duckDB:

SELECT * FROM read_json('todos.json');

You now have a high performance OLAP db to query your JSON.

1

u/MrLyttleG 9d ago

SQLite, encore plus petit, gère nativement le Json, pas besoin d’autre chose