SQL JSON Converter
Turn SQL INSERT statements into an array of JSON objects (columns become keys) or flip the direction to generate INSERTs from JSON. Handles quoted identifiers, escaped strings, NULLs, numbers, and booleans.
Features
- Bidirectional SQL INSERT ↔ JSON conversion
- NULL, boolean, numeric, and string support
- Custom table name on the way back to SQL
- Row count and preview output
Frequently Asked Questions
- Which SQL dialects are supported?
- Standard ANSI INSERT syntax works across MySQL, PostgreSQL, SQLite, and SQL Server. Values are parsed as strings, numbers, booleans, or NULL.
- Can I go from JSON back to SQL?
- Yes. Provide a JSON array of objects and a target table name - the tool emits a matching INSERT statement.
- How are strings with quotes handled?
- Single-quote doubling ('') and double-quote doubling ("") are both parsed and emitted correctly.