Test Data Generator

✓ functional

Deterministic, dialect-correct INSERT scripts built from a table's real column metadata.

Generate deterministic, dialect-correct INSERT scripts for a table, built from its real column metadata - types, nullability, and keys - so the sample data actually fits the schema you have. Name the table, choose a row count (up to 10,000), a NULL percentage for nullable columns, and a seed: the same seed always produces the same data, so a test fixture stays reproducible.

Load Columns reads the table's catalog and lists every column with an inferred generator - names, words, integers, decimals, dates, GUIDs, and friends - chosen from the column's type and name; click any column to cycle it to a different generator. Identity and computed columns are skipped automatically, values are clamped to each column's declared length and precision so nothing truncates or overflows, and Script INSERTs emits the batch (500 rows per statement, headed by a comment recording the row count and seed) into a query tab. It never writes to the server itself.

SQLly Test Data Generator — Test Data Generator: choose a table and row count; SQLly emits INSERT statements matching the column types.

Supported on SQL Server, PostgreSQL, MySQL/MariaDB, and SQLite; each engine's own catalog and quoting rules are used for the script.