For some testing scenarios, we may need to update the SQL database with testing data (such as names, phone numbers, IPs, email addresses, city names, and filenames), or to allow the web service to respond with basic sample data. Here are some tools that can generate testing data based on the user-defined data type or format such as (date, address, ID, numeric data or strings):
Tools | Usage and scenarios |
Mockaroo |
This provides an online data generator service that provides test data in CSV, JSON, and SQL formats, based on your defined data type |
JSON Schema Faker |
This generates JSON data based on a defined JSON schema |
JS Faker |
This provides a command-line interface (CLI) to generate the data type based on your options, such as system, name, address, and phone. It can also output based on the specified locale language. |