SQL mock data generator

SQL Mock Data Generator

Generate realistic SQL test data and INSERT statements for MySQL, PostgreSQL, SQLite, and SQL Server. Define your schema, pick row count, and export seed scripts instantly.

Generate SQL test dataMySQL, PostgreSQL & SQLiteCREATE TABLE + INSERT exportRepeatable seed scripts

Table schema

Define columns and mock data types. Generation runs locally in your browser.

Column name

Mock type

Column name

Mock type

Column name

Mock type

Column name

Mock type

Column name

Mock type

Generator options

Table name

SQL dialect

Number of rows

Seed (optional)

Rows per INSERT statement

Include CREATE TABLE statementUse multi-row INSERT statements

Generated SQL

25 rows5 columnsMySQL

CREATE TABLE `users` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `full_name` VARCHAR(255),
  `email` VARCHAR(255),
  `status` VARCHAR(255),
  `created_at` DATETIME
);

INSERT INTO `users` (`full_name`, `email`, `status`, `created_at`) VALUES
('Margaret Turing', 'katherine.lovelace1@example.com', 'archived', '2024-06-30 21:50:26'),
('Margaret Lovelace', 'grace.martin2@example.com', 'pending', '2023-04-18 14:44:44'),
('Grace Gosling', 'linus.lovelace3@example.com', 'archived', '2023-11-26 21:12:14'),
('Barbara Liskov', 'sophie.torvalds4@example.com', 'inactive', '2024-12-19 12:57:24'),
('Alan Turing', 'ada.turing5@example.com', 'archived', '2024-11-28 17:44:42'),
('Grace Martin', 'grace.martin6@example.com', 'pending', '2024-07-18 08:25:37'),
('Dennis Ritchie', 'linus.turing7@example.com', 'archived', '2026-03-13 01:05:06'),
('Grace Hamilton', 'dennis.martin8@example.com', 'inactive', '2026-02-15 22:45:02'),
('Grace Johnson', 'alan.torvalds9@example.com', 'active', '2023-04-27 23:22:21'),
('Dennis Johnson', 'linus.turing10@example.com', 'pending', '2023-11-25 04:39:00'),
('Alan Martin', 'sophie.hamilton11@example.com', 'inactive', '2026-10-04 20:21:39'),
('James Johnson', 'margaret.ritchie12@example.com', 'inactive', '2022-03-11 20:48:14'),
('Dennis Ritchie', 'linus.turing13@example.com', 'active', '2026-07-08 23:59:11'),
('Sophie Martin', 'dennis.liskov14@example.com', 'pending', '2022-02-13 22:10:34'),
('Katherine Hamilton', 'margaret.lovelace15@example.com', 'active', '2023-04-13 22:26:50'),
('Linus Martin', 'dennis.hamilton16@example.com', 'inactive', '2024-10-10 01:50:34'),
('Margaret Turing', 'grace.turing17@example.com', 'inactive', '2026-02-18 19:46:48'),
('Linus Johnson', 'barbara.hamilton18@example.com', 'inactive', '2025-12-22 16:19:17'),
('Margaret Hamilton', 'dennis.lovelace19@example.com', 'archived', '2026-11-13 06:56:22'),
('Grace Torvalds', 'margaret.martin20@example.com', 'archived', '2022-08-05 22:23:53'),
('James Gosling', 'james.lovelace21@example.com', 'pending', '2025-10-22 12:22:32'),
('Barbara Turing', 'linus.hamilton22@example.com', 'inactive', '2025-06-04 09:27:23'),
('Ada Gosling', 'sophie.johnson23@example.com', 'active', '2024-03-29 16:06:45'),
('Barbara Turing', 'alan.martin24@example.com', 'archived', '2023-08-23 19:18:19'),
('Linus Lovelace', 'barbara.torvalds25@example.com', 'pending', '2023-05-21 15:19:33');

Define columns

Add column names and pick mock types like email, UUID, status, dates, and JSON.

Choose row count

Generate up to 1,000 rows with optional seed for repeatable test datasets.

Export SQL

Copy or download INSERT statements, with optional CREATE TABLE for local seeding.

Why developers use SQL mock data tools

Runs in the browser — no account, no upload, no server-side storage
Supports MySQL, PostgreSQL, SQLite, and SQL Server syntax
Useful for local development, demos, QA fixtures, and staging seed scripts
Pairs well with schema prototyping before wiring a real admin workflow

Have CSV already? Use CSV to SQL

Move from seed scripts to real operations

Mock data helps you bootstrap environments. When the database is live, Silent Dock gives teams a secure admin layer for imports, edits, audit logs, and day-to-day database operations.

Start free For developers

SQL mock data FAQ

What does this SQL mock data generator create?

It generates SQL INSERT statements from the column schema you define. You can optionally include a CREATE TABLE statement and export everything as a .sql file.

Which mock data types are supported?

The tool supports common field types such as integers, emails, names, phone numbers, UUIDs, dates, URLs, cities, companies, statuses, and JSON payloads.

Can I use the output in production databases?

The generator is intended for development, testing, and demo environments. For governed imports on live MySQL, PostgreSQL, or MongoDB data, Silent Dock provides secure operational tooling with RBAC and audit logs.

Is this different from the CSV to SQL tool?

Yes. The CSV to SQL tool converts existing spreadsheet data into INSERT statements. This mock data generator creates synthetic test rows from a schema without needing source CSV input.