About jsonTools
Fix broken JSON (single quotes, trailing commas, comments, missing quotes), pretty-print or minify it, query it with JSONPath, and validate it against a JSON Schema. Numbers too long for JavaScript, like 19-digit IDs, are kept digit for digit.
Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.
Built on open-source libraries: jsonrepair, JSONPath Plus, Ajv, CodeMirror 6.
From the makers
Pilotbase: one client for every database you run (PostgreSQL, MySQL, MongoDB, Redis and more), with an AI agent built in.
Get Pilotbase freeMore free data tools
sqlBeautify
Format, highlight and fix SQL as you type
sqlCompare
Diff two SQL files like git, after formatting both
downtimeAlert
We check your URL, API or stats page every 30 seconds and email you when it's down
sqlTranslate
Convert SQL between 14 dialects
explainViewer
See where a Postgres query spends its time
keysetBuilder
Keyset pagination queries from your ORDER BY