Database Utility Suite

Table to SQL Insert Statement Generator

Generate realistic mock/dummy data INSERT statements directly from a SQL CREATE TABLE schema query. Auto-parse column names, detect SQL types, and configure bulk outputs client-side.

Generator Options

SQL Table Name

Mock Rows to Generate10 rows

SQL Dialect

Insert Statements Layout

Max Rows per Insert Statement

SQL Formatting Switches

Quote table & fields

Include CREATE TABLE statement

Wrap inside Transaction block

Boolean Literal Style

Quick Helpers

SQL CREATE TABLE Schema Query

Define table structure

10Mock Rows

6Columns

29SQL Lines

1.2 KBSQL Size

Parsed Database Schema Fields

-- SQL INSERT Statements Generated by ToolKH
-- Source: Mock Data generated from CREATE TABLE schema
-- Dialect: MYSQL
-- Generated Date: 2026-07-26

-- CREATE TABLE Schema Script
CREATE TABLE employees (
  emp_id INT PRIMARY KEY,
  full_name VARCHAR(100) NOT NULL,
  email VARCHAR(150),
  salary DECIMAL(10, 2),
  is_active BOOLEAN DEFAULT TRUE,
  joined_date DATE
);

START TRANSACTION;
INSERT INTO `employees` (`emp_id`, `full_name`, `email`, `salary`, `is_active`, `joined_date`) VALUES
  (101, 'Sok Dara', 'sok.dara@example.com', 875.5, true, '2026-01-15'),
  (102, 'Chan Sophea', 'chan.sophea@example.kh', 1025.5, false, '2026-01-20'),
  (103, 'Keo Nary', 'keo.nary@company.com', 1175.5, true, '2026-01-25'),
  (104, 'Lim Bunna', 'lim.bunna@toolkh.org', 1325.5, false, '2026-01-30'),
  (105, 'Mary Smith', 'mary.smith@db.net', 1475.5, true, '2026-02-04'),
  (106, 'John Doe', 'john.doe@example.com', 1625.5, false, '2026-02-09'),
  (107, 'Jane Smith', 'jane.smith@example.kh', 1775.5, true, '2026-02-14'),
  (108, 'David Miller', 'david.miller@company.com', 1925.5, false, '2026-02-19'),
  (109, 'Michael Brown', 'michael.brown@toolkh.org', 2075.5, true, '2026-02-24'),
  (110, 'Emily Davis', 'emily.davis@db.net', 2225.5, false, '2026-03-01');

COMMIT;