🔄 JSON to SQL INSERT

Ready
Field mapping (optional)

Display field list after parsing JSON

Data Preview

Display data preview after parsing JSON

Instructions for use

Supported input formats

  • Single object: {"name": "张三", "age": 25}
  • Object array: [{"name": "张三"}, {"name": "李四"}]

Database Difference

  • MySQL : Support INSERT IGNORE, REPLACE INTO, batch insert
  • PostgreSQL : Use ON CONFLICT DO NOTHING
  • SQLite : Support INSERT OR IGNORE, INSERT OR REPLACE
  • SQL Server : Use square brackets to wrap identifiers
  • Oracle : Use INSERT ALL syntax

Notes

  • String values will automatically escape single quotes
  • A null value produces NULL
  • Boolean value converted according to database type
  • Nested objects will be converted to JSON strings