SQL test data generator

Q: Which databases can use the generated SQL?

The portable inserts work with PostgreSQL, MySQL and SQLite in common schemas; dialect-specific features may need edits.

Q: Can I generate rows without CREATE TABLE?

Yes. Disable the Create table option to export only INSERT statements.

Turn a schema into ready-to-run INSERT statements — with an optional CREATE TABLE whose column types are inferred from your fields. Seed a dev database in one command.

Generate SQL inserts → Browse field types

What the output looks like

CREATE TABLE customers (
  id INTEGER,
  full_name TEXT,
  email TEXT,
  is_active BOOLEAN
);
INSERT INTO customers (id, full_name, email, is_active) VALUES
  (1, 'Elena Rossi', 'elena.rossi7@example.org', TRUE);

Why SQL export?

Sometimes the fastest way to a populated dev database is a plain .sql file: no ETL tool, no ORM seeder, just psql -f or mysql <. The generator writes standard INSERT statements, escapes quotes correctly, renders blanks as NULL, and can prepend a CREATE TABLE whose column types (integer, decimal, boolean, text) are inferred from your field types.

SQL-specific options

Table name — set it once; it is used in both the CREATE TABLE and every INSERT.
Create table toggle — turn it off when the table already exists and you only want rows.
Seed — the same seed regenerates the exact same script, so your whole team seeds identical databases.

Quick recipe: seed Postgres

psql -d mydb -f fundata_1000_rows.sql

Database compatibility and safety

The generated script uses portable SQL literals: text is single-quoted with embedded quotes escaped, numbers remain unquoted, booleans use TRUE/FALSE and missing values become NULL. It is designed for disposable development and test databases. Review inferred column sizes, constraints and dialect-specific identifiers before applying a script to an existing schema; the tool never connects to your database.

Common SQL questions

Which databases can use the generated SQL?

The simple inserts work with PostgreSQL, MySQL and SQLite in common schemas. Dialect-specific types, quoted identifiers, auto-increment clauses and constraints may need a small edit.

Can I generate rows without CREATE TABLE?

Yes. Disable the Create table option and the export contains only INSERT statements for the table name you provide.

Plan realistic schemas and repeatable seeds with the database test-data guide.

Other formats

The same schema exports to all six formats — switch with one dropdown: CSV, TSV, JSON, NDJSON, XML. New here? Start with the getting-started guide or the full field type reference.