Mockaroo
Mockaroo generates synthetic test data and mock back-end APIs, including for front-end development before a back end is ready. Users can select from more than 100 built-in data types, upload reference data, or create types with the formula API. The Generate API produces JSON, CSV, tab-separated text, custom-delimited text, SQL, and XML. Mock APIs can map request parameters to schemas, return dynamic or static data, and simulate errors. Both APIs require an API key, supplied as a query parameter or an X-API-Key header. The Free plan costs 0.00 USD per free and provides 1,000 rows per file and 200 API requests per day. Silver costs 60.00 USD per year; Gold costs 500.00 USD per year. Synchronous API responses are limited to 5,000 records on every plan, and background generation requires a paid plan. Enterprise is 7500.00 USD per year and is distributed as a Docker image for private cloud or datacenter deployment. Mockaroo is available through its web service, API, and self-hosted options.
Who it is for
Mockaroo suits developers and testers who need realistic generated test data. Its mock APIs also suit front-end developers who need sample back-end behavior before a back end is ready.
What is good
- More than 100 built-in data types
- Supports JSON, CSV, SQL, XML, and other formats
- Can simulate API errors or return static data
- Free plan includes 1,000 rows per file
- Enterprise deployment offered as a Docker image
What to know first
- Free plan allows 200 API requests per day
- Synchronous API responses capped at 5,000 records
- Background generation requires a paid plan
- Both APIs require an API key
Verdict
Mockaroo combines synthetic data generation with API mocking, with multiple formats and data-type options. Check the per-plan row and API limits, and note that synchronous responses have a separate 5,000-record ceiling.
Mockaroo plans and pricing
All plansCompared on test data generation tools
- Free plan
- Yes
- Generation modes
- synthetic
- Relational data
- Yes
- API data generation
- Yes
- Supported data formats
- CSV, JSON, SQL, Excel, TXT, custom-delimited text, XML
- Deployment
- hybrid
- Generation limit
- 100,000 records
Best Mockaroo alternatives
See all 12
Free6.6 YData SDK Free plan apiLinuxMacself-hostedWin 
Free6.6 dbForge Studio for PostgreSQL Free plan LinuxMacWin 
$7.50/mo6.5 MOSTLY AI Free plan apiLinuxself-hostedWeb 
Free6.5 DummyJSON Free plan apiWeb 
Free6.4 Tonic Fabricate Free plan apiself-hostedWeb 
$29/mo6.4