sqloth

offline SQL dummy data generator!!

"you want dummy SQL data for test? will like sqloth...!"

🎉 Features 🎉

• ✅ completely offline, which means you can use confidential schema
• ✅ automatically analyze foreign key dependencies and generate data along with them
• 🚫 fast calculation, 1M records for XX secs!
  • currently, the limit is around 10,000 records (100 records for 100 columns)...!
• 🚫 variable formats for random data generation. you can set prefix, suffix and randomize methods(e.g. uuid)!
  • currently, generate perfectly random data. you cannot set prefix, suffix or randomize methods...!

📦 Install 📦

Please download the binary. That's all!!

💻 Usage 💻

Please run the below.

./sqloth -f ./path/to/your/schema.sql -n [the # of records you want]

Here is an example of input and output.

$ sqloth -f ./schema.sql -n 10 > dummy.sql

$ cat dummy.sql

SET foreign_key_checks = 0;

INSERT INTO customer(`created_at`, `name`, `material`)
VALUES ('1982-02-12 12:22:27','Lhras20e...r7U3','{"json":"7647947524"}'),
...
('2021-11-05 11:32:13','aioI...I5t','{"json":"8493280504"}'),
('2004-05-11 00:57:27','86MI...PVn','{"json":"7486664121"}');

INSERT INTO product(`name`, `owner`, `description`, `stock`, `sale_day`)
VALUES ('Eq...fW','Lhr...U3','gILE...FDvK','0','2015-10-30 05:21:22'),
...
('SQU..62v','waN...Imm','kwL...gh8','1','2010-01-30 14:51:37'),
('ceJ...3xl','KvR...1Nm','NN4...vky','0','2022-03-08 05:43:08');

SET foreign_key_checks = 1;

✅ Support Information(v1.0.1) 🚫

RDBMS

RDBMS	Supported
MySQL	✅ Yes
Oracle	🚫 No
PostgreSQL	🚫 No

Type Attributes

Type Attributes	Supported
UNSIGNED	✅ Yes
AUTO_INCREMENT	✅ Yes
ZEROFILL	🚫 No
CHECK	🚫 No

Data Types

Data Category	Data Type	Supported
Numeric	INTEGER	✅ Yes
	TINYINT	✅ Yes
	SMALLINT	✅ Yes
	MEDIUMINT	✅ Yes
	INT	✅ Yes
	BIGINT	✅ Yes
	DECIMAL	🚫 No
	NUMERIC	🚫 No
	FLOAT	🚫 No
	DOUBLE	🚫 No
	BIT	🚫 No
	DOUBLE	🚫 No
Date&Time	DATETIME	✅ Yes
	TIMESTAMP	✅ Yes
	DATE	🚫 No
	TIME	🚫 No
	YEAR	🚫 No
String	VARCHAR	✅ Yes
	CHAR	🚫 No
	VARBINARY	✅ Yes
	BINARY	🚫 No
	TEXT	✅ Yes
	BLOB	🚫 No
	ENUM	🚫 No
	SET	🚫 No
JSON	JSON	✅ Yes
Spatial	any spatial type	🚫 No

🌟 Contribution 🌟

• Let's be creative and collaborative👶
• Please read CONTRIBUTING.md for the details😉