SQL formatting and conversion, locally

A query pasted from a log file is one long line with no capitalisation. A query pasted from an ORM has literals inlined where parameters belong. These tools fix both, plus turn a dump of INSERT statements into JSON rows you can use as test data.

Queries frequently contain real values from real tables, which is a good reason to keep them on your own machine.

3 SQL tools

SQL Formatter

Format and beautify SQL for many dialects, with keyword casing, all local.

Local

SQL → JSON

Turn SQL INSERT statements into JSON rows, parsed locally in your browser.

Local

SQL Parameterizer

Replace inline literals in a SQL query with parameters and extract their values, locally.

Local