SQL Mock Data Generator
This tool allows you to generate SQL mock data that you can use to populate an empty table in your Firebird Database.
It uses Mockaroo API backend.
- Instantly generate data to populate your table
- Over 50 different data types
- Results formatted as SQL INSERT statement
- Get your API key here.
- Put your API key into required field under extension settings (VS Code > Settings > Firebird Mockaroo Api Key).
After you've added an API key, go back to your Firebird DB Explorer tree view, expand the database and right-click the table you want to generate data for:
You will be presented with the tool's main screen that contains selected table's field names together with the field type and null/not null attributes:
For each field, select from the predefined generator data types list. Start typing to filter the list:
HINT: Some of predefined data types have additional options. Remember to adjust them before clicking GENERATE DATA
After every field type has been selected and options adjusted accordingly, select the number of rows you want to generate, hit the button, et voilà!
