Transform copied values into single- or double-quoted lists for MySQL and Trino IN queries

[Sophia willsons]

Not sure if this is just me, but I feel like I spend way too much time dealing with broken or messy JSON instead of actually working on features.

APIs returning half-baked responses, trailing commas sneaking in, copy-pasting JSON from logs or emails that suddenly won’t parse… you know the drill. Most of the time I don’t even want to learn why it’s broken — I just want to quickly see what’s wrong and fix it.

I’ve used the usual formatters/validators, but a lot of them either:

• just say “invalid JSON” and stop there, or

• are overloaded with ads and popups, or

• feel like they were built only for experts

Recently I stumbled across unblockdevs.com while debugging an API response, and what I liked was how straightforward it felt. Paste JSON → see exactly where it breaks → fix it → move on. No login, no weird flows.

Not saying it’s the only tool out there, but it’s been handy enough that I’ve bookmarked it and keep it open alongside Postman now.

Curious what others here use for:

• fixing malformed JSON

• quickly viewing large payloads

• comparing two API responses

Always looking to reduce the “why is this invalid” time sink 😅