SQL INSERT Statements to JSON Array Converter

API Testing Ready

Extract table rows from SQL INSERT and CREATE statements and generate valid JSON datasets for API testing, frontend mock fixtures, and database seeders. Zero data transmission.

#sql to json converter#parse sql insert to json#sql dump to json

Presets:

Filter / Target Table

Output Format

JSON Key Casing

JSON Indentation

Type Cast Toggles:Cast NumbersCast Booleans (TRUE/FALSE)Parse Embedded JSON ColumnsEvaluate NOW() to ISO DateRetain NULL Values

SQL Source Statements

19 lines•1.3 KB

-- E-Commerce Store Products Catalog
CREATE TABLE `products` (
  `id` INT PRIMARY KEY AUTO_INCREMENT,
  `sku` VARCHAR(32) NOT NULL,
  `title` VARCHAR(120) NOT NULL,
  `category` VARCHAR(50) NOT NULL,
  `price` DECIMAL(10, 2) NOT NULL,
  `stock_quantity` INT NOT NULL DEFAULT 0,
  `is_featured` BOOLEAN DEFAULT FALSE,
  `rating` DECIMAL(3, 2) DEFAULT 5.00,
  `metadata` JSON,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO `products` (`id`, `sku`, `title`, `category`, `price`, `stock_quantity`, `is_featured`, `rating`, `metadata`, `created_at`) VALUES
(101, 'KB-MECH-PRO', 'RGB Mechanical Gaming Keyboard', 'Electronics', 129.99, 45, true, 4.85, '{"switch": "Cherry MX Red", "backlight": "RGB", "layout": "ANSI"}', '2026-03-12 10:30:00'),
(102, 'MS-WIRELESS-X', 'Ultra-Lightweight Wireless Mouse', 'Electronics', 69.50, 110, true, 4.90, '{"dpi": 26000, "weight_grams": 59, "battery_hours": 80}', '2026-03-14 14:15:00'),
(103, 'MN-4K-CURVED', '34-Inch Curved Ultrawide Monitor', 'Displays', 499.00, 18, false, 4.70, '{"refresh_rate": 165, "resolution": "3440x1440"}', '2026-03-20 09:00:00'),
(104, 'HP-NOISE-ANC', 'Active Noise Cancelling Headphones', 'Audio', 199.95, 0, false, 4.60, '{"anc": true, "codecs": ["LDAC", "AAC", "aptX"]}', '2026-04-01 16:45:00');

Supports MySQL, PostgreSQL, SQLite, MariaDB, SQL Server dumps

[
  {
    "id": 101,
    "sku": "KB-MECH-PRO",
    "title": "RGB Mechanical Gaming Keyboard",
    "category": "Electronics",
    "price": 129.99,
    "stock_quantity": 45,
    "is_featured": true,
    "rating": 4.85,
    "metadata": {
      "switch": "Cherry MX Red",
      "backlight": "RGB",
      "layout": "ANSI"
    },
    "created_at": "2026-03-12 10:30:00"
  },
  {
    "id": 102,
    "sku": "MS-WIRELESS-X",
    "title": "Ultra-Lightweight Wireless Mouse",
    "category": "Electronics",
    "price": 69.5,
    "stock_quantity": 110,
    "is_featured": true,
    "rating": 4.9,
    "metadata": {
      "dpi": 26000,
      "weight_grams": 59,
      "battery_hours": 80
    },
    "created_at": "2026-03-14 14:15:00"
  },
  {
    "id": 103,
    "sku": "MN-4K-CURVED",
    "title": "34-Inch Curved Ultrawide Monitor",
    "category": "Displays",
    "price": 499,
    "stock_quantity": 18,
    "is_featured": false,
    "rating": 4.7,
    "metadata": {
      "refresh_rate": 165,
      "resolution": "3440x1440"
    },
    "created_at": "2026-03-20 09:00:00"
  },
  {
    "id": 104,
    "sku": "HP-NOISE-ANC",
    "title": "Active Noise Cancelling Headphones",
    "category": "Audio",
    "price": 199.95,
    "stock_quantity": 0,
    "is_featured": false,
    "rating": 4.6,
    "metadata": {
      "anc": true,
      "codecs": [
        "LDAC",
        "AAC",
        "aptX"
      ]
    },
    "created_at": "2026-04-01 16:45:00"
  }
]

4 rows•1 tables•10 max cols

Size: 1.4 KB•Ready for API Mocking

How to Convert SQL INSERT Statements to JSON for API Testing

Modern frontend and API developers frequently encounter SQL dumps from production or staging databases that need to be transformed into JSON fixtures, mock servers (MSW / JSON Server), or unit test payloads.

Paste SQL Statements or Upload Dump

Paste SQL queries containing CREATE TABLE and INSERT INTO statements, or drop your .sql export file directly onto the input panel.

Configure Formatting & Casing

Select between JSON Arrays, API Envelopes, or NDJSON. Use the Casing selector to transform database snake_case columns into REST-compliant camelCase keys automatically.

Inspect, Copy or Download

Review your dataset using the interactive Table Preview, copy the output with one click, or download TypeScript interface definitions directly into your codebase.

Frequently Asked Questions (FAQ)

Is my SQL database dump kept private?

Yes, 100%. All lexical tokenization, regex matching, and JSON transformations execute exclusively inside your web browser client using client-side JavaScript. Zero network packets are dispatched to any server.

What happens if an INSERT statement omits column names?

When column names are omitted in the INSERT statement (e.g. INSERT INTO users VALUES (...)), this tool automatically reads the previous CREATE TABLE definition to resolve column identifiers. If none is present, sequential identifiers like col_1, col_2 are safely assigned.

How are SQL data types, NULLs, and escaped quotes handled?

The parser recognizes SQL single quotes, double quotes, and escaped quotes (such as O''Reilly or \'). NULL and \N map to JSON null, and embedded JSON string columns can optionally be parsed directly into nested JSON structures.

Which SQL engines and dialects are supported?

The converter is dialect-agnostic and supports dumps from MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server, and Oracle DB, accommodating backticks, double quotes, square brackets, multi-row tuples, and comments.